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=936 AND c2c.type=3 AND c.contactDeleted=0 AND c.published=1
ORDER BY contactId
New U.S. Air Force Leaders Recast F-22 Retirement Plans
Details
More Products & Services
Products & Services
Home - Aviation Group Marketing
Aviation Week Network
120 data points on over 156,000 commercial and business aviation aircraft, including military transports. Discover the most trustworthy resource for the complete aircraft history, plus ad hoc reports, month-over-month trend analysis and details on expected deliveries through 2050.
Aerospace | Aviation Week Network
Aviation Week Network
https://aviationweek.com/themes/custom/particle/dist/app-drupal/assets/awn-logo.svg
People
Andrea Rossi Prudente
Aviation Week Network
Becca Balmes
Aviation Week Network
Belinda Tan
Aviation Week Network
Brian Everstine
Aviation Week Network
Editor
Eddie Krankowski
Aviation Week Network
Assistant Manager, Tradeshows
erving dockery
Aviation Week Network
Lisa Tan
Aviation Week Network
Senior Marketing Manager
Mark Thomas
Aviation Week Network
Description
With no replacement in sight and a $14 billion pipeline of upgrades in progress, the U.S. Air Force's niche fleet of Lockheed Martin F-22 Raptors is suddenly enjoying a long, bright future. After being marked three years ago for retirement by the end of this decade by a former Air Force chief 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