OpenAirDocs.org
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.

N4757DCalhoun Gerrald E · Leesburg, FLS/N 17272352N4757KGirard Gregory M · Tucson, AZBuilt 1979 · S/N P21000288N4757THagen Brian T · Allen, TXBuilt 1981 · S/N R18201754N47582Beckham Jackie D Trustee · Coyle, OKS/N 15283238N47586Pea-Wayman Flight LLC · Daytona Beach, FLS/N 15283239N47587Neel Aviation LLC · Lakeland, FLS/N 15283240N4758KRuvo Scott J · Augusta, NJBuilt 1979 · S/N P21000289N4759GSanders Flight Training Center Inc · Jasper, ALS/N 17273341N475ACWigginton John D · Saco, MEBuilt 2000 · S/N 1300-2000N4760HBrh Aviation Inc · Indianapolis, INBuilt 1979 · S/N 24-0839N4760KWhitton Aviation LLC · Mesa, AZS/N P21000291N4761AAmarel Robert E Jr · Yuba City, CABuilt 1983 · S/N P21000821N4761CForbis Aviation LLC · Calera, OKBuilt 1979 · S/N 21063617N4761KLyman Leslie F · Walnut Grove, CABuilt 1979 · S/N P21000292N4761LWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284229N4761TWorden Frederick F · Tucson, AZBuilt 1981 · S/N R18201755N4763DRandolph Terrence · Bowie, MDBuilt 1979 · S/N 17272354N4763SMayday Flyers LLC · West Jordan, UTBuilt 1979 · S/N R18201419N4764DQuadrelec Engineering Corp · Tulsa, OKBuilt 1979 · S/N 17272355N47657Dallam Pat M · Cool, CABuilt 1979 · S/N 17271962N4765QDigger Dougs Crop Dusting Services Inc · Salem, WIBuilt 1976 · S/N 18802513TN4765TWehrman David Hugh · Queen Creek, AZS/N R18201756N4766B4 One Air LLC · Holland, MIBuilt 1979 · S/N 15283624N4766HHay Christopher C · Sweet Home, ORBuilt 1979 · S/N 24-0843N47672Cruiseair Aviation Inc · Ramona, CABuilt 1979 · S/N 15283243N4768EEagle Aviation Inc · Tucson, AZBuilt 1978 · S/N 17271633N4768KJohnson Durwood · Beaumont, TXS/N P21000299N4768PBoone Patrick J · San Antonio, TXBuilt 1978 · S/N P21000101N4769HRoark Ken W · Cisco, TXBuilt 1979 · S/N 24-0863N4769KSpirit 210 LLC · Missoula, MTBuilt 1979 · S/N P21000300N4769QFlight Time LLC · El Paso, TXBuilt 1981 · S/N 15285062N4769TBowsap LLC · Manson, WABuilt 1981 · S/N R18201757N476FMShumaker James B · Salinas, CABuilt 1978 · S/N 355-78N476MAAdamko Victor W · Riley, MIBuilt 2007 · S/N 1056-2007N476TCFlorida Flight Training Center Inc · Venice, FLBuilt 1979 · S/N 15283281N4770KPaulk Charles Jr · Naples, FLBuilt 1979 · S/N P21000301N4771KAshby Kenny · Mead, COBuilt 1979 · S/N P21000302N4772EDrost Larry L · Charlevoix, MIBuilt 1978 · S/N 17271637N4772HBymers Gary E · Waunakee, WIBuilt 1979 · S/N 24-0865N4772RKimball Michael G · Placerville, COBuilt 1979 · S/N 172RG0027N4772TCaballeros Aircraft LLC · Snohomish, WABuilt 1981 · S/N R18201760N4773CDickert Daniel · Cross City, FLBuilt 1979 · S/N 21063621N4773HPapa Ks Flying Service LLC · Centerville, IABuilt 1979 · S/N 24-0866N4773KReason Farms · Yuba City, CABuilt 1979 · S/N P21000304N4773LSilver Express Co DBA · Miami, FLBuilt 1980 · S/N 15284230N4773PCoeur De Air LLC · Mcminnville, ORBuilt 1978 · S/N P21000102N4773SSonrex LLC · Auburn, INBuilt 1979 · S/N R18201423N4773THagerman John · Coxs Creek, KYBuilt 1981 · S/N R18201761N4774EZhao Dan · New York, NYBuilt 1978 · S/N 17271639N4774FIlmberger Stephen J · Bend, ORBuilt 1979 · S/N 17273079
Back to AD 80-25-07 R1