OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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.

N446PAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 4496086N44702Shawback Brian D · Anchorage, AKBuilt 1974 · S/N 28-7515007N44704West Tampa Bay Flyers LLC · Tarpon Springs, FLBuilt 1974 · S/N 28-7515008N44705Warden James L · West Milford, NJBuilt 1974 · S/N 28-7515010N44708Interthal Mike · Butler, PABuilt 1974 · S/N 28-7405277N4470AAnderson Stephen A · Yuba City, CABuilt 1956 · S/N 18-4822N4470JBister John C · Culver, ORBuilt 1967 · S/N 28-22886N4470ZRegistration Pending · Weatherford, TXRegistration pendingBuilt 1969 · S/N 18-8819N44710Bonin David P · Belmond, IABuilt 1974 · S/N 28-7515012N44714Burchfield Bill · Tanner, ALBuilt 1974 · S/N 28-7515013N44715Skogen Karl L · White Bear Lake, MNBuilt 1974 · S/N 28-7515014N4471ZEgolf Charles F · Spokane, WAS/N 18-8821N4472FA&J Aircraft Leasing Inc · Burlington, COBuilt 1976 · S/N 28-7715034N4472RFlyrite Aviation LLC · Fort Myers, FLBuilt 1974 · S/N 17263214N4473FPate Elaine · Thousand Oaks, CABuilt 1976 · S/N 28-7715035N4473JAj Aviation LLC · Gwinner, NDBuilt 1967 · S/N 28-22889N4473PSemeniuk Steven T · Houston, TXS/N 23-2018N4473RMiller Keith A · Reedy, WVBuilt 1974 · S/N 17263215N4473XSlipstream Aviation LLC · Calera, ALBuilt 1975 · S/N 28-7690018N4473ZEriksen Rodney B Trustee · Juneau, AKBuilt 1969 · S/N 18-8822N44749Hoprich Jeffrey S · Roanoke, VABuilt 1974 · S/N 28-7515021N4474ZWatts Craig W · Incline Village, NVBuilt 1969 · S/N 18-8824N44753Registration Pending · Torrance, CARegistration pendingBuilt 1974 · S/N 28-7505006N4475JHilburn Brian · Philadephia, PABuilt 1967 · S/N 28-22891N4475PRamaswamy Gautam · Clearwater, FLBuilt 1961 · S/N 23-1997N44761Henderson Gregory S · Saltsburg, PABuilt 1974 · S/N 28-7515025N44763Flying Peanuts LLC · Wilmington, DEBuilt 1974 · S/N 28-7505007N4476ZS And C Flying LLC · Pierre, SDS/N 18-8827N44771Benedict Kevin M · Lakeland, FLBuilt 1974 · S/N 28-7525003N44772Hanson Donald H · Bellevue, WABuilt 1974 · S/N 28-7515028N44773Nair Vihas G · Philadelphia, PABuilt 1974 · S/N 28-7515029N44775Heuerman Jordan D · Casey, ILBuilt 1974 · S/N 28-7515030N4477ABrown Danny J · Skidmore, MOBuilt 1956 · S/N 18-4833N44786Flight Academy LLC · Van Nuys, CAS/N 28-7515032N44789Dzialo Matthew J · Pawtucket, RIBuilt 1974 · S/N 28-7505011N4478AOrth Henry J · Wasilla, AKBuilt 1956 · S/N 18-4835N4478JFly 500 LLC · Fort Pierce, FLBuilt 1967 · S/N 28-22894N4478TSchroder David A · Venice, FLBuilt 1972 · S/N 28-7205168N4478XWhite Raymond W · Montrose, MIBuilt 1975 · S/N 28-7615017N44792Ocean Air Inc · Eugene, ORBuilt 1974 · S/N 28-7515064N4479RUp And Up Aviation LLC · Magnolia, TXS/N 17263221N4479ZHardan Weston W · Palmer, AKBuilt 1969 · S/N 18-8834N447KSPoletto Danny A · Great Falls, MTBuilt 1969 · S/N 28-25439N447PJones Thomas C · Friendswood, TXS/N 108N447TCOrange Sky LLC · Naples, FLS/N 006N447WPWall Cameron J · Enid, OKBuilt 2002 · S/N 5701N44800Schoppe Marc · Durham, NCBuilt 1975 · S/N 28-7505012N44805Gage Christopher · Truckee, CABuilt 1974 · S/N 28-7525008N44806Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1974 · S/N 28-7515037N4480JGonzalez Guadalupe G · Atwater, CABuilt 1967 · S/N 28-22896
Back to AD 80-04-03 R2