AD 80-25-07 R1
Registered aircraft · 25,370
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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N49XMMclean Michael D · Modesto, CAN4AMPacific Northwest Aircraft Leasing LLC · Kirkland, WAN4ARN4ar LLC · Marienthal, KSN4AULineberger Joel Preston · Catawba, NCN4DG4dg LLC · Tacoma, WAN4EBDaro Norman E · Cody, WYN4EXBurgess Kevin R · New Bedford, MAN4FRW J Rothwell Ranch Co · Hyannis, NEN4JJJoseph John P · Hewitt, NJN4KLRanspot Richard · Burlington, TXN4LDMartin Matthew · Austin, TXN4MLSouthern Aircraft Consultancy Inc Trustee · Casper, WYN4MYYoung Michael D · Payson, AZN4NPSkywarrior Flight Training Inc · Pensacola, FLN4NVEndter Vincent · Gilroy, CAN4PLumsdaine Christopher G · Lompoc, CAN4PDSteck Paul D · Pelham, NHN4SWSalem Airport Authority · Salem, ILN4TAColumbia Aviation Inc · Columbia, TNN4UDMorse Donald W · Priest Lake, IDN4UNXin Han Aviation LLC · Atwater, CAN4WYParriott Eric T · Tarzana, CAN4YYWilliams Scott Griffin · Salt Lake City, UTN5000FAareyn LLC · Merritt Island, FLN5000LTrobaugh Michael A · Highland, ILN50016Cotner Jeff T · Bonham, TXN5005LBlanton Jeffrey D · Valley Center, KSN5005RBaer Michael E · Wheaton, ILN50067Prop Wash Aviation LLC · Hayward, WIN500BCGwinn Donald R · Mccall, IDN500BSCentral Aircraft Sales And Leasing LLC · Columbia, MON500DZEz Aviation LLC · Orlando, FLFirst renewal noticeN500GDElizondo Ernesto · Laredo, TXN500LTSeeth Richard D · Yardville, NJN500TFPine Bluff Police Department · Pine Bluff, ARN500WSKns Asset Management LLC · Lumberton, TXN5012REmd Aviation LLC · Carlsbad, CAN5013RBarxbar Aviation LLC · Mesa, AZN5017RR&R Leasing LLC · Fargo, NDN50193Folsom Gary A · Marianna, FLN501BAFalcon Air LLC · Orlando, FLN501BSBlue Skies Enterprises Of Texas · Richmond, TXN501DWParmar Bluffs LLC · Parker, SDN501ELJourneys Aviation Inc · Boulder, CON501MPManzoor Khan · Stockton, CAN501TSFlying Tigers Flight School LLC · Houston, TXN50208Haus Jesse M · Fort Worth, TXN5020HBorreson Anthony · Mariposa, CAN5020RMigliaccio Jason · Palm Bay, FLN5021HAlamo Flyers LLC · Elmendorf, TX
Back to AD 80-25-07 R1