AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N12014Thompson Robert J · Kaktovik, AKN12015Thurmond Paul J · Huntley, MTN12016Swain Michael J · Jacksonville, FLN12017Nuckles Charles Austin Jr · Suffolk, VAN12018Theriot Harris J Jr · Thibodaux, LAN1201DFaruque Imraan A · Stillwater, OKN1201KVillaurrutia Carlos · Mcallen, TXN12026Bernhardt Michael J · North Branch, MNN12027Rugland Roger E · Anoka, MNN12029Dippold Lois M · Perry, MIN1202AEldringhoff Jim · Wecota, SDN12031Burnett Brandon Ryan · White Lake, MIN12032Riebe Robert D · Caldwell, IDN1203HZimmer Dennis DBA · Pennock, MNN1203QMusick John Thomas · White Hall, ARN1203YWyatt G Whitlow · Wshngtn Ct Hs, OHN1204HCompton Adam J · Wasilla, AKN1205ERodorigo Mark W · Virginia, MNN1207YDickman Matthew J · Cold Spring, KYN12084Fisher James W · Knoxville, IAN1208DMusgrove James F · Burien, WAN1208YSnyder Jason D DBA · Oakland, MDN1209ACorbin Richard · Waterville, NYN1209HNelson Chester C · Little Falls, MNN1209RRowley Timothy · Roopville, GAN120BMVenegas Keila R · Long Grove, ILN120CADodson Patrick W · Creswell, ORN120CEStark Rosemary A · Homosassa, FLN120CMLaminar Skies Aviation LLC · Broken Arrow, OKN120CWWebb Charles E · Cleburne, TXN120DCHockman William C · Lebanon Church, VAN120DHHiester Donald J · Sicklerville, NJN120HTJackson Harry A II · Findlay, ILN120JNOlufsen Niels · Lakeway, TXN120JSJohnson Max L Jr · Greenville, SCN120KFWeber Anthony · New Salisbury, INN120LAldrich Justin M · Dallas, ORN120MALynn Jack Bradford · Lanett, ALN120MZBeames Eric G · Palestine, TXN120PGSilver Rock Completions LLC · Wausau, WIN120RWUnruh Ronnie E · Pampa, TXN120SEBarrientos Jeri D · Collinsville, OKN120SGMccall Melinda · Decatur, ALN120SSSoutheastern Oklahoma State University · Durant, OKN120VMaggart Daniel J · Winchester, ILN120VWSouth Platte Flying Club LLC · Kansas City, MON120XLooper Bobby L · Marion, TXN120YBaldwin James C · Fruita, CON1210WWilson Steven Alfred · Runnells, IAN1211HSchelde Jack D · Cook, MN
Back to AD 94-05-05 R1