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.

N3997VWestfall Lorn W III · League City, TXS/N 15076675N3998DStewart Matthew L · Camano Island, WABuilt 1957 · S/N 34698N3998LKansas Copters & Wings Inc · Augusta, KSBuilt 1966 · S/N 17254167N3998UAlbrecht Koby J · Lawrence, MABuilt 1965 · S/N 15061398N3998VDoornbos Keith · Bloomington, ILS/N 18317N39998Becker Kurt G · Dexter, NMBuilt 1953 · S/N 25958N39999Becker Kurt G · Dexter, NMBuilt 1963 · S/N 15060219N3999JMurphy Arthur John III · Huntsville, ALBuilt 1966 · S/N 15065299N3999LMorris Jeffrey A · Lake Delton, WIS/N 17254168N399FFieldgrove Matt L · Somerton, AZBuilt 1955 · S/N 31478N399HLon Air LLC · Miles City, MTBuilt 1978 · S/N 18266519N399JPL&M Aircraft Inc · Rome, GABuilt 1977 · S/N 177RG1111N399KOsborn Ferrell V · Avery Island, LABuilt 1977 · S/N 18265733N399KMCustodio Olga · San Antonio, TXBuilt 1973 · S/N 21059982N399NBicknell Brooks E · Andover, NHBuilt 1980 · S/N 18267690N399TXCherry Lane R · Vidor, TXS/N 15065205N39AKRenfro Michael W · Bethel, AKBuilt 1980 · S/N 20700597N39BEAberdeen Flying Service · Aberdeen, SDBuilt 1984 · S/N 21064889N39CCWard Bobby J · Dalhart, TXBuilt 1975 · S/N 18502858N39FCStout Keith · Salmon, IDBuilt 1979 · S/N 18503923N39JApex 1996 LLC · Kilgore, TXS/N 18052274N39JJStag Aviation LLC · Tomball, TXBuilt 1966 · S/N 17254265N39MPMission Aviation Training Academy · Arlington, WABuilt 1965 · S/N U206-0288N39PCN39pc LLC · Portsmouth, NHBuilt 1983 · S/N 18268313N39PSSmith Justin Dean · Dayton, TNS/N 18258921N39TDHawk Meadow Aviation LLC · Sutton, AKBuilt 1971 · S/N 15073099N3AQSinnott-Simonis Lyle · Girdwood, AKBuilt 1955 · S/N 31744N3BCBenedict Larry · Dexter, NMBuilt 1956 · S/N 33947N3BDCopley Johnnie H · Minooka, ILBuilt 1979 · S/N 18267206N3BYJamora Daniel L · Victorville, CABuilt 1969 · S/N 17257965N3CHElliott Frank F · Mojave, CABuilt 1970 · S/N 33701282N3CLWehner Kaitlyn M · Malone, WIBuilt 1968 · S/N 17257531N3CMOxbow Investments LLC · Sonora, CABuilt 1972 · S/N P337-0025N3CYSchultz Daniel A · Tipp City, OHBuilt 1972 · S/N P3370022N3DWWhite Robert D Trustee · Colorado Springs, COBuilt 1973 · S/N 18262003N3DZXtreme Flying Club LLC · Gansevoort, NYS/N 33534N3EHHoppe Nicholas J · Big Lake, AKBuilt 1961 · S/N 18051020N3EM3em LLC · Karnack, TXBuilt 1981 · S/N P21000722N3FRValiair Limited Company Trustee · Casper, WYS/N R172-0237N3GXSearle Kenneth · Bigfork, MTS/N R18200979N3HLLamarr Ryan A · Greenview, CABuilt 1957 · S/N 29935N3HQChesapeake Searey LLC · Wilmington, DES/N 17269154N3JARegistered aircraftBuilt 1975 · S/N 17266528N3JNGas Aviation LLC · Decatur, TNBuilt 1966 · S/N 337-0558N3JPMcbride Scott · Lake Havasu City, AZBuilt 1978 · S/N 18266230N3JTMcdannel Albert M · Laporte, INS/N 15070621N3JXDunbar Marc L Trustee · Rocklin, CABuilt 1952 · S/N 25248N3KKKraussman Daniel J · San Antonio, TXBuilt 1978 · S/N 21062752N3KPAllied Asset Management LLC · Oklahoma City, OKBuilt 1981 · S/N P21000653N3KVAirmax Charters LLC · Lake Worth, FLBuilt 1981 · S/N 17274768
Back to AD 87-20-03 R2