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.

N401LSEl Paso Aero Inc · El Paso, TXBuilt 1982 · S/N 17275784N401PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843444N401RSawyers Ron S · Hayden, IDBuilt 1991 · S/N 1647N401TCPrecision Ag Air LLC · Pendleton, INS/N 20279N4020DInnovative Design Group Inc · Watkinsville, GABuilt 1999 · S/N 21063CN4020XCox Nathaniel E · Ocala, FLBuilt 1970 · S/N 5149N4020ZFinch Ernest B · Anchorage, AKBuilt 1963 · S/N 18-7972N4022ZKahn Steven H · Port Alsworth, AKBuilt 1963 · S/N 18-7974N40230Harris Dan C · Rockford, TNS/N 1470N40234Mallow David N · Rio, WVS/N 18-7509115N40238Blue Ridge Community College · Weyers Cave, VAS/N 1474N4023FFreese Barry L · Leonardtown, MDBuilt 1976 · S/N 28-7715003N4023XRhodes Stephen · Marion, NCBuilt 1969 · S/N 5123N4023ZLunenschloss Michael L · Anchor Point, AKBuilt 1963 · S/N 18-7975N40246Harper Matthew C · Anchorage, AKBuilt 1975 · S/N 18-7509118N4024JKeleti Laurie · Lakewood, NJBuilt 1975 · S/N 28-7525271N4024XFaussett Thomas J · Greenville, MIS/N 5124N4024ZBrown Timathy S · Wasilla, AKBuilt 1963 · S/N 18-7977N4026NSeiger T W DBA · Medford, ORBuilt 1968 · S/N 680021N4026XAlderin Charles A · Center, NDBuilt 1969 · S/N 5126N4027PAg Air Squadron One LLC · Saint Joseph, ILBuilt 1958 · S/N 23-1502N4027XMinor Joann M Raimond · San Diego, CABuilt 1969 · S/N 5127N40283Keech Mark A · Fairbanks, AKBuilt 1975 · S/N 18-7509119N40286Dwm55 LLC · Kalispell, MTBuilt 2001 · S/N 21704N4028ZFlower Pot Cattle Co LLC · Arlington, AZS/N 18-7982N40294Reese Steven A · Shoreline, WABuilt 2001 · S/N #123 KITN4029BDiebel Dean L · Orlando, FLBuilt 1982 · S/N 651N402MReyner Mark D · Los Lunas, NMBuilt 1996 · S/N 20807N402PKMitchell John J · Whitewater, WIS/N 002N402WBNew England Airlines Inc · Westerly, RIBuilt 1977 · S/N 28-7790524N403Pescatore Thomas F · Monte Vista, COBuilt 1999 · S/N 1451N4030CAdcock Corey J · Victoria, TXFirst renewal noticeBuilt 1990 · S/N 1544N4030UEagle Services Inc · Washington, MIBuilt 1990 · S/N 1545N4031PGarrett Randy L · Pensacola, FLBuilt 2002 · S/N 60374N4031WBering Pacific Ranches Ltd · Foothills AbBuilt 1990 · S/N 1540N4032PTinny Twister Aviation LLC · Fort Myers, FLBuilt 1958 · S/N 23-1508N4033TCrop Doctors LLC · Micanopy, FLS/N 1471N4033XMcbride William M · New Castle, DEBuilt 1970 · S/N 5133N4033ZSale Reported · Port Alsworth, AKSale reportedBuilt 1963 · S/N 18-7993N4034PKoenig William J · Benedict, MDS/N 23-1510N4034XPrivus Inc · Brooklyn, NYBuilt 1970 · S/N 5134N40353Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1574N4035RMoreau Donald G · Dayton, TXBuilt 1970 · S/N 28-5796N4035ZPeninsula Aero Technology Inc · Kenai, AKS/N 18-7995N4036ERieger John R · Plevna, MTBuilt 1977 · S/N 18-7809042N4036NJestice Manuel P · Ryder, NDBuilt 1968 · S/N 680023N4036PFiegel Donald H · Ward, ARBuilt 1958 · S/N 23-1512N4036RN4036r LLC · Quinton, ALBuilt 1970 · S/N 28-5663N4036ZHockey Puck LLC · Big Lake, AKBuilt 1963 · S/N 18-7996N40374Solo Exteriors Co LLC · Seminole, TXBuilt 1991 · S/N 1668
Back to AD 80-04-03 R2