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.
N9162BMedic Choppers LLC · Springdale, ARN9162UDag Arda Orcun · Mount Dora, FLN9163BWright Donald E · Greensboro, NCN9164UUnderwood Callum M · Canton, GAN9165AAdams Harry J · Montgomery, TXN9165ULudwiczak Damian · Medina, OHN9166Evans Craig W · Leakey, TXN9166BWusterhausen Jerry L · Boynton Beach, FLN9166UKsnl Aero LLC · Shawnee, OKN9167BAshley-Nye Johanna I · Graham, WAN9167CNew Garden Township · Landenberg, PAN9167UTobin Dustin J · Hesperia, CAN9168AMatthews Jeff M · Conowingo, MDN9168BAverett Joseph B · Denham Springs, LAN9168UC150 LLC · Gilbert, AZN9169UVipperman Richard Madison Jr · Martinsville, VAN9170APasqualino Carolyn G · Ocala, FLN9170BRegistration Pending · Shohola, PARegistration pendingN9172AAndress Chad R · Casper, WYN9173BSuperhawk LLC · La Center, WAN9173LDesanti Michael P · Ft Lupton, CON9174AOutbound Aero LLC · Kiowa, CON9174LHunt Daniel R · Hayward, CAN9174UYoung Steven J · Taneyville, MON9177AErbey Jacob G · Hudson, WIN9177BBolan Preston A · Phoenix, AZN9178Roebuck David L · Columbia, SCN9178AIndependent Aviation Consultants LLC · Edmond, OKN9178UPerguson Robert C · Converse, TXN9179BHuntley Larry T · Midlothian, TXFirst renewal noticeN9179UHartman Karin R · Kokomo, INN917BSPalmer Ryan L · Waynesville, OHN917CSWood Robert V · Big Springs, NEN917ESStukenholtz William W · Lincoln, NEN917NMeaux Jimmie J Jr · Kaplan, LAN917ZXD & S Flyers LLC · Portage, MIN9180BHolcomb Nicholas A · Yakutat, AKN9180ZKey West Bandit Squadron LLC · Summerland Key, FLN9183UJody M Bryson DBA · Richards, MON91848Mike Alpha Mike LLC · Lafayette, LAN9185UChristopher P Riley · Everett, WAN9186AGaylord Hangars LLC · Gaylord, MIN9186USmith John Dial Jr · Lexington, SCN9187AKandarian Jordi · Cundiyo, NMN9187BEbrahim Ahmed E · Onalaska, TXN9189AHoulton Timbre Ross · Fairbanks, AKN9189BSale Reported · Litchfield, MNSale reportedN918CHAerobotics LLC · Edmond, OKN918CXDel Valle Arnoldo · Sandia, TXN91913Gunter Honey Inc · Towner, ND
Back to AD 94-05-05 R1