OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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.

N6106EBaer Mack III · Marshall, VABuilt 1958 · S/N 46206N6106QSunrise Aviation Inc · Ormond Beach, FLBuilt 1981 · S/N 15285131N61075Evan R Charles · Riverside, CAS/N 15070780N61077Ray Albert B · Prosser, WAS/N 15070782N61078Registered aircraftBuilt 1969 · S/N 15070783N6107EDelta-V Ceramic Technologies Inc · San Jose, CAS/N 18268345N6107GRhea Koy A · Annona, TXBuilt 1969 · S/N 15071607N61081Beattie Mark A · Anaheim, CABuilt 1969 · S/N 15070784N6108BBuchner George E · Nye, MTBuilt 1957 · S/N 34108N6108GPetrov Konstantin P · Hallandale, FLBuilt 1969 · S/N 15071608N6108TKidd Matthew D · Huddleston, VAS/N 15060808N61091O'Flynn Brian · Mimbres, NMBuilt 1969 · S/N 15070794N61092Registration Pending · Cadillac, MIRegistration pendingBuilt 1980 · S/N 18504107N61094Harper Kevin J · Valley Center, KSBuilt 1969 · S/N 15070795N61097Giles David Victor · Gilbert, AZBuilt 1969 · S/N 15070798N6109BTony Flies Inc · Sparta, NCBuilt 1957 · S/N 34109N6109ELucia Christoper J · West Brookfield, MABuilt 1958 · S/N 46209N6109KRiegel Frederick E · Houston, OHBuilt 1975 · S/N 15077530N6109RBas Part Sales LLC · Greeley, COBuilt 1965 · S/N T210-0009N610ACHybird Inc · Corpus Christi, TXS/N 17264912N610AMSwaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 17270193N610HMGadberry & Graham Inc · Baton Rouge, LABuilt 1973 · S/N 18262128N610HPValor View Aviation LLC · Midland, TXBuilt 1981 · S/N 172RG0892N610KCU S Imaging Flight Ops LLC · Bartow, FLBuilt 1981 · S/N 21064258N610MMMaxq Composites LLC · Oxford, MEBuilt 1968 · S/N 337-0961N610MVCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 18267413N610SLTen Hi Flyers Inc · Denver, COS/N 18267376N61102R&G Leasing Llp · Waterford, WIS/N 18504108N61104Backwoods Air LLC · Caro, MIBuilt 1969 · S/N 15070803N61105Dorsey Sage · Bend, ORBuilt 1973 · S/N U20602063N61108Umrysz Jeffrey E · Mystic, CTBuilt 1969 · S/N 15070807N6110BRansom Bradley D · Flagstaff, AZBuilt 1957 · S/N 34110N6110FKilmer Scott D · Fort Pierce, FLBuilt 1968 · S/N 21059010N6110GHigh Exposure Inc · Wilmington, DEBuilt 1969 · S/N 15071610N61110Veit Brett Allen · Willis, TXS/N 15070809N61112Ralph Joshua C · Wichita, KSS/N 15070811N61114Thomas O Bailey · Sutton, NDBuilt 1969 · S/N 15070813N61119Small Aviation No 3 LLC · Villa Rica, GABuilt 1980 · S/N 18504110N6111NMcgyver Airshows LLC · Wilmington, DEBuilt 1980 · S/N 18267788N6111QAces High Aviation LLC · Long Beach, CABuilt 1981 · S/N 15285136N6111TAllen Trevor · Richmond, KYBuilt 1964 · S/N 15060811N61120Jstream Lc · Sheridan, WYBuilt 1969 · S/N 15070814N61123Starnes Robert D · Lavonia, GABuilt 1969 · S/N 15070816N61126Roth Jason G · Seattle, WABuilt 1969 · S/N 15070819N61127Mcgill Phil · Huntsville, ALBuilt 1969 · S/N 15070820N61129Jones Flying Service LLC · Pulaski, TNS/N 15070822N6112ABarreto Manufacturing Inc · La Grande, ORS/N 21063498N6112EMcintire John R · Haymarket, VABuilt 1958 · S/N 46212N6112FPcb Inc · Paradise, CAS/N 21059012N6112KNordby Tyler D · Herman, MNBuilt 1975 · S/N 15077532
Back to AD 87-20-03 R2