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.

N4104UJennett Christopher S · New Port Richey, FLBuilt 1963 · S/N 15060104N4104VDavis Lawrence R · Kent, OHBuilt 1948 · S/N 18436N4105CJohnson Rodney R · Roseburg, ORS/N R18200322N4105YChock Steven Y H · Lopez Island, WABuilt 1962 · S/N 1850305N4106CAir Data Solutions LLC · Natchitoches, LABuilt 1978 · S/N R18200323N4106LHackens Bryan Jay · New Underwood, SDBuilt 1966 · S/N 17254175N4107BMullins Esten R · El Paso, TXBuilt 1976 · S/N 18264862N4107LRobitaille Charles · Stephenville, TXS/N 17254176N4107YJohnson Eric L Trustee · Valley, WABuilt 1962 · S/N 185-0307N4108LCriss Mark · Eaton Rapids, MIBuilt 1966 · S/N 17254177N4109LMarrian Jason · Westtown, NYBuilt 1966 · S/N 17254178N4109UFratangelo Robert A · Sodus, NYBuilt 1963 · S/N 15060109N410ABBloxsom Allan P III · Boerne, TXBuilt 1979 · S/N P21000352N410ADCon Air LLC · Okeana, OHBuilt 1975 · S/N 18263881N410CEBurggraf Sean Hj · Grand Rapids, MNS/N 18052477N410DWWest Earl W · Canton, TXS/N 26872N410EKGandy Donald T · Weatherford, TXBuilt 1976 · S/N 17702536N410FRRegistration Pending · Pottstown, PARegistration pendingBuilt 1982 · S/N 17275212N410MJSnuggs Jason M · Gainesville, TXBuilt 1969 · S/N 18259784N410PKEnergy And Environment LLC · Fayette, MES/N 18503358N410RFFeldtman Robert W · Buckholts, TXBuilt 1974 · S/N 18263478N410SEConner Gary Dean · Cypress, TXS/N R18200564N4110LNeu Aviation LLC · Benton, LABuilt 1966 · S/N 17254179N4110UKrul Donald · Center Line, MIBuilt 1963 · S/N 15060110N4111FRoss Karen F · Marion, TXBuilt 1958 · S/N 46011N4111UKenner Matthew T · Big Canoe, GABuilt 1963 · S/N 15060111N4111VJohnston Daniel T · Cambridge, OHBuilt 1948 · S/N 18443N4112FWard Leigh C · Garden Valley, IDBuilt 1958 · S/N 46012N4112VButterfield Colin · Wellesley, MABuilt 1948 · S/N 18444N41130Chapa Jana K · Corpus Christi, TXS/N 18255794N41139Blair Mark Winston · Zachary, LAS/N R18200889N4113VHare Charles W · Leaf River, ILS/N 18445N4114LLarson Lynn R · Casselton, NDBuilt 1966 · S/N 17254183N4114UPelan Lynn · Oakland, NEBuilt 1963 · S/N 15060114N4115CHails Betsy B · Montgomery, ALBuilt 1978 · S/N R18200325N4115FHogan Darrel R · Ash Grove, MOBuilt 1972 · S/N 15074003N4115LPierce Michael W · Leitchfield, KYBuilt 1966 · S/N 17254184N4115UMoore David A · Winchester, TNBuilt 1963 · S/N 15060115N4116LHubbard Matt · Phoenix, AZBuilt 1966 · S/N 17254185N4117LPatrick Milan Jr · Shinnston, WVBuilt 1966 · S/N 17254186N4118FMountain Air Spray Co Inc · Craig, COS/N 46018N4118LUan Venture Partners LLC · Odessa, FLBuilt 1966 · S/N 17254187N4118UZaner Don D · Osceola, MOBuilt 1963 · S/N 15060118N4119FPlymate Claude L · Tehachapi, CABuilt 1958 · S/N 46019N4119LSugar Aircraft LLC · Oak Harbor, WAS/N 17254188N4119UWeeks Nathaniel J · Sartell, MNBuilt 1963 · S/N 15060119N411AArnold Aviation & Thunder Mountain Express Inc · Cascade, IDBuilt 1979 · S/N 18503748N411BPAbove All Aviation Inc · Santa Barbara, CABuilt 1977 · S/N 18266177N411DKSwaz Aviation LLC · Mesa, AZS/N 17260703N411KMRowe Kieth C · Big Bear Lake, CABuilt 1963 · S/N 18255034
Back to AD 87-20-03 R2