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.
N9281UOtters Heinrich · Fredericksburg, TXN92825Phillips Joshua D · Sylvania, GAN92827Dexter Fred H · Live Oak, FLN9282AWest Sheryl M · Champlin, MNN9282USchur David · Lavernia, TXN92830Deroos John T · Mammoth Spring, ARN92833Rauch Karl W · Fredericksburg, VAN9284BBeckley Larry · Scottsburg, INN9286ASimon Theodore E · Richmond, MIN9286BHall Leslie E · Lubbock, TXN9289BWoodstock Aircraft Services Inc · White Lake, NYN928HPeterson Michael A · White Salmon, WAN92901Learn Build Fly Inc · Wausau, WIN92902Palmenteri Louis J · Rhome, TXN92904Ledbetter Tim A · Tahlequah, OKN92905Air East Aviation Inc · New Castle, DEN92906Hornick Joel Richard · Corry, PAN92907Scarola Michael · Danbury, CTN9290BFitts Roger W · Independence, ORN92911Pioneer Flight Museum · Kingsbury, TXN92914Johnson Gregory A · Greenbush, VAN92915Brown Courd E · Warr Acres, OKN92916Farmer Larry A Trustee · Salina, KSN92918Farrell Donald A · Owasso, OKN9291AEvans James · Tuolumne, CAN9291BVan Meerveld Dwight E · Poplar Grove, ILN92920Dexter Fred H · Live Oak, FLN92921Dixon Tom N · Lodi, CAN92923Heise Erick B · Dexter, NYN92924Dreyer Elwain C · Cardington, OHFirst renewal noticeN92926Morris Thomas B · Imlay City, MIN92927Farmer Larry A Trustee · Salina, KSN92930Cornelius Jerry M · Addison, ALN92932Michael S Bailey · Sarasota, FLN92940Kettunen Alan C · Ashtabula, OHN92941Linkous James P · Ancho, NMN92953Sherman Randy S · Potsdam, NYN92954Brosseau Jon A · Pebble Beach, CAN92960Hilgendorf Ross E · Welcome, MNN92962Yoder James J · Canby, ORN92968Mallow David N · Rio, WVN9296BColby Robert D · Bigfork, MTN92971Tostenrud Steven · Billings, MTN9297UNorthwest Wings LLC · Hillsboro, ORN92982Gould William R · Eagle River, AKN92988Fraser William G · Berkley, MAN9298AHenderson Larry V · Highland Village, TXN92997Barger Albert L · Windsor, WIN92999Skyranger LLC · Marshall, MNN929FMParker Johnny W · Murray, KY
Back to AD 94-05-05 R1