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.

N316ACBillings Brian · Bondurant, WYBuilt 2001 · S/N 1318-2001N316CAChoice Aviation LLC · Hamilton, MTS/N 17265960N316HYLakeview Aviation Inc · Newport, VTBuilt 1977 · S/N 17702651N316RWFour States Tire & Service Inc · Cortez, COBuilt 1979 · S/N 21063447N3171EJprg Aviation Inc · Orlando, FLBuilt 1978 · S/N 17271459N3171TVanlandingham Michael E · Oxnard, CABuilt 1967 · S/N 17700471N3173ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271461N3177Duvall John M III · Cincinnati, OHBuilt 1967 · S/N 17700660N3177CRsb Properties LLC · Lewes, DEBuilt 1978 · S/N R18200248N3177TCain James W · Big Rapids, MIBuilt 1967 · S/N 17700477N3178TAdvantage Aviation Services LLC · South Saint Paul, MNS/N 17700478N317ACChickenhawk Inc · Wilmington, MABuilt 1975 · S/N 17265537N317JRUnd Aerospace Foundation · Grand Forks, NDBuilt 2010 · S/N 1105-2011N317SDSipila Hart A · Soquel, CAS/N 778-96N3181TDuck Donald S · Edwardsburg, MIBuilt 1967 · S/N 17700481N3183CWide Open Aviation LLC · Kennewick, WABuilt 1978 · S/N R18200251N3188TRucinski Edward A · Climax, NCS/N 17700488N318ACAughenbaugh Alan M · Iroquois, SDBuilt 2000 · S/N 1298-2000N318JRFlywell Aviation LLC · Bowling Green, KYBuilt 2006 · S/N 1013-2006N318PWN318pw LLC · New Canaan, CTBuilt 1973 · S/N 17262171N318RCLafrance Lon H · Rocky Mount, MOBuilt 1977 · S/N 17269183N318VFShramek Troy A · Bossier City, LABuilt 1973 · S/N 17702008N318VPBialek Joseph · New Smyrna Beach, FLS/N 24-0996N3192CHansen Leland K · Phoenix, AZS/N R18200255N3192THawley James W · Waddell, AZBuilt 1967 · S/N 17700492N3196TNicholson Perry R · Merlin, ORBuilt 1968 · S/N 17700496N3197TMundle Jeffrey A · Ashland, ORBuilt 1967 · S/N 17700497N3198FDepinet Rodney J · Glen Saint Mary, FLBuilt 1968 · S/N 17256588N3199TMortgage Experts LLC · Homestead, FLBuilt 1967 · S/N 17700499N319JFRegistration Pending · Johns Island, SCRegistration pendingS/N 21063507N319JPElon Aviation LLC · Burlington, NCBuilt 1973 · S/N 17262752N319SANelson Edwin L · Kingsland, TXBuilt 2006 · S/N 1421-2006N31ACTango Thirty Aero Clube Inc · Mckinney, TXS/N 17261643N31AZDelgado Tony · Denair, CAS/N 18267911N31BJAvco Patrol LLC · Lyndon, KSBuilt 1976 · S/N 17702489N31CNSkyland Aviation LLC · Alpine, CABuilt 1976 · S/N 17267936N31DLLoy David Parker · Eads, TNBuilt 1978 · S/N 24-0475N31DMLejeune David E · Lake Charles, LABuilt 1977 · S/N 20-1248N31FR31fr LLC · Bigfork, MTBuilt 1985 · S/N R18202008N31GGSchwend Brian · Forsyth, MTBuilt 1964 · S/N 2683N31JBLucian Aviation LLC · Modesto, CAS/N 17273002N31LDGustte Phil · North Fort Myers, FLBuilt 1973 · S/N 17262736N31MDKarmy Paul Edward · Burleson, TXBuilt 1980 · S/N P21000595N31MSWagon Leasing LLC · Jonesboro, ARBuilt 2018 · S/N 593-2018N31NMBolton Philip L · Bloomington, ILBuilt 1982 · S/N 24-1334N31RWSpot Air LLC · Burlington, TXBuilt 1977 · S/N 17268693N31SCObryant Jeffrey A · Fairbanks, AKBuilt 1967 · S/N 79N31SETangent LLC · Phoenix, AZBuilt 2005 · S/N 978-2005N31SMWings Over Texas Aviation Inc · Killeen, TXBuilt 1965 · S/N 635N31VSJenny Timothy J · Remsen, NYBuilt 1999 · S/N 1273-99
Back to AD 80-25-07 R1