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.
N8541UHegg Kevin S · Ann Arbor, MIN8541XHartman Matthew F · Billings, MTN8542ESchillo Paul J · Wrenshall, MNN8542JMcdowell Donald L · Geneva, OHN8542XMillennialytics LLC · Denver, CON85430Weitemier Jeffrey D · Browerville, MNN8543BKilo Aviation LLC · East Peoria, ILN85442Hayton James B · Sedro Woolley, WAN8544BPatry Aeronautical Institute · Kalispell, MTN8544UKeeley Edward D · Konawa, OKN8544XValiair Limited Co Trustee · Casper, WYN8545BEdwards Jess W · Carson City, NVN8545UNott Mike · Huntington Beach, CAN8546BGray Brian D · Kermit, TXN8546UShouling & Philip Enterprise · Lancaster, CAN8546XSchneiderhan Edward F · Laurium, MIN85479Appel David E · Redfield, SDN8547JL&R Consulting LLC · Las Vegas, NVN8548BGodbout Kevin · South Hadley, MAN8548EPingel Ralph C · Saint Peters, MON8548XHuston Kenneth Paul · New Carlisle, INN8549BPhaneuf Dave · Adams, TNN8549UFauver Russell · Hartsville, SCN8550EHarloff David F · Lehigh Acres, FLN85511Shearer Don E · Madrid, IAN8551UFishman Randall · Napanoch, NYN85522Barrett Joseph E · Lagrange, OHN85523Lunde Ryan · Wausau, WIN8552BTenney Curtis J · Sevierville, TNN85533Schutze Curt K · Knoxville, TNN8553BVaught Ralph S · Star Valley, AZN8553JMindy Limited LLC · Muscatine, IAN8553UFinley Todd R · Carmel, INN85547Roberts Jean A · Roberts, ILN8554BSummers Kim C · Winnemucca, NVN8554UWorkman David A · Putnam, ILN85551Hanson Shirley M · Pentwater, MIN8555BThompson Greg M · Rigby, IDN8555JBauer Walter G · Neenah, WIN8555ULeaf Sport LLC · Henning, MNN85563Freeman Christopher D · Kingsbury, TXN8556BKendig Dustin Zarah · Portland, ORN85574Welch Ronald J · Viroqua, WIN8557GDoddi Vikram · Austin, TXN8557JRobertson Billy J Trustee · Cleveland, OKN8557UOconnor Jonathan D · East Aurora, NYN8557XChauhan Jay S · Oakland, CAN85582Hermann Vela M · Saint Louis, MON85585Brauer Eric M · Signal Mountain, TNN8558BWilliams Ralph J · Essex Junction, VT
Back to AD 94-05-05 R1