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=186 AND c2c.type=3 AND c.contactDeleted=0 AND c.published=1
ORDER BY contactId
GEs T901 engine is ready for the future of the US Army rotorcraft aviation
GE's T901 Engine for ITEPA test cell is not a combat mission. In combat, there is no time for an unproven design. With more than 100 million flight hours of ...
Description
More Products & Services
Products & Services
Military Services
GE Aerospace
From parts supply to total logistics support, GE has the right program to support your maintenance needs -- and keep more of your assets in their theater of operation. Our extensive maintenance management experience can maximize your engine and parts availability by improving procurement lead time and boosting shop productivity.
Military Engines
GE Aerospace
Building on an unsurpassed legacy of success, GE continues to execute on bold technical initiatives to ensure even more demonstrable support to the warfighter and those in need of humanitarian relief.
Military Systems
GE Aerospace
GE Aviation's Systems business is equipping militaries with the solutions needed to succeed. As a leading supplier of integrated systems and technologies for combat aircraft, military transport, helicopters, land vehicles and unmanned aerial vehicles (UAVs), GE is enabling armed forces around the world to improve reliability and enhance operational performance.
People
Description
GE's T901 Engine for ITEPA test cell is not a combat mission. In combat, there is no time for an unproven design. With more than 100 million flight hours of ...
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