OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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-02-R2')
    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-02-R2')
  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.

N7187CWoldt Wayne E · Raymond, NEBuilt 1973 · S/N 681N718EBerry Darrel · Camden, TNBuilt 1943 · S/N 30280N71BTSmith Dustin E · Windsor, MOBuilt 1961 · S/N 22-8833N71HBRyan Dean K · Garden City, KSBuilt 1997 · S/N 157N71KJAanstad William L · Ofallon, ILBuilt 2006 · S/N 471BN71YYAgl Flight LLC · Callahan, FLBuilt 1971 · S/N AA1A-0118N7210KDean Alan L · Soldotna, AKBuilt 1950 · S/N 18-101N7218KRanstead Mark · North Granby, CTBuilt 1950 · S/N 18-102N72219Sheets Mark W · Chugiak, AKS/N 9392N7223KDowning Michael P · Yelm, WABuilt 1950 · S/N 18-117N7227KOlathe Spray Service Inc · Olathe, COBuilt 1950 · S/N 18-121N722RWRegistered aircraftBuilt 1947 · S/N 12-2586N7233KWalsh Steve · Anchorage, AKBuilt 1950 · S/N 18-125N723CMOmbra Aria LLC · Dover, DEBuilt 1978 · S/N 15282823N723KCCornelius Robert · Vinemont, ALBuilt 2021 · S/N 103N723THSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 15281348N72418Bishop Raymond Max · Chandler, AZBuilt 1964 · S/N RB-3N7245KKnuckles Dennis P Trustee · Custer, SDBuilt 1950 · S/N 18-140N7247KLangley Preston B · Warwick, NDBuilt 1950 · S/N 18-142N724MSNannenga Fredrick Jr · Hillsboro, ORBuilt 1967 · S/N 298N7252KEgan Bailey J · Forsyth, MTBuilt 1950 · S/N 18-147N7252LForney Luke N · David City, NES/N AA1A-0452N72535Root Angelo R · Orovada, NVBuilt 1946 · S/N 9705N7254KCook Tim L · Eagle River, AKBuilt 1950 · S/N 18-149N7255LHall Travis J · Dayton, TNBuilt 1972 · S/N AA1A-0455N7256LRegistration Pending · Fair Bluff, NCRegistration pendingBuilt 1972 · S/N AA1A-0456N7259KLavigne Richard P · Ranier, MNBuilt 1950 · S/N 18-153N7259LDella Ripa Vincenzo · Newbury Park, CABuilt 1972 · S/N AA1A-0459N7260LMincy Aviation LLC · Manistee, MIBuilt 1972 · S/N AA1A-0460N7264LLarson Aircraft LLC · Sandy, UTBuilt 1972 · S/N AA1A-0464N7265LGulfstream Aerospace Corp · Savannah, GABuilt 1972 · S/N AA1A-0465N72681Riggs Benjamin D · Reynoldsburg, OHBuilt 1946 · S/N 9857N7268LFletchair Inc · Comfort, TXS/N AA1A-0468N7273KPetik Neil · Barney, NDBuilt 1950 · S/N 18-182N7276KSaunders Timothy S · Utopia, TXBuilt 1950 · S/N 18-184N72772Wells Danny L · Tipp City, OHBuilt 2021 · S/N 91495N7278KHolden Daniel N · Anacortes, WABuilt 1950 · S/N 18-185N7279KRaven Wings LLC · Talkeetna, AKBuilt 1950 · S/N 18-187N7283KTuttle Jeffery D · Victoria, TXBuilt 1950 · S/N 18-195N72883Donovan Robert J · Bothell, WABuilt 1946 · S/N 10077N7290KAnderson Brent J · Whitewater, MTBuilt 1950 · S/N 18-202N7296KVne LLC · Sheridan, WYS/N 18-210N7297KWarren Mark J · Sleetmute, AKS/N 18-211N7298KNeal Christopher C · Staples, MNBuilt 1950 · S/N 18-212N7299KHofer Todd Paul · Doland, SDBuilt 1950 · S/N 18-213N729RAVentura Joel · Andover, MABuilt 1987 · S/N 1465N729SKOwens Christopher · New Auburn, WIS/N 102995N72KPMorrison Robert H · Fort Denaud, FLBuilt 1994 · S/N 1234N72PMAircraft & Aviation Professionals LLC · Coldwater, MIS/N AA1A-0426N72RCSchmid Mark D · Haddon Heights, NJBuilt 1996 · S/N 459
Back to AD 80-25-02 R2