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.
N9191ARupert Judson L · West Milton, PAN9191BE & D Aviation Sales LLC · Sainte Genevieve, MON9191UN9191u LLC · California, MDN9193ASchlafmann Jay R · Mercer, NDN9193BRegistration Pending · Garwood, TXRegistration pendingN9193UVan Buskirk Bill J · Wasilla, AKN9193ZThacker William E · Chenoa, ILN9194AWeathered Brenton W · Poquoson, VAN91965Wallace Randall R · Stamps, ARFirst renewal noticeN9196BPeterson James G · Keller, TXN9197AAlmeida Gilbert M · Hilmar, CAN9197UWarfel Everett E · Greenwood, DEN9198AMorse Steven J · Gig Harbor, WAN9198ZMitchell Grant Avery · Fallon, NVN9199BM & H Investment LLC · Montgomery City, MON919WQStone Jeffrey · Fort Collins, CON91DCCueva Arturo A · Los Angeles, CAN91ERice James L · Mckinney, TXN91GHHi-Roller Aviation Ltd · Scenery Hill, PAN91JJJackson James E · Brainerd, MNN91MAHutchings Mathew J · Camano Island, WAN91NMccutchan Clay T · Milton, FLN91PVMassimini Sebastian V · Arlington, VAN91RBlack Pilots Of America Detroit Chapter · Detroit, MIN91TMitchell Carl D · Gainesville, TXN91TCNorth Valley Aircraft Inc · Valley City, NDN91WAStevens James L · Carrollton, GAN92003Hopgood Mark R · Park City, UTN9200UCherry Hill Aviation Inc · Freetown, INN92027Registration Pending · Wallace, CARegistration pendingN9202AWilson Alan Trustee · Waukesha, WIN92031Sanchez Joseph · Walnut Grove, CAN9203UAlaskan Mariners Inc · Homer, AKN9204AConrad William A · Kaukauna, WIN9204BMcelwain Floyd · Saint Joseph, MON9206ACurrie Andrew C · Oscoda, MIN92077Lee Clarence K · Citra, FLN92084Cavanaugh Cody · Neenah, WIN9208UEllefson Nicholas · Duluth, MNN92107Aerospace Trust Management LLC Trustee · Wilmington, DEN9210ASmith Ted · Grant Park, ILN9210UKing Bill R · Cadillac, MIN9211UMaster Gregory A · Mesa, AZN9212AMills Byron K · Harrison, ARN9212BRegistration Pending · Campbellsville, KYRegistration pendingN9213BWallace Gary E · La Junta, CON92166Gerdeman Richard F III · Roscoe, ILN92177Thomas Robert A · Bettendorf, IAN9217AAlumitank Inc · Harvard, ILN9217UWallace John L · Bethel, AK
Back to AD 94-05-05 R1