OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,471

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.

N8750NMidwest Avionics LLC · Peculiar, MOBuilt 1969 · S/N 28-25570N8751EHansen William L · Shasta Lake, CABuilt 1976 · S/N 28-7690198N8752Fender Darrell L · Colfax, WABuilt 1973 · S/N 469-73N8752VRichard Flying Service Inc · Rayne, LABuilt 1975 · S/N 317-75N8753CSlayden Steven M · Rhome, TXBuilt 1953 · S/N 18-2836N8753NWright Pamela J · Easton, PABuilt 1969 · S/N 28-25573N8754ESix Two Seven Aviation LLC · Sardis, MSBuilt 1976 · S/N 28-7625155N8754VLoomer Donald W · Williston, NDBuilt 1975 · S/N 855-75N8755ABluegrass Aircraft Group LLC · Benton, KSBuilt 1997 · S/N 80864N8755CDebra Cay LLC · Scottsdale, AZBuilt 2003 · S/N 10223N8755EGokoffski Anthony · Larkspur, CAS/N 28-7690200N8755MTraver Ronald D · Lantry, SDS/N M-543N8755VBoettcher Michael W · Soldotna, AKBuilt 1975 · S/N 854-75N8756CDt Aviation LLC · Ontario, CABuilt 1976 · S/N 28-7615125N8756DExecutive Holdings LLC · Fairbanks, AKS/N 22-5940N8756EHowell Richard · Louisville, KYS/N 28-7690201N8756MMutschler George R · Paradise Valley, AZS/N M-544N8757MHolmes Charles E · South Bend, INBuilt 1963 · S/N M-545N8757N57 November LLC · Charlotte, NCBuilt 1969 · S/N 28-25576N8758CYuknis Leonard F · Wasilla, AKBuilt 1953 · S/N 18-2842N8758MAndrew Manuel Driscoll · South Yarmouth, MABuilt 1964 · S/N M-546N8759NDisanto Rocco F · Morganton, NCBuilt 1969 · S/N 28-25580N875ADRegistration Pending · Independence, ORRegistration pendingBuilt 2004 · S/N 22707N875LBeaman David · Knoxville, TNBuilt 1977 · S/N AA5B0672N8760CReindl Thomas A · Algonquin, ILBuilt 1976 · S/N 28-7615126N8760MRegistration Pending · Cheney, WARegistration pendingS/N M-548N8761MJohnson Gregory J · Port Orange, FLS/N M-549N87621Shackelford Gary L · Parrish, FLBuilt 1949 · S/N 869N8762DEpperson James R · Sand Springs, OKBuilt 1958 · S/N 22-5946N8762EPrewitt Russell · Statham, GABuilt 1976 · S/N 28-7625156N8762NKlyc Aviation LLC · Lake City, FLBuilt 1969 · S/N 28-25582N8763EBodwell Keith J · West Cornwall, CTS/N 28-7615160N8764CMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7690160N8764EFa40 Plane LLC · New Port Richey, FLBuilt 1976 · S/N 28-7690202N8764GStrait Media LLC · Anchorage, AKS/N 15062864N8764J374dk Aviation LLC · Sand Springs, OKBuilt 1972 · S/N AA5-0116N8765CLatitude Aviation LLC · Spring, TXBuilt 1976 · S/N 28-7690161N8765EMoore Alex W · Deep Gap, NCBuilt 1976 · S/N 28-7690203N8765FSmith Nelson · Brighton, IAS/N 28-7790266N8765HN8765h LLC · Carthage, NCBuilt 1993 · S/N 1246N8766DRatliff Steven L · Spring Grove, PABuilt 1958 · S/N 22-5952N8767DGriffith Scott G · Newnan, GABuilt 1958 · S/N 22-5953N8767NAbernathy Larry D · Vernon, TXBuilt 1969 · S/N 28-25591N8768FReynolds Darryl G · Wills Point, TXBuilt 1962 · S/N 62-0092N8768NHammonds Benjamin J · Newcomerstown, OHS/N 28-25589N876TBHenderson Tyler J · Goodland, KSBuilt 1999 · S/N 20363N876TUDudley Aviation Services LLC · Wilmington, DEBuilt 2005 · S/N 7030N8771CSummit Aviation LLC · Spokane, WABuilt 1976 · S/N 28-7690163N8773CScott Ansell E · San Diego, CAS/N 28-7690164N8773NBeen Flyin LLC · Colchester, CTBuilt 1969 · S/N 28-25597
Back to AD 80-04-03 R2