AD 2012-16-14
Registered aircraft · 779
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2012-16-14')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-16-14')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2012-16-14') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-16-14') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N349TTBlackhawk Adventures LLC · Tampa, FLN351SPSonoco Products Co · Hartsville, SCN352CKKalitta Charters LLC · Ypsilanti, MIN355CDSound Trak Inc · Omaha, NEN355UALopez Fabio A · Denver, NCN35KVMit Oregon LLC · Portland, ORN360AVBsc Enterprises LLC · Tulare, CAN361DDWeco West LLC · Catarina, TXN362XPOverseas Transcom Corp Inc · Jacksonville, FLN365SSStallings Robert W · Frisco, TXN36CDBaltimore Hawk LLC · Easton, MDN370RVAero Jet Aviation I Inc · Fort Lauderdale, FLN372GBAtlas Dutch LLC · Fort Lauderdale, FLN373DGAttorney Aviation LLC · Dallas, TXN375RC2022 Olivia Av LLC · Austin, TXN375TWHalcyon Aviation LLC · New York, NYN377JCCorsa Horizon LLC · Muskego, WIN382BAN435sc LLC · Chagrin Falls, OHN382KUMaverick Aire LLC · New Castle, CON383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN383MVN383mv LLC · Amarillo, TXN383TKThk Holdings LLC · Cincinnati, OHN385MHGuardian Flight LLC · Lewisville, TXN387TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN388BBPw Transport LLC · Lafayette, LAN38MGBay Venture Management LLC · Atlanta, GAN395HEBillron LLC · Houston, TXN3BMMorris Communications Co LLC · Augusta, GAN3RCGlenbrook Aviation LLC · Fort Wayne, INN400GSGreen Savoree Transportation LLC · Carmel, INN401LJDavis Air LLC · Vero Beach, FLN403LSRa Aviation Holdings LLC · Prosper, TXN404FWcf Aircraft LLC · Detroit, MIN404FZBogey Bird II Inc · Jeffersonville, INN406TMAlcyone Trust Corp Trustee · Wichita, KSN40BGAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedN40GPBank Of Utah Trustee · Salt Lake City, UTN40LBFirst Premier Corp · Sioux Falls, SDN40PDLear Flight LLC · Reno, NVN410LSLitania Sports Group Inc · Champaign, ILN411SCRegistered aircraftN412SWThunderforce Investments LLC · Washington, DCN413VLFalcon Vl LLC · Wilmington, DEN417TMCpj2 LLC · Garden City, NYN418CLNnumber LLC · Wilmington, DEN41MBRivers Equipment LLC · Nashville, TNN41UARazorback Foundation Inc · Fayetteville, ARN424TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN424TJTj Aviation LLC · Sacramento, CAN425MSweeney Holding Voyager LLC · Leander, TX
Back to AD 2012-16-14