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.

N3109TS-J Air LLC · Salem, MOBuilt 1967 · S/N 17700409N310FSModi Yogini · Homestead, FLBuilt 1979 · S/N 17272281N310VMSkrzecz Michael T · Phoenix, AZBuilt 1979 · S/N R18200720N310WAHbhis LLC · Gnadenhutten, OHBuilt 2002 · S/N 437-2002N3114TClark Thomas J · Saint George, UTBuilt 1967 · S/N 17700414N3118TButts Thomas E · Alma, GABuilt 1967 · S/N 17700418N311EHFive Six Zero One LLC · Orange, CABuilt 1977 · S/N 17269158N311HBChristiansen Aviation LLC · Wilmington, DEBuilt 1979 · S/N 17272347N311JBJack Brain And Associates Inc · Castro Valley, CAS/N P21000539N311LBNewton Michael A · Cameron Park, CABuilt 1969 · S/N 700014N311MMAndrews Karen · Napa, CABuilt 1978 · S/N R18200366N311PMGullwing Research LLC · Boise, IDBuilt 2018 · S/N 592-2018N311WCIndy Aviation LLC · Dover, DES/N 24-1583N311XStevens Adam · Dacono, COBuilt 1963 · S/N 2592N3121THall Tyler · Billings, MTS/N 17700421N3123EKanase Padmaneel B · Amarillo, TXS/N 17271444N31251Registration Pending · Marana, AZRegistration pendingS/N 399-72N31252Buchholz Claus W · Haslett, MIBuilt 1972 · S/N 249-72N31256Mason Crosby H · Zebulon, NCBuilt 1972 · S/N 330-72N31257Lea Nathan · Belgrade, MTBuilt 1972 · S/N 400-72N31259Rowlett Jeffery B · Tuckerman, ARBuilt 1972 · S/N 883-72N3125THamilton Brian H · Currie, MNBuilt 1967 · S/N 17700425N31262Sauer Roger A · Glenburn, NDBuilt 1972 · S/N 401-72N31263Handerson Ronald J · Sitka, AKBuilt 1972 · S/N 402-72N31266Registration Pending · Wasilla, AKRegistration pending, pending cancellationBuilt 1972 · S/N 403-72N31267Kieffaber Thomas M · Sagamore Hills, OHBuilt 1972 · S/N 887-72N31268Brown Gregory J · Cordova, TNBuilt 1972 · S/N 404-72N31269Happenstance LLC · Cabot, ARBuilt 1972 · S/N 885-72N3126EN3126e LLC · Columbus, OHBuilt 1978 · S/N 17271446N3126TNicholson Homer L · Ponca City, OKBuilt 1967 · S/N 17700426N31272Nelson Debra M · Astoria, ORBuilt 1972 · S/N 406-72N31273Haselmo Zak-Newton · Park River, NDS/N 52-72N31280Kaster Kenny C · Prineville, ORBuilt 1972 · S/N 408-72N31281Citabria 1972 LLC · Soldotna, AKBuilt 1972 · S/N 888-72N31283Somes Jason · Santa Rosa Valley, CAS/N 334-72N31284Allen Earl R · Cottonwood, CABuilt 1972 · S/N 411-72N31285Ramsey Blake P · Wasilla, AKBuilt 1972 · S/N 413-72N31292Beranek John W · Prairieburg, IABuilt 1972 · S/N 417-73N31293Scroggins Darrel T · Springfield, MOBuilt 1972 · S/N 56-73N31294Molyneux Gawen G · Yucaipa, CABuilt 1972 · S/N 336-73N31298Rivers Jerry M · Chesterfield, SCBuilt 1972 · S/N 891-73N3129TMcdaniel Timothy A · Hutchinson, MNBuilt 1967 · S/N 17700429N312AMDueck Arthur Peter · Lakewood, OHBuilt 1974 · S/N 177RG0562N312AVAshley Dallas · Cardiff By The Sea, CABuilt 1968 · S/N 680049N312CLBroadseam Aviation LLC · Kodak E, TNS/N 17263599N312SCBarker Family Investments Management Co LLC · Tyler, TXBuilt 1981 · S/N 21064474N312SMShelbyville Flight Academy LLC · Smyrna, TNBuilt 1977 · S/N 17270091N312TATaylor Charles E · Glen Ellyn, ILBuilt 1979 · S/N 17273565N312TDAircom Nwa LLC · Siloam Springs, ARBuilt 1976 · S/N 17266129N312TSWoodford John E · Madison, WIBuilt 1998 · S/N 408-98
Back to AD 80-25-07 R1