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.
N76421Jayviation Inc · Lake City, FLN76423Nartapura Feldo · Renton, WAN76426Dilillo Kenneth W · Poplar Grove, ILN76427Bir James F · Marietta, OHN7642TLuthi Mark P · Rome, GAN7642XGrey Eagle Aviation LLC · Walker, MNN76437Buck Fifty LLC · Freeport, ILN7643TGarcia Yonhara Fortun Faedo · Norco, CAN7643XBrackman Aviation LLC · Twin Falls, IDN76440Alldredge Aviation · Auburn, WAN76441Hetland Jacob R · Las Vegas, NVN76445Liptrap Debra L · Spokane, WAN76447Gentrys Flying Service LLC · Prattville, ALN76450Grenseman Timothy R · Glenrock, WYN76458Seale Leon C III · Mulberry, FLN7645MKennedy Eric S · Utica, OHN76460Wendt Tony V · Avon, INN76463Ohara Joseph M · Van Horn, TXN76464Naile Ethan A · Inverness, FLN7646XGeorge James D · Aurora, INN76470Sheaffer Bruce R Jr · Lititz, PAN76475Jones Kiffen · Summer Shade, KYExpired dealerN76477Vandervliet Robert E · Louisa, VAN7647MHeithold Burdett D · South Sioux City, NEN7647THolmen Roger A · Carlsbad, NMN76482St Louis Soaring Association · Saint Louis, MON76484Weaver Harold M · Martinsville, INN7648TAppel Jacob · Redfield, SDN76496Kossuth Keith E · Chino Hills, CAN7649GSipes Aircraft LLC · Livingston, TXN7649TScott Steve W · Antioch, CAN7649URey Henry R · Fresh Meadows, NYN764CPApmg Aircraft Management LLC · Las Vegas, NVN76506Zucker Paul A · Cloverdale, CAN76509Briner John T · Celina, TXN76512Duvall James G III · Silver Springs, NVN76518Lux David J · Edgeley, NDN7651XHappy Landings Aviation LLC · Maple, NCN76520Fine Robert W · North Pole, AKN76521Noslen Enterprises · Goodland, KSN76525Hendry Kyle · Santa Rosa, CAN76527Malsberger Tim J · Blakely, GAFirst renewal noticeN7652MHenderson Aviation LLC · Norman, OKN76530Bagley Shaun R · Chapman, MEN76534Shilling Eric · La Quinta, CAN76535Wingo John W Jr · Washington, DCN76536Dix David G · Centre Hall, PAN76539Garcia Miguel A · Boqueron, PRN76542Spence Matthew V · Fort Myers, FLN76546Frey Kirk D · Corcoran, CA
Back to AD 94-05-05 R1