OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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:87-20-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:87-20-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.

N4546FThomas Craig E · Stevensville, MTBuilt 1966 · S/N 185-1039N4546UHarrier Soaring Club Inc · Raleigh, NCBuilt 1964 · S/N 15060546N45471Verhoeven Mathew M · Avondale, AZBuilt 1975 · S/N 15076941N45473N2flyingaviation LLC · Foxworth, MSBuilt 1975 · S/N 15076942N45478Unertl Robert C · Columbus, WIBuilt 1975 · S/N 15076946N4547EG&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17271626N4547URegistered aircraftN-number assigned, not yet registeredS/N 15060547N4548BSchad Anthony J · Oceanside, CABuilt 1955 · S/N 31447N4548FWard Nelson H · Salcha, AKBuilt 1966 · S/N 185-1043N4548UHaan James J · Norton Shores, MIS/N 15060548N45491Birdwin LLC · Buras, LABuilt 1975 · S/N 15076951N45496B&R Aircraft LLC · Wadsworth, OHS/N 15076952N4549CWatsons James W · Fairbanks, AKBuilt 1953 · S/N 25493N4549FMetroaire LLC · Mc Kees Rocks, PABuilt 1966 · S/N 185-1045N4549UJmh Futures LLC · Gilbert, AZS/N 15060549N454BMCorman David L · Lovington, ILBuilt 1972 · S/N 17260799N454DMGerman George Derlin · Petaluma, CABuilt 1979 · S/N R18201162N454GGAk Air Leasing LLC · Homer, AKBuilt 1981 · S/N U20606487N454SVEcliax LLC · Craig, AKBuilt 1981 · S/N U20606524N4550BHickle William H · Inyokern, CABuilt 1955 · S/N 31449N4550CBrown Larry A · Mesa, AZBuilt 1953 · S/N 25494N4550EPommy & Swede LLC · Valentine, NEBuilt 1978 · S/N 17271628N4550UGreene County Holdings LLC · Albany, NYBuilt 1964 · S/N 15060550N45510Hansen Albert C · Mojave, CABuilt 1975 · S/N 15076954N45511Sb Aviation LLC · Gowanda, NYBuilt 1975 · S/N 15076955N45512Caponio & Sons Inc · San Francisco, CABuilt 1975 · S/N 15076956N45520Frazier John C · Oxford, NCBuilt 1975 · S/N 15076958N4552CMckinney Lodging Management LLC · Trout Lake, WABuilt 1952 · S/N 25496N45530Young Thomas E Jr · Alton, MOBuilt 1975 · S/N 15076962N4553SMinion Air Inc · John Day, ORBuilt 1968 · S/N 18259182N4553UCoyle Jonathan D · Franktown, COBuilt 1964 · S/N 15060553N45541Zxtair LLC · Mankato, MNFirst renewal noticeBuilt 1975 · S/N 15076966N45542Baldridge Steven J · Edmonds, WAS/N 15076967N4554FFejes Jacob J · Watertown, NYS/N 185-1057N4555CVan Roo Jon D · Hartland, WIBuilt 1953 · S/N 25499N45560Johnson Adam · Denton, TXBuilt 1975 · S/N 15076971N45563Tremer Jesse · Kathleen, GABuilt 1975 · S/N 15076972N45566Watts Charles B IV · Pace, FLBuilt 1975 · S/N 15076973N45570San Mateo Flying Club Inc · Palo Alto, CAS/N 15076974N4557FKincaid Jonathan A · Frankfort, MEBuilt 1966 · S/N 185-1061N4557UCrum Thomas A · Loyal, OKBuilt 1964 · S/N 15060557N45582Burch Jacqueline L · Aguanga, CABuilt 1975 · S/N 15076980N45586Rak Aviation LLC · Everett, WABuilt 1975 · S/N 15076982N45588Dahlonega Mountain Flyers Inc · Dahlonega, GABuilt 1975 · S/N 15076983N4558BDe Ley Taylor · Yorba Linda, CABuilt 1955 · S/N 31457N4558CFarrell Raymond E · Monument, COBuilt 1953 · S/N 25502N4558FN4558f LLC · Columbus, OHBuilt 1966 · S/N 185-1062N4559UBoyd Jeffrey S · Hutsonville, ILBuilt 1964 · S/N 15060559N455AFGlacier Bay Aviation LLC · Fayetteville, GABuilt 1968 · S/N 17701336N455AKBarr Scott A · Barrow, AKS/N 18260061
Back to AD 87-20-03 R2