AD 96-18-13
Registered aircraft · 1,110
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:96-18-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13')
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:96-18-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13') 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.
N800FJAstra Aircraft Holdings Corp · Wilmington, DEN800GMCadre Aviation Services LLC · San Antonio, TXN800JMGreen Chair Productions Inc · Wichita Falls, TXN800LQAdc Aviation LLC · Birmingham, ALN800MAMarco Aviation LLC · Nazareth, PAN800NJGlobal Empire Trust LLC · Fort Lauderdale, FLN800PAVance And Priscilla Hinton LLC · New Braunfels, TXN800PEFour C Air Inc · Delano, CAN800RGRm13 Air LLC · Wellington, FLN800SEDodson International Parts Inc · Rantoul, KSN800THHoover Aviation LLC · Nashville, TNN800TLN800tl LLC · Wilmington, DEN800UKJ W Construction Co Inc · Wise, VAN800VRCkv Express LLC · Minneapolis, MNN800WAKmwflight LLC · Wilmington, DEN800WHGsmh LLC · Daniel Island, SCN800WWPnw Transport LLC · Tucson, AZN801RMBlue Skies Hawker LLC · Canton, MIN802CFLitton Global LLC · Wilmington, DEN802WJXoom Enterprises LLC · Sunny Isles Beach, FLN803ACOptimumedicine LLC · Las Vegas, NVN804BHMahaska Bottling Co · Oskaloosa, IAN804JMStarr Aviation Solutions LLC · New York, NYN804MC824 Holdco LLC · Salt Lake City, UTN804TBN804tb III LLC · Stuart, FLN805DWCwy Investments LLC · Lawrenceville, GAN806GJPb Air LLC · Higley, AZN806MNJm Soar LLC · Paradise Valley, AZN806SQBeco Aviation LLC · Nevada, TXN808MCLrt Aero Partners LLC · Sheridan, WYN80BCVaughan Aviation LLC · Leesburg, VAN80FMTrns Solutions LLC · Lewes, DEN80PGPhoenix Air Group Inc · Cartersville, GAN812LLH800 Vi LLC · Stuart, FLN812PMEl Jefe Express II LLC · Lake Forest, ILN812SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN816JMFoxfire Aviation LLC · Henderson, NVN816KYBcp Fa Ap LLC · Providence, RIN816LCMarklyn Jet Parts LLC · Dallas, TXN817EMCentennial Capital LLC · Centennial, CON817SDSea Aviation Holdings LLC · Wilmington, DEN818DEMt Gilead Full Gospel International Ministries Inc · North Chesterfield, VAN818LXN818lx LLC · Wilmington, DEN81GJGlobal Jetcare Inc · Brooksville, FLN81RARoyal Air Freight Inc · Waterford, MIN81VNChromed In Hollywood Inc · Franklin, TNN820CKKalitta Charters LLC · Ypsilanti, MIN822RLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN823AMAirmed International LLC · Birmingham, ALN823HLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to AD 96-18-13