OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,478

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-04-03-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-04-03-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.

N1102CWakefield Aviation LLC · Mahopac, NYS/N 17702674N1102MEls Dennis J · Centralia, ILBuilt 1970 · S/N 17259492N1102XMarak Enterprises LLC · Galena, MOBuilt 1975 · S/N 28-7505210N1103MFlying M Enterprises · Loomis, NEBuilt 1970 · S/N 17259493N1103XHolmgren Joel A · Chisago City, MNBuilt 1975 · S/N 28-7515388N1104MCarrolls Auto & Aircraft LLC · Muncie, INS/N 17259494N1105CLandon Jeff · Lancaster, CABuilt 1977 · S/N 17702675N11063Blanchard Robert W · Elverta, CABuilt 1965 · S/N 78N1106AMountain Air Spray Co · Craig, COBuilt 1951 · S/N 18-694N1107HShurtz William W Jr · Medford, ORBuilt 1977 · S/N 28-7715308N11087Levanders Aircraft LLC · Grand Island, NES/N 71N1108EScissortail Aviation LLC · Enid, OKBuilt 1977 · S/N 984-77N1108XThompson Trisha L · Clearwater, KSBuilt 1975 · S/N 28-7515389N11090Lohr Martin J · Petersburg, AKBuilt 1966 · S/N 35N1109USky Quest Inc · Wilmington, DEBuilt 1976 · S/N 17266849N1109XBruno Michael J · Pittsburg, CABuilt 1975 · S/N 28-7505211N110AUHernandez-Santiago Ruben A · Ponce, PRBuilt 1975 · S/N 17265538N110BXCk Leasing Services LLC · Wilmington, DEBuilt 1974 · S/N 17263746N110JA3mw Farms Inc · Hallock, MNBuilt 1974 · S/N 28-7515135N110KWWood Kenneth G · Westerville, OHBuilt 1989 · S/N 264N110LMGo Vertical Aviation LLC · Russellville, ALBuilt 1979 · S/N 28-7990277N110MCMcwindy Inc · Lake Forest, ILS/N 005N110MFHunter Gregory G · Seattle, WABuilt 2001 · S/N 0010N110RRiggins James · Monument, COBuilt 2002 · S/N 95-001JRN110RJMathias Ralph · Long Beach, CAS/N 17272173N110SGTaylor John III · Suwanee, GABuilt 2001 · S/N 458-2001N110SUAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-81N110TSeymour Lori L · Woodstock, GAS/N 342-HN110TNMaloney Casey · Placerville, CABuilt 1972 · S/N 28-7305054N110VPFly Aviation Corp · Wilmington, DEBuilt 1977 · S/N 28-7716189N11103Hennigan Shellie · Jonesboro, LAS/N 17702325N1110FSallade William L · Coudersport, PABuilt 1966 · S/N 17254705N11115Crist Steve · Reno, NVS/N 17262410N1111LShepard Logan K · Sultan, WABuilt 1983 · S/N 277N11132Triple One 32 LLC · Sergeant Bluff, IABuilt 1995 · S/N 2890230N1113NSkywagon Aero LLC · Wilmington, DEBuilt 1975 · S/N 18-7509033N1113ULeft Base Aviation LLC · Niagara, WIBuilt 1989 · S/N 2890126N1115JJordan Jonathan D · Twin Falls, IDS/N 23-149N1115UAvian Leasing LLC · Bremerton, WABuilt 1976 · S/N 17266851N1116ESkyhawk Aviation LLC · Albuquerque, NMBuilt 1977 · S/N 981-77N1116LR J Berra Inc · Burtonsville, MDBuilt 1963 · S/N 278N1116PSale Reported · Scottsville, VASale reportedBuilt 1955 · S/N 23-126N11172Skaaire Society · Madison, WIBuilt 1975 · S/N 17702327N1117RSchmidt Gail · Florence, COS/N 2008N1117UBhp Aviation · Santa Clara, CABuilt 1976 · S/N 17266852N1118AKing Charles W · Kelseyville, CABuilt 1976 · S/N AA5A-0192N1118MBrown Brent R · Edmond, OKBuilt 1970 · S/N 390N1118NJets To Helis LLC DBA · Chandler, AZBuilt 1991 · S/N 1780N1118QAscend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 28-7716083N1118ZMoorhouse Mark A · Santa Fe, TNBuilt 1963 · S/N 28-1118
Back to AD 80-04-03 R2