AD 94-05-05 R1
Registered aircraft · 26,232
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.
N6525QMoore Robert Wayne · Brenham, TXN6526FHigh Exposure Inc · Wilmington, DEN6526QRevette Richard L · Littleton, CON6526THilt Destin R · Auburn, CAN6527ETaylor Carey A · Rainier, WAN6527QSlifkin Lester H · Arcadia, CAN6527SHirkala Ronald R · New Cumberland, WVN6528TRogers Brian D · Pacific, MON6529Rosser Victor B · Eastport, MEN6529FRising Aviation LLC · Prairieville, LAN6529HBennett Robert C · San Mateo, CAN6529QWill Peter J · Westminster, CON6529SDemott Steve · Covina, CAN6529TCarncross Jerome W · Arlington, WIN652MMadden Jeffrey M · Queensbury, NYN652VMHutchinson George D · Wolfeboro, NHN6530FRaw Racing Inc · Puyallup, WAN6531GGalavis Eduardo · Miami, FLN6531HRiggs Jeffrey W · Claremore, OKN6531SHatcher Mark F · Aloha, ORN6532ERegistration Pending · Maize, KSRegistration pendingN6532QValley River Leasing Inc · Murphy, NCN6532TRich Jay A · N Salt Lake, UTN6533FMoore William H III · Deer Park, WAN6533TCrawford Daniel G Trustee · Dryden, MIN6534FAnderson Ted E · Petal, MSN6534QGregory Vernon L · Swansea, SCN6535S315 Flight Club LLC · Fulton, NYN6536GMessersmith Brian W · Grand Prairie, TXN6536SSohr Brian S · Oconto, WIN6537EDittmer Michael C · Springtown, TXN6537GShettel Jay E · Boiling Springs, PAN6537QGoodwin Greg J · Cleveland, TXN6538QShaw Monte L · Hillsboro, OHN6539FSweitzer Merle E · Felton, PAN6539GSchneider Joel · Champaign, ILN6539QMcginnis Louis F · Raton, NMN653AMMcguire Timothy L · Tehachapi, CAN6540EAerial Crop Care Co · Hebron, NDN6540GKultti Richard O · Sonoma, CAN6540SHalverson Jan T · Goldendale, WAN6540TDevito David E · Maple Valley, WAN6541EAkers Sean M · East Wenatchee, WAN6541SBurke Frank E Jr · Scotland, SDN6542DPoland Vance B Trustee · Wentzville, MON6542EBond Ward Thomas · Salem, MON6543FJackson Road Flyers · Wayne, MIN6543QAnderson Kenneth J · Norman, OKN6543TLequire Wayne A · Maryville, TNN6544ESando Jan R · St Louis Park, MN
Back to AD 94-05-05 R1