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.

N409SPTzerefos Lambros P · Mathews, VAS/N 177RG0493N40ACRadecki Louis · Helenville, WIBuilt 1991 · S/N 644-91N40ALHelm Mark · Palm Harbor, FLBuilt 1980 · S/N 24-0989N40ATN40at LLC · Lewis Center, OHBuilt 1978 · S/N R18200527N40BKGray Padraic W · Cypress, TXS/N 24-3325N40CKDcy Aviation Group LLC · Linton, INBuilt 1977 · S/N 17269264N40EMYour Moms Upset LLC · Saint Paul, MNS/N 696-92N40ERFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17269569N40FGAllen Stephen G J · Peshastin, WABuilt 1993 · S/N 24-3307N40JMAll Breeds Combined LLC · Kalispell, MTS/N 540-2011N40LYAsh Gary W · Houston, TXBuilt 1978 · S/N 17270900N40MJOn Top Aero LLC · Avon, CTBuilt 1993 · S/N 24-3304N40MUOracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264170N40NRMooney V LLC · Dunbarton, NHBuilt 1994 · S/N 24-3330N40RBKmg Aviation Holdings LLC · Hartville, OHBuilt 1976 · S/N 177RG1071N40RGDovy Aviation LLC · Houston, TXBuilt 1974 · S/N 17263241N40SGZeliff Aviation LLC · Batavia, NYS/N 550-2012N40SPSmith Terry G · Liberty Twp, OHBuilt 1980 · S/N 17274099N40SVBarr Michael B · Houston, TXBuilt 1993 · S/N 24-3312N40TMN40tm LLC · Wilmington, DEBuilt 1966 · S/N 1063N40TPDraco Flight School DBA · Chino, CABuilt 1981 · S/N 17274723N40WNRider Rebecca L · Hyde Park, NYBuilt 1968 · S/N 17700829N40XXRegistered aircraftBuilt 1993 · S/N 24-3306N41007Registered aircraftBuilt 1991 · S/N 243220N4100HTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1980 · S/N 24-1029N4100YLofton Charles T · Georgetown, MNBuilt 1976 · S/N 944-76N4101YBower Gary R · Miranda, SDBuilt 1976 · S/N 230-76N4102HForeman Guy W · Valparaiso, INBuilt 1978 · S/N 240617N4103NKarpik Joseph Paul · Floodwood, MNS/N 680074N4104YBurgett Gary · Galena, AKBuilt 1976 · S/N 945-76N4105CJohnson Rodney R · Roseburg, ORS/N R18200322N4105HBonanza Valley Air LLC · Alexandria, MNBuilt 1978 · S/N 24-0621N4106CAir Data Solutions LLC · Natchitoches, LABuilt 1978 · S/N R18200323N4106NGioia Matthew M · Stafford, VABuilt 1968 · S/N 680035N4107NWest Main Auto Sales Inc · Tupelo, MSS/N 680075N4109NRoss George H · Delano, MNS/N 680036N410ABBloxsom Allan P III · Boerne, TXBuilt 1979 · S/N P21000352N410EKGandy Donald T · Weatherford, TXBuilt 1976 · S/N 17702536N410FRRegistration Pending · Pottstown, PARegistration pendingBuilt 1982 · S/N 17275212N410SEConner Gary Dean · Cypress, TXS/N R18200564N4110HKoerkenmeier James J · Carlyle, ILBuilt 1978 · S/N 24-0626N4110YHeiderscheidt Cory · Sleepy Eye, MNBuilt 1976 · S/N 1175-76N4111YHousley Jaclyn R · Wasilla, AKBuilt 1976 · S/N 946-76N4112HGroves Carl Jr · Lebanon, TNBuilt 1978 · S/N 24-0627N41139Blair Mark Winston · Zachary, LAS/N R18200889N4113HWettstein Tim · Manhattan Beach, CABuilt 1978 · S/N 24-0628N4113YKlintrin Collectibles LLC · Downers Grove, ILBuilt 1976 · S/N 591-76N4114HSemeniuk Steven Ty · Houston, TXS/N 24-0629N4114YLight & Variable LLC · Arlington, VABuilt 1976 · S/N 947-76N4115CHails Betsy B · Montgomery, ALBuilt 1978 · S/N R18200325
Back to AD 80-25-07 R1