OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,472

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.

N3137ERegistered aircraftBuilt 1978 · S/N 17271448N31385Registration Pending · Missoula, MTRegistration pendingBuilt 1978 · S/N 28-7816554N3138TJones Daniel D · Ekron, KYBuilt 1968 · S/N 17700438N31399G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7816556N313ACAero Craft Of Bloomington LLC · Bloomington, ILBuilt 1977 · S/N 28-7816013N313BLDaggett Keith W · Rockport, MEBuilt 1976 · S/N 17267097N313CZBuckley Robert L Jr · Castle Rock, COBuilt 2009 · S/N 71122N313DCRegistered aircraftBuilt 1978 · S/N 28-7816591N313DDAlpine Air Aviation LLC · West Haven, UTBuilt 2001 · S/N 3226N313GWWright George E Jr · Homestead, FLBuilt 1956 · S/N 18-5260N313HTKiernan Bernard J · Hopewell Junction, NYS/N 1N313KDOdonnell Daniel Gordon · Plymouth, MABuilt 1975 · S/N 17702353N313LNBazal Jared W · Castle Rock, COS/N 28-2571N313TAD A Consulting Inc · Orlando, FLBuilt 1977 · S/N AA5A0312N313WMKafer Mark T · Colleyville, TXBuilt 1965 · S/N 28-2678N31400Druidia Group LLC · Downingtown, PABuilt 1978 · S/N 28-7816557N3140TSuggs Helen T · Jacksonville, FLBuilt 1967 · S/N 17700440N3140ZHoyt Kenneth B · Marion, KSBuilt 1959 · S/N 22-7084N3141EPower City Aviation Inc · Hazleton, PABuilt 1978 · S/N 17271449N3141TN3141t LLC · Saint Johns, MIBuilt 1967 · S/N 17700441N3141ZKumbier Jenene R · Maxwell, IABuilt 1959 · S/N 22-7086N31429Leonard Gordon A · Anchorage, AKBuilt 1991 · S/N 20649N3142TTri State Airmotive LLC · Berryville, ARS/N 17700442N3143DRoland Ann J · Woodland, CAS/N SA1025-75013LFN3143WLoyd Marion S · Dumas, ARBuilt 1991 · S/N 1920N3143ZChristian Edward A · Evans, GABuilt 1959 · S/N 22-7088N3144PEurohaus LLC · Phoenix, AZBuilt 1957 · S/N 23-1075N3144TKinsfather John D · Fowler, CABuilt 1967 · S/N 17700444N3144ZWasilowski Richard P · Arlington, WABuilt 1959 · S/N 22-7089N3145MWright Jeffrey Crandel · Opelika, ALBuilt 1992 · S/N L001N3146LGarnett Robert A · Drewsey, ORBuilt 1992 · S/N 595N3147TClinton Grant A · Portage Des Sioux, MOS/N 17700447N3147ZNeudorf Robert H · Alamogordo, NMBuilt 1959 · S/N 22-7094N3148TMiller John W · Bluffton, INBuilt 1967 · S/N 17700448N3149QClear Air LLC · Ashford, CTBuilt 1977 · S/N 28-7790439N3149TShugart Fredrick William · Canfield, OHBuilt 1967 · S/N 17700449N314AVN1412v LLC · Manassas, VABuilt 1974 · S/N 17263557N314EPHeadings Andrew R · Blue River, WIBuilt 1998 · S/N 24378N314GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1981 · S/N 17274774N314JASharp Jerry L · Georgetown, TXBuilt 1984 · S/N 828N314KBMatthews Grover C · Hardinsburg, KYBuilt 1958 · S/N 23-1391N314REvans Randall B Trustee · Fallon, NVBuilt 1998 · S/N 399-98N314RSAcorn Mutual Flying Club Inc · Hershey, PABuilt 1977 · S/N 17269038N314SHGrover Arlan K · Aurora, COBuilt 1999 · S/N 114N314SRRoesler Scott D · Homer, AKBuilt 1989 · S/N 314N314YOlson Allen J · Ludington, MIBuilt 1975 · S/N 69N3150WRegistration Pending · Olympia, WARegistration pendingBuilt 1979 · S/N VAC-126-79N3151EAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 17271453N3151RBergstrom Danny · Stillwater, MNBuilt 1982 · S/N 353N3151XJoseph Stern · Sherman, TXS/N 17702399
Back to AD 80-04-03 R2