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.
N94676Dwyer Casey M · Stilwell, KSN9467AKourtis Vintage Aviation LLC · Owasso, OKN9467UPowell Travis R · Clinton, MON9468BHayward David E · Middlesboro, KYN94695Wehmer Alan R · Ewa Beach, HIN9469ABohl Howard M · Temecula, CAN9469UBrennecke Matthew L · Tulsa, OKN946HMascagni Jerry S · Greenville, MSN946PDSale Reported · El Cajon, CASale reported, canceledN94707Wood Wiley · Brownwood, TXN94712Schamberger Kenneth E · Austin, MNN94716Beach Andrew N · Hawthorne, NVN9471ABlock Elliot M · Encinitas, CAN9472BGrundy James W · West Greenwich, RIN9473BMulholland Thomas C Trustee · Orange Cove, CAN94740Ohanlon John M · Oshkosh, NEN9474UMay Randall T · Maquon, ILN9475UGerlach Brett C · American Fork, UTN94760Hampton Warren D · Sparks, NVN94761Hirsch Randall L · Mc Donald, TNN94765Demarzo Alexander · Flower Mound, TXN94767Mattox Steven W · Greenfield, INN9476AFoust Kal E · Lenox, MIN9476BHigher Calling LLC · Johnstown, CON9476USantos Enderson Rafael Teixeira Dos · Aledo, TXN94776Comer Charles R · Medaryville, INN94779Registration Pending · Oshkosh, WIRegistration pendingN9477ATriesenberg Stephanie · Grand Rapids, MIN9477BMilson Stuart A · Midlothian, TXN9477URegistration Pending · Delta Junction, AKRegistration pendingN94780Jones Gene W · Wilmington, NCN94782Brent Patricia · Puyallup, WAN94785Biggs Bill · Temple, TXN94788Simmons William J · Cape Carteret, NCN94791Airfrank Inc · Hackensack, NJN94793Fritcher Michael S · Arlington, TXN94798Berg Joseph A Sr · Benton, ARN947LQArcher William Todd · North Pole, AKN94804Plane Fun Inc Tr Trustee · Snellville, GAN94805Good James Robert Henry · Nevada City, CAN94806Moulson Steven M · Richmond, VAN94807Flying Wrenches · Buhl, IDN94809Planes Of Fame Air Museum · Chino, CAN9480BAlexis Aviation LLC · Greenwell Springs, LAN9480UColeman Stephen A · Wakefield, RIN94819Gregory Vernon L · Swansea, SCN9481AScholl Jonathan W · Mckinney, TXN9481BPueppke Clinton · Ayr, NDN9481UParnell Jr Jerry · Panama City, FLN94821Graham James W IV · North Ridgeville, OH
Back to AD 94-05-05 R1