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.
N92CCCanadian Co Sheriffs Office · El Reno, OKN92DWBurnette Jeffrey T · Big Lake, AKN92EZJohnson Leif M · Midlothian, TXN92JEEdburg Stanley L · Mead, WAN9300BBenson Ryan Denson · New Carlisle, OHN9303Kagebein Roger · Dewitt, ARN9303UWestover Scott A · Anchorage, AKN9305BStar Aero LLC · Santa Teresa, NMN9308BKorn Antony · Chehalis, WAN930BFFisher Bryan L · Collinsville, OKN930JSDolphin Air LLC · Fairbanks, AKN930LHolmgren David P · Waller, TXN9310BThrom Donald R · Parachute, CON9315BVan Horne Robert E · Centralia, ILN9315UGilbreath Brent · Arlington, TXN9316URoadrunner Bus LLC · Weston, NEN9318UWhite David A · Omaha, ARN9319UJohnson Douglas G · Mason City, IAN931DHBeamer Richard D · Wabash, INN931URRegistration Pending · Ivins, UTRegistration pendingN9321BGippner Gerald W · Olathe, KSN9322CWaters David J · Phelps, NYN93231Lawrence Paul L · Vancouver, WAN93232Bailey Michael S · Sarasota, FLN93233Royer Duane R · Tucson, AZN93238Spring-Air LLC · De Graff, OHN9323BCarter Lance F · Bangor, CAN93243Jorgensen Duwayne L · Effort, PAN93246Demaine Richard W · Smithfield, RIN93248Strine Russell A · Reading, PAN9324HVisocky Brian M · Vancouver, WAN93250Morris Thomas B · Imlay City, MIN93252Walton T Michael · Hudson Falls, NYN93253Buck William C Jr · Columbus, GAN93278Morris Thomas B · Imlay City, MIN9327HBealer David C · Bethlehem, PAN93280Ruhanen Michael C · Reese, MIN93284Dexter Fred H · Live Oak, FLN9328BDethlefs Darrell C · Mechanicsburg, PAN9328UFlymoore Ventures LLC · Saint George, UTN93290Kohler Richard L · Moriarty, NMN9329ABrown Leonard A · Hagerstown, MDN9329BSngdo Emergency Medicine Inc · Spring Hill, FLN932RKRegistration Pending · Palmer, AKRegistration pendingN93306Ercoupeaire LLC · Blackwood, NJN9330HHrutkay Charles S · Scenery Hill, PAN9330USt Pierre George III · Palm Bay, FLN93332Gregory Vernon L · Swansea, SCN93337Oneel Cory · Ames, IAN9333URoe Russell M · Martinez, CA
Back to AD 94-05-05 R1