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.

N4361BFitts James A Jr · North Pole, AKBuilt 1955 · S/N 26705N4361LFairbault Sky Club Inc · Waseca, MNBuilt 1966 · S/N 17254436N4362BHernden Michael R · Rockford, ILBuilt 1955 · S/N 26706N4362QQuacker Holdings LLC · Aspen, COBuilt 1971 · S/N 17260262N4362RBruther Thomas J · Temecula, CABuilt 1974 · S/N 17263113N4363RSky Walker Flight School LLC · Adrian, MIBuilt 1974 · S/N 17263114N4364QStotts Boys Aviation LLC · Corcoran, MNBuilt 1973 · S/N 18502239N4365BMorris Steven Jacob · Wasilla, AKBuilt 1955 · S/N 26709N4365LPriem Ben · Linwood, MIBuilt 1966 · S/N 17254440N4365QJackson Rickey L · Edmond, OKBuilt 1971 · S/N 17260265N4365RCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1974 · S/N 17263116N4366BLittle Andrew P · Fairbanks, AKBuilt 1955 · S/N 26710N4366RHyland Mark R · Poland, MEBuilt 1974 · S/N 17263117N4366UScott Michael D · Chippewa Falls, WIBuilt 1964 · S/N 15060366N4366VKopf Edward H Jr · Las Vegas, NVBuilt 1948 · S/N 7281N4367NMajerle Joseph III · Anchorage, AKBuilt 1947 · S/N 7039N4367VGreulich Kenneth R Trustee · Sand Springs, OKBuilt 1948 · S/N 7282N4369BFlegel Brian E · Milton Freewater, ORBuilt 1955 · S/N 26713N436RMRocky Mountain College · Billings, MTBuilt 1979 · S/N 17273662N436SAClark Vernon · Olalla, WABuilt 1967 · S/N 15067549N437Sackett Scott H · Krum, TXBuilt 1952 · S/N 7930N4370LAir North Flying Club · Malone, NYBuilt 1966 · S/N 17254447N4370RSkar Paul R · Londonderry, NHBuilt 1974 · S/N 17263121N4370UNeal Gordon T · Massillon, OHBuilt 1964 · S/N 15060370N4371LPrisk Jack J · Pride, LABuilt 1966 · S/N 17254448N4371NCole David L · Granbury, TXBuilt 1947 · S/N 7035N4371UBarnett Gina L · Columbus, TXBuilt 1964 · S/N 15060371N4372RKennemer Farms Inc · Carter, OKBuilt 1978 · S/N R18200594N4373BZenishek Gary D Trustee · Jefferson City, MOBuilt 1955 · S/N 26717N4373LWilliams Matthew W · Fort Walton Beach, FLBuilt 1966 · S/N 17254450N4373NApple Jeffrey G · Sheridan, INBuilt 1947 · S/N 7033N4373RKlc Associates · Unionville, CTBuilt 1978 · S/N R18200595N4374QWillaero LLC · Union City, TNBuilt 1971 · S/N 17260274N4374VBrown Robert A · Peachtree City, GABuilt 1949 · S/N 7289N4375VPeck Nathan Mark · Leavenworth, KSBuilt 1949 · S/N 7320N4376QFranke Russel G · Silt, COS/N 17260276N4377BNatural Resources LLC · Arcadia, FLBuilt 1955 · S/N 26721N4377QStacey James · Exeter, MEBuilt 1971 · S/N 17260277N4377RDallas Aero & Sales LLC · Poplar, MTBuilt 1974 · S/N 17263127N4378LRegistration Pending · Wentzville, MORegistration pendingBuilt 1966 · S/N 17254457N4378QWings Flying Club Inc · South Bend, INBuilt 1971 · S/N 17260278N4378UWissenbach Richard G · Pinesdale, MTS/N 15060378N4379BNewell Kenneth L · Wichita, KSBuilt 1955 · S/N 26723N4379QHagaman Edward T · Tolland, CTBuilt 1971 · S/N 17260279N4379RSlipstream Aviation LLC · Calera, ALBuilt 1974 · S/N 17263129N437PHHolske Peter John · Dartmouth, MAS/N 17267933N4380BThorall Kenneth L · Chugiak, AKS/N 26724N4380NWarwick Dakota R · Jupiter, FLS/N 7026N4381BBuck William A · Waianae, HIBuilt 1955 · S/N 26725N4381QAero Wise Services LLC · Decatur, TXBuilt 1971 · S/N 17260281
Back to AD 87-20-03 R2