OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N21ATMeadville Aero Club LLC · Erie, PABuilt 1977 · S/N 17268907N21BESpecialized Helicopter Training LLC · Middleton, IDBuilt 1979 · S/N P21000456N21BMGandee James T · Bullhead City, AZS/N 21061941N21CFSmith Robert R · Benton, LABuilt 1974 · S/N 17702163N21CPT Howard And Associates Architects Inc · Dallas, TXBuilt 1961 · S/N 18253721N21CTFerreira Douglas B Trustee · Chico, CABuilt 1978 · S/N P21000021N21DFDose Gary W · Pinehurst, IDBuilt 1977 · S/N 18265789N21EBSunview Flying Service LLC · Jordan, NYBuilt 1974 · S/N 177RG0589N21EWRountree Christopher B · Burbank, CAS/N 18255335N21FFHor Aviation LLC · Harrisburg, PABuilt 1969 · S/N 18260179N21KRNorcon Enterprises Inc · Amarillo, TXFirst renewal noticeBuilt 1979 · S/N P21000285N21LDCaswell Bruce · Charleston, WVBuilt 1963 · S/N 18255173N21LS7ac Aviation LLC · Fort Worth, TXBuilt 1964 · S/N 17251817N21LTMission Flight · El Monte, CABuilt 1979 · S/N P21000216N21LWRegistered aircraftBuilt 1973 · S/N 18261932N21MBAarons David J · Birmingham, ALBuilt 1975 · S/N 15077002N21PLYankee Flying Club Inc · Maple Grove, MNBuilt 1984 · S/N R18201983N21PVPeterson Kirk A · Nixa, MOBuilt 1966 · S/N 18256921N21RGMacair Aviation LLC · Xenia, OHBuilt 1969 · S/N 20700066N21RHWogan Joseph M · Mesa, AZBuilt 1972 · S/N 18261224N21RPJ-Dawgs Aviation LLC · Greenville, NCS/N 17252591N21SJPointcloud Aviation LLC · Plymouth, MNBuilt 1981 · S/N 18267869N21TBAughinbaugh Christopher · Rancho Cordova, CABuilt 1966 · S/N 18257128N21TGScott John · Arcadia, FLBuilt 1972 · S/N 18261547N21TNNavar Thomas R Jr · El Paso, TXS/N 31685N21YCp Aviation Inc · Santa Paula, CABuilt 1954 · S/N 30837N22001Fisher Robert G Jr · Hodges, SCBuilt 1967 · S/N 15068000N22003Hall David D · Des Moines, WAS/N 15068002N22009Dundon Nick · Bozeman, MTBuilt 1967 · S/N 15068006N2200GCarey Alan W · Fallon, NVBuilt 1958 · S/N 51500N2200XPowell George · Locust Grove, GABuilt 1965 · S/N 337-0100N22014Sun Valley Aviation Inc · Harlingen, TXBuilt 1967 · S/N 15068010N22016Kiehle Ingrid E · Anchorage, AKS/N 15068012N22019Swindell Daniel J · Greensburg, PABuilt 1967 · S/N 15068014N2201DPoage James A · Fairbanks, AKBuilt 1952 · S/N 20353N2201YInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 17700001N22025Scheck Christopher R · Troutdale, ORBuilt 1967 · S/N 15068016N22027Lyles Bobbi L · Broken Arrow, OKBuilt 1967 · S/N 15068018N22029Youth Eagles Aviation · Elk Grove, CAS/N 15068020N2202JMartin Paul H · Willows, CABuilt 1966 · S/N 15065402N22034Robertson David L · Ray, MIBuilt 1974 · S/N 17264052N22037Johanson Jonas P · Groveland, CAS/N 15068023N22039Barkan James · Las Vegas, NVS/N 15068025N2203GBartek John · Glenwood Springs, COBuilt 1958 · S/N 51503N22049Air Carriage Inc · Chico, CAS/N 15068030N2204CPainter Creek Lodge Inc · El Rito, NMBuilt 1953 · S/N 30504N2204GSweet Matt · Galt, CAS/N 51504N2204YEagle Sky Patrol Inc · Deadwood, SDS/N 17700004N22053Stoddard Greg E · Anchorage, AKBuilt 1967 · S/N 15068031N22060Watson Thomas G · Sunderland, MAS/N 15068036
Back to AD 87-20-03 R2