SELECT c.*, co.companyName as newCompanyName, cntry.code AS countryCode
FROM fmf6a_showcase_company2contact AS c2c
LEFT JOIN fmf6a_showcase_contact c ON c2c.contactId = c.id
LEFT JOIN fmf6a_showcase_company co ON c.companyId = co.id
LEFT JOIN fmf6a_showcase_country cntry ON c.countryId = cntry.id
WHERE c2c.isDeleted=0 AND c2c.companyId=2914 AND c2c.type=3 AND c.contactDeleted=0 AND c.published=1
ORDER BY contactId
STRUCTURES
Sekisui Aerospace has a long track record of manufacturing primary structural aerospace components for the general aviation, commercial aerospace, unmanned aerial vehicles, and defense markets.
Description
More Products & Services
Description
Sekisui Aerospace has a long track record of manufacturing primary structural aerospace components for the general aviation, commercial aerospace, unmanned aerial vehicles, and defense markets. Sekisui Aerospace's focus is on build to print structures, fabricated with a variety of manufacturing processes providing exactness in repeatability and targeting the lowest cost processing methods. Sekisui Aerospace engineering team provides design to manufacturing support that has helped our customers save millions of dollars over the life of their programs. Trust is earned as we focus on providing you low cost solutions to meet your products demanding needs.
Share
Recent Chats
Share via email
Future: handle WhatsApp here
Future: handle LinkedIn here
Future: handle Twitter here
SUBMENU HERE
Share via Chat
Copy Link