OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,369

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.

N86959Collum Aviation LLC · Milton, FLBuilt 1974 · S/N 1029-74N86968Crafted Enterprises LLC · Montrose, COS/N 40-74N86969Sperry Sails Inc · Marion, MABuilt 1974 · S/N 695-74N8696VMoynahan Thomas F · Newnan, GABuilt 1975 · S/N 515-75N86974Qualitair LLC Trustee · MichelstadtBuilt 1974 · S/N 145-74N86977Ajs Aviation Inc · Spring Hill, FLBuilt 1974 · S/N 458-74N8697VFisher Kurt Adrian Trustee · San Luis Obispo, CABuilt 1975 · S/N 833-75N86983Hanson Curtis J · Peyton, COBuilt 1974 · S/N 1031-74N86985Thomas Lucas G · Beebe, ARBuilt 1974 · S/N 44-74N86986Nelson Michael R · Philip, SDBuilt 1974 · S/N 45-74N86989Webb Terry M · Montreal, MOBuilt 1974 · S/N 46-74N8698VNine 8 Victor Tailshare LLC · Kalispell, MTS/N 179-75N8699Blake Rodney · Trophy Club, TXBuilt 1973 · S/N 358-73N86992Shorey Ruby M · North Pole, AKBuilt 1974 · S/N 47-74N86993Jhs Inc · Helena, MTBuilt 1974 · S/N 55-74N869NEJohn Cox LLC · De Witt, NEBuilt 1977 · S/N 15280149N869RRCooper Billy P · Columbia, MSBuilt 1979 · S/N 15283698N869TTDimond Joan M · Birch Run, MIBuilt 1969 · S/N 157N86BFEmbotelladora Del Caribe Inc · Yabucoa, PRBuilt 1981 · S/N 24-1223N86CYDawson J Stewart · Celina, TXBuilt 2008 · S/N 1073-2008N86DBMchugh John J · Camano Island, WABuilt 1970 · S/N 17259123N86DHHolloway'S Tire And Auto Service Inc · Thomaston, GABuilt 1984 · S/N 21064832N86EFCic Aviation LLC · Wenatchee, WABuilt 1978 · S/N R18200481N86ERInnovative Aerial Solutions LLC · Saint Johns, FLBuilt 1983 · S/N 17276027N86FPGateway Flight Center LLC · Port Lavaca, TXBuilt 1978 · S/N 17271406N86MTWhite Knuckles Aviation LLC · Carson City, NVBuilt 1980 · S/N P21000533N86PGJackson Jeffrey G · Kingsport, TNBuilt 1971 · S/N 21-0013N86RAAcrodocs LLC · Tallahassee, FLBuilt 2003 · S/N 925-2003N86RTInverted Aviation Inc · Walnut Cove, NCBuilt 1992 · S/N 682-92N86SADureiko Martin J · Miami, FLBuilt 1980 · S/N A1520950N86UMJohnston Brentlee · Edgewood, TXBuilt 1966 · S/N 1137N86VBAce Flight Center · St Thomas, VIBuilt 1974 · S/N 17263670N86WJWalbridge James S · Mill Hall, PAS/N 38-72N86WSPlane Fun Inc Tr Trustee · Snellville, GABuilt 2022 · S/N 1216N87006Dow Terry D · Okarche, OKBuilt 1974 · S/N 50-74N87008Garrity Frank B · Durham, CABuilt 1974 · S/N 51-74N87009Wrench Heath · Lafayette, COBuilt 1974 · S/N 449-74N87015Legacy Lsa LLC · Lubbock, TXBuilt 1974 · S/N 702-74N87019Bates Paul L · Livermore Falls, MES/N 1032-74N87021Haugen Delos L · Burlington, NDBuilt 1974 · S/N 1033-74N87025Lundin Steven J · Carson City, NVBuilt 1974 · S/N 450-74N8702VArrowhead Aeromotive Services LLC · Hoodsport, WABuilt 1975 · S/N 189-75N87031Stewart Thomas E · North Pole, AKS/N 703-74N87032Holland Mark S · Grenada, MSBuilt 1974 · S/N 53-74N87036Pino Carlos R · Santa Fe, NMBuilt 1974 · S/N 452-74N87038Thompson Christopher S · Senoia, GABuilt 1974 · S/N 149-74N87041Seidl Charles F · Wasilla, AKBuilt 1974 · S/N 1034-74N87043Young Boyt D · Hamill, SDBuilt 1974 · S/N 56-74N87044Fernandez Amador · Imperial, CAS/N 57-74N87047Sprankle Gerard J · Fairbanks, AKBuilt 1974 · S/N 61-74
Back to AD 80-25-07 R1