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.

N15968Culberson Donald J · Orange Park, FLBuilt 1973 · S/N 28-7305200N1596ETeam 172-03 LLC · Warsaw, INS/N 17271060N1596JWard Lawrence G · Mckenzie, ALBuilt 1941 · S/N 28-24007N1596RTc Aviation Ltd · Fairbanks, AKBuilt 1975 · S/N AA5B-0096N15975Bourgeois David · Westminster, MABuilt 1973 · S/N 28-7305226N15976Lake Life Aviation LLC · Yukon, OKBuilt 1973 · S/N 28-7305203N1597JLs Aviation LLC · Searcy, ARS/N 28-24008N15984Hewitt Jeremy K · West Jordan, UTBuilt 1973 · S/N 28-7325218N1598JHassard Maitland · Goodyear, AZBuilt 1967 · S/N 28-24009N1598RJam Cat LLC · Orlando, FLBuilt 1975 · S/N AA5B-0098N15994Self Thomas C · Madisonville, TNS/N 28-7325222N1599RLuka Robert E · Berea, KYBuilt 1967 · S/N 28-3845N1599XDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1975 · S/N 28-7505245N159DSSmart Charles R · Verden, OKBuilt 1978 · S/N 70384N159DWWilcoxon Duane E · Arlington, WAS/N PITTS 01 DWN159ERTetterton Marshall O · Crescent City, FLBuilt 1989 · S/N 2841211N159NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1998 · S/N 2842031N159RJBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 17702038N159RVTullos George E · Madison, MSFirst renewal noticeBuilt 2003 · S/N 90362N159TMKcsi Aerial Patrol Inc · Bakersfield, CABuilt 2002 · S/N 462-2002N159WMFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 2002 · S/N 4496159N15ADDurrent Aviation LLC · Anchorage, AKBuilt 1978 · S/N 18-7809065N15AFRogers Jeff · Harrogate, TNBuilt 1976 · S/N 17267237N15BCWingsleasing LLC · Wichita, KSBuilt 1964 · S/N 28-1712N15CHOrlando Flight Academy Inc · Apopka, FLBuilt 1974 · S/N 28-7415277N15CMCarolina Aero Group LLC · Youngsville, NCBuilt 2004 · S/N 2280N15CZSafe Aero LLC · Fort Myers, FLBuilt 2005 · S/N 72N15DEVlazny Stephen F · Divide, COBuilt 1992 · S/N 1N15DVJoiner Robert W · Worton, MDS/N SDV-RJ-02N15ESCyr Gregory A · Augusta, MEBuilt 1988 · S/N 001N15FPFoxtrot Papa LLC · Slidell, LABuilt 1977 · S/N 17268574N15GWFlight Brothers LLC · Sachse, TXBuilt 1969 · S/N 17258161N15HJMorehouse Cooper · North Pole, AKS/N 17268950N15JMSale Reported · WurzburgSale reportedBuilt 1981 · S/N 44-8107060N15JWTri-Cap International · Roanoke, TXBuilt 1959 · S/N TD-225N15LFNorthrup George William · Ellicottville, NYBuilt 1998 · S/N 1395N15LRBoggs James A · Tucson, AZBuilt 1994 · S/N 1309N15LWIsaak Robert J · Pocatello, IDBuilt 2001 · S/N 90016N15NBMorris Russell K · Cameron Park, CABuilt 1978 · S/N AA5B0974N15NFRegistered aircraftBuilt 1969 · S/N 17258204N15PCCarr Patrick L · Fairmont, WVBuilt 1997 · S/N 1214N15QAQuiet Aero LLC · Fort Myers, FLBuilt 1960 · S/N 24-2388N15RAAviation Career Enrichment Inc · Atlanta, GABuilt 1970 · S/N 17259568N15RMFlying Y Farms LLC · Klamath Falls, ORBuilt 1969 · S/N 18-8814N15RVCrawford Larry G · California, MOS/N 298N15SEWilliams Paul E · Kendallville, INBuilt 2005 · S/N 1386-2005N15SWNi Oliver Xingyuan · Norfolk, VABuilt 1968 · S/N 17256875N15TSSchell Timothy N · Dubois, WYBuilt 1996 · S/N 23802N15USale Reported · Van Nuys, CASale reportedBuilt 1979 · S/N ME-160N1600RColeman Daniel L · Chattanooga, TNBuilt 1974 · S/N AA5-0700
Back to AD 80-04-03 R2