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.

N5934BLlk Aviaiton LLC · Hanksville, UTS/N 33934N5934GDevils Lake Aero Repair Inc · Devils Lake, NDS/N 15071434N5934RHoyt Jacob T · Oneida, NYS/N 17253603N5935ADunn James Blair Jr · Bumpass, VABuilt 1956 · S/N 28535N5935GDeaero LLC · Darwin, MNBuilt 1968 · S/N 15071435N5935JSwinden Jonathan · Danville, PABuilt 1975 · S/N 18263585N5935RStofer William B · Warsaw, INBuilt 1965 · S/N 17253604N5935TValley Wings Flight School LLC · Harlingen, TXBuilt 1964 · S/N 15060635N5936BTorrison Scott D · Chugiak, AKBuilt 1956 · S/N 33936N5937FDodson International Parts Inc · Rantoul, KSBuilt 1967 · S/N 21058937N5937GD'Arge Ranyon Wc · Wilson, WYBuilt 1969 · S/N 15071437N5937RDavies Shane E · Kent, WAS/N 17253606N5938ALand-O-Matics LLC · Wilmington, DEBuilt 1956 · S/N 28538N5938BDocjosh Ltd LLC · Essex, NYBuilt 1956 · S/N 33938N5938TShihadeh Luke C · Wasilla, AKS/N 15060638N5939EWhite Sound International Ltd · New Smyrna Beach, FLBuilt 1983 · S/N 18268339N5939GMasek Ron J · Valley City, OHBuilt 1969 · S/N 15071439N5939RHester James T · Fayetteville, GAS/N 17253608N5939TAdkins Amanda J · Proctorville, OHBuilt 1964 · S/N 15060639N593STN593st LLC · Bangor, MEBuilt 1985 · S/N 17276454N5940RBakrevski Lupcho · Valparaiso, INS/N 17253609N5941RChristian Stuart J · Erskine, MNS/N 17253610N5942GGsell Bruce · Southampton, NJBuilt 1969 · S/N 15071442N5942JNovember Sierra Aviation LLC · O Neill, NES/N A1500242N5942RL&L Ltd · Shoreview, MNBuilt 1965 · S/N 17253611N5943AFox Michael S · Glendale, AZS/N 28543N5943EPlane Zane LLC · Stuart, FLBuilt 1978 · S/N 17271969N5943GFlight Express LLC · Henry, TNBuilt 1979 · S/N 18266907N5943RGear Down Hangar LLC · Phoenix, AZBuilt 1965 · S/N 17253612N5943TMission Flight Academy · Redlands, CABuilt 1964 · S/N 15060643N5944GYakich Adam J · Fairfield, IABuilt 1967 · S/N 15068028N5944RLucas Heaven · Griffin, GABuilt 1965 · S/N 17253613N5944THills Jacob W · Lonepine, MTBuilt 1964 · S/N 15060644N5945RDamme Douglas A · Talmage, NEBuilt 1965 · S/N 17253614N5946AKessinger John · Independence, ORS/N 28546N5946JMillett Paul B · Claremore, OKBuilt 1979 · S/N 18267024N5946RElite Aeronautics LLC · Miami, FLBuilt 1965 · S/N 17253615N5946TEasmunt David P · Hardin, KYBuilt 1964 · S/N 15060646N5947ARoberts James L · Sedgwick, KSBuilt 1956 · S/N 28547N5947FGulf Coast Aviation LLC · Terra Ceia, FLBuilt 1967 · S/N 21058947N5947GGregorzewski Richard D · Jasper, ALS/N 15071447N5947NGmm Records · Big Pine Key, FLBuilt 1972 · S/N 17260597N5947RDillon Aero Inc · Phoenix, AZBuilt 1965 · S/N 17253616N5947SStewart Edgar Alan · Glennallen, AKBuilt 1973 · S/N 18502169N5947TStewart Edgar A · Glennallen, AKBuilt 1964 · S/N 15060647N5948AVerdouw Andrew J · Georgetown, INBuilt 1956 · S/N 28548N5948ETlt Legacy LLC · Fort Worth, TXBuilt 1978 · S/N 17271972N5948F5c1 Ltd · Boerne, TXBuilt 1967 · S/N 21058948N5949FRead Travis E · Lumberton, TXBuilt 1967 · S/N 21058949N5949JAnderson Brian E · Castro Valley, CABuilt 1973 · S/N A1500401
Back to AD 87-20-03 R2