OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,364

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.

N113CJMarshall Joshua · Chuckey, TNBuilt 1979 · S/N R18201076N113DRCalifornia In Nice Inc · San Jose, CABuilt 1975 · S/N 17265961N113FASale Reported · Dallas, TXSale reported, canceledBuilt 1981 · S/N 15285090N113FSHallahan Robert J · Central Square, NYBuilt 1974 · S/N 17262996N113JJRendleman Robert T · Murphysboro, ILBuilt 2000 · S/N 858-2000N113MEButler Robyn L · Vale, ORS/N 909-76N113MSFly2walk LLC · Loveland, COBuilt 1996 · S/N 1217-96N113TTHaley John R · Tomball, TXBuilt 1979 · S/N P21000281N11404Kronenberger Charles · Crockett, TXBuilt 1981 · S/N 24-1163N1140LLerma Michael A · Panama City, FLBuilt 1981 · S/N 24-1158N1141ALatvala Jerry B · St Simons Is, GABuilt 1981 · S/N 24-1164N1141KWilson Adam V · Flower Mound, TXBuilt 1981 · S/N 24-1214N1141MSunshine Flyers · Auburn, CAS/N 17260152N1141NWild Havamalt LLC · Kalispell, MTBuilt 1981 · S/N 24-1168N1141UFlight School Inc · Spring, TXBuilt 1976 · S/N 17266870N1141ZMccord Geoffrey A · Tavares, FLBuilt 1981 · S/N 24-1171N11423Boland Aviation LLC · Newton, NJBuilt 1981 · S/N 24-1178N11429Schwartz David J · Bellaire, MIBuilt 1975 · S/N 17702338N1142GMorgan Robert Brian · Ozark, MOBuilt 1981 · S/N 24-1172N1142LMcdonald Brennan P · Orlando, FLBuilt 1981 · S/N 24-1162N1142MStewart Eric · Lott, TXBuilt 1981 · S/N 24-1174N1142THaskell Bryan William · Belmont, NCBuilt 1981 · S/N 24-1175N1143AStraeter Eckhard · Lempster, NHBuilt 1981 · S/N 24-1179N1143ENevarrow Leon · Spring Valley, CABuilt 1977 · S/N 1215-77N1143KBishop Nathan Wesley · League City, TXBuilt 1981 · S/N 24-1181N1143MCastelletti Mark Anthony Trustee · Casa Grande, AZBuilt 1970 · S/N 17259443N1143NMichael K Bristow · Smyrna, GABuilt 1981 · S/N 24-1183N1144KYoung Bradley M · Vancouver, WABuilt 1981 · S/N 24-1185N1144MCcr Aviation LLC · Kalispell, MTS/N 17259444N1144NHanovich Robert L Jr · Flagstaff, AZBuilt 1981 · S/N 24-1186N1144WNimmo Lawrence · Cordova, MDBuilt 1981 · S/N 24-1189N1145TWilliams Thomas J · Burr Ridge, ILBuilt 1981 · S/N 24-1191N1145UWws Air LLC · Savannah, GABuilt 1981 · S/N 24-1192N1146JAdam Spencer · New York, NYBuilt 1981 · S/N 24-1197N1146LSak Aviation LLC · Cheney, KSBuilt 1981 · S/N 24-1198N1146PElkin Christopher E · Talpa, TXBuilt 1981 · S/N 24-1199N1146TGandhi Mehul · Hayward, CAS/N 24-1200N11476Shannon Kenneth H · Washington, DCBuilt 1975 · S/N 17702340N1147AShipley & Son Ltd · Capitan, NMBuilt 1981 · S/N 24-1202N1148BBallard Neil B · Mankato, MNBuilt 1981 · S/N 24-1204N1148GJackson Brian · Oklahoma City, OKBuilt 1981 · S/N 24-1205N1148NForbes Ryan C · Newnan, GABuilt 1981 · S/N 24-1208N1148UCaromac LLC · Florence, SCBuilt 1981 · S/N 24-1210N11495Risoldi John L Sr · Kitty Hawk, NCBuilt 1981 · S/N 24-1220N1149UFerraro Alfred A Jr · Milford, CTBuilt 1981 · S/N 24-1216N1149XGossman Mitchell V · Saint Cloud, MNBuilt 1981 · S/N 24-1218N114BBServtek LLC · Waterloo, WIBuilt 1977 · S/N 24-0118N114FAJprg Aviation Inc · Orlando, FLBuilt 1978 · S/N 17271720N114JMC29 Taildragger LLC · Middleton, WIBuilt 2006 · S/N 481-2006N114TJKnochenmus Matthew L · Corcoran, MNBuilt 1996 · S/N 382-96
Back to AD 80-25-07 R1