AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N30877Pompano Senior Squadron Flying Club Inc · Pompano Beach, FLN3087CHarless Steven M · Brighton, CON3087FCascio John T · Deland, FLN3087QCollins Allen Shane · Amarillo, TXN3087RCrest Aviation LLC · Palmer, AKN3087TArroniz Valentin · San Juan, TXN3087UShelite Michael J · Enid, OKN30881Garver John H · Fairland, INN30887Needham Victor T Jr · Park Forest, ILN30888Propwash LLC · Frankenmuth, MIN30889Abbott Michael S · Radford, VAN3088CMeester Daniel J · Longmont, CON3088DAquasol Corp · Rock Hill, SCN3088FDoepker James E · Kalispell, MTN3088GRox Air LLC · Montgomery, OHN3088LRice James M · Austin, TXN3088QRosenblatt Jeffrey A · Portland, MEN3088YCathey Michael · Chattanooga, TNN3088ZRavens Rebuilders Inc · Ellenboro, WVN30892Salvagnini David R · Falls Church, VAN30894Hartacres LLC · Kalispell, MTN3089CWeatherly Richard A · Newport, WAN3089HWilliamsburg Air Service Inc · Kingstree, SCN3089QBrotnov Jerald W · Clarkston, WAN3089RFly Bms LLC · Elkton, SDN3089THalverson Wyatt · Colbert, WAN3089YSymbiotic Assets LLC · Winnemucca, NVN3089ZSnyder Stephen F · Paradise Valley, AZN308BBCartwright James · Summerland Key, FLN308BCMike Kilo Foxtrot LLC · Wilmington, DEN308CDM&R Transport LLC · Dover, DEN308CFBaba Kenneth D · Sierra Vista, AZN308CWHeritage Investment Corp · Arlington, TXN308EShannon Jesse L · Boise City, OKN308FAStratus Rr LLC · New Castle, DEN308FDN308fd LLC · Janesville, WIN308KFAb Prop Plane I LLC · Metairie, LAN308MGGeorgia Aviation Authority · Eastman, GAN308MTBadje Seth J · Hay Springs, NEN308NGR N Geraci LLC · Lutz, FLN308NRState Of Wisconsin · Madison, WIN308PDmm Air Shows LLC · Wilmington, DEN308RZone Five LLC · Saint Petersburg, FLN308RLAulisio Anthony III · Dana Point, CAN308SALangley Richard · Sheyenne, NDN308SLLeibbrandt Steven E · Imperial, NEN308SPAmeriflyers Of Texas Inc · Addison, TXN308SUHagele Aviation LLC · Hillsboro, ORN308TATrinity Aviation LLC · Georgetown, TXN308TSSimson Theodore A · Sherwood, OR
Back to AD 2007-04-19 R1