AD 94-05-05 R1
Registered aircraft · 26,231
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.
N2405KLockwood Quinton J · Hillsdale, MIN2406NNovak Mark S · Dawson, NEN2407RMyers William J · Colfax, WAN2407UFrancis Ronald · Fredericktown, MON2408JIflycali LLC · Rancho Murieta, CAN2408KCarson Ryan P · Albuquerque, NMN2408VRegistered aircraftN2409HLocke Greg DBA · Jacksonville, TXN240CCBurch Scott S · Alpine, TXN2410BMiller Charles T · Bynum, TXN2410DWeaver James C · Boise, IDFirst renewal noticeN2410JHeinze Gregory L · Little Rock, ARN2410LSammons Mitchell · Belgrade, MEN2410NTipton Jeff K · Anton, TXN2410UYellow Breast Aviation LLC · Christiansted, VIN24115Lockhart Michael G · Coral Springs, FLN2411DBinsky Lawrence A · Bexley, OHN2411ER H Lindsay & Assoc Inc · Canby, ORN2411HLekas Melissa · Toms River, NJN2411JKenney Jason M · Grand Rapids, MIN2411LEfinger John M · Cresson, TXN2411NLouisiana Taildraggers LLC · New Orleans, LAN2411USiemens Jonathan Lee · Seminole, TXN2411YMullings Michael A · Orange, NJN24120Hamilton Dwight A · Wildwood, FLN2412UHill Brock E · Palouse, WAN2412VKinzie Hon K · Anchorage, AKN24134Airpower Museum Inc · Ottumwa, IAN2413BLohse Randy · Onalaska, WAN2413UAmazon Aero Corp · Wilmington, DEN2413YRegistration Pending · Bangor, MERegistration pendingN24148Morozowsky Anthony M · Zanesville, OHN2414DSmith Nathias N · Weiser, IDN2414KCahill Michael F · Batavia, OHN2414URozell Wallace R · Argyle, TXN2414VBible Larry · Sumner, TXN2414YHigh Flight LLC · Casey, ILN24154Beranek James D · Cottage Grove, ORN24157Indy Air Sales LLC · Anderson, INN2415BWomack Jeff M · Jackson, LAN2415ELaux Christopher B · Gladstone, MON2415HErcoupe LLC · Colonial Heights, VAN2415KCekinovich Ted M · Machesney Park, ILN2415L98x LLC · Caddo Mills, TXN2415VDouble T LLC · Galesburg, ILN2416ENoack Emily B · Oshkosh, WIN2416KMacpherson Stuart S · Cardiff By The Sea, CAN2416LBeck Roger M Trustee · Goode, VAN2416USzabo Stephen A · Sacramento, CAN2416YHalford William T · Hernando, MS
Back to AD 94-05-05 R1