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.

N42314Mackenzie Jeffrey S · Woodland, MIBuilt 1968 · S/N 18258962N42317Meyers Brad C · Reno, TXBuilt 1968 · S/N 18258963N4231FYancey Emron A · Sterling, AKS/N 46131N4231LSeaplanes R Fun Inc · Moneta, VABuilt 1966 · S/N 17254300N42323Gardiner Russell J · Phoenix, AZS/N 18258965N42325Henry Nolan T · Ashland, ORS/N 18258967N42326Hooper James Carl · Webster, MNBuilt 1968 · S/N 18258968N42328High Tony W · Walters, OKBuilt 1968 · S/N 18258969N4232QRamstad Trygg J · Anchorage, AKS/N 18502227N4232USterling John A · Port Lavaca, TXS/N 150-60232N4232VBishop John · Annapolis, MDBuilt 1948 · S/N 18588N42335Gubernat John F Jr · Pepperell, MABuilt 1968 · S/N 18258971N4233FSilverman James R · Superior, MTS/N 46133N4233LTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1966 · S/N 17254302N4233QWoods John B · Anchorage, AKBuilt 1971 · S/N 17260133N42349Skylane 49 LLC · Glenwood Springs, COBuilt 1968 · S/N 18258976N4234NHain Bruce P · Kennesaw, GAS/N 26263N4234QFarr Everett L III · Bensalem, PABuilt 1971 · S/N 17260134N4234UWasson Tina A · Lakeport, CABuilt 1964 · S/N 15060234N42359Lincoln Roger Trustee · Gildford, MTBuilt 1973 · S/N 18052343N4235FCastle Nial K III · Bonner Springs, KSBuilt 1958 · S/N 46135N4235LReiter Trevor D · Minot, NDBuilt 1966 · S/N 17254304N4235UCottrell Mark C · Leitchfield, KYBuilt 1963 · S/N 15060235N42361Lima 001 LLC · Muscatine, IABuilt 1974 · S/N 17264171N42364Smathers Geoffrey R · Mars, PABuilt 1968 · S/N 18258986N42368Madson Chris J · King City, CABuilt 1968 · S/N 18258988N42369Hecker Darin · Grants Pass, ORBuilt 1968 · S/N 18258989N4236LPierce Russell A · San Antonio, TXBuilt 1966 · S/N 17254305N4236QTyrrell Jerry R · Woodland, WABuilt 1973 · S/N 18502228N4236VSpitler John E · Laramie, WYBuilt 1948 · S/N 18592N42371Optum Sun LLC · Laguna Hills, CAS/N 18258990N42376Johnson Lytle D · Anacortes, WABuilt 1973 · S/N 18052348N42379Wh Land Holdings LLC · Kirbyville, TXBuilt 1968 · S/N 18258996N4237FScherr Steven J · Mandan, NDBuilt 1958 · S/N 46137N4237UMark & Debbe Inc DBA · Kalispell, MTS/N 15060237N42380Payne Patricia C · Spokane, WABuilt 1968 · S/N 18258997N42381Anthony David W · Wasilla, AKFirst renewal noticeS/N 18258998N42382Nb Services LLC · Sumrall, MSBuilt 1968 · S/N 18258999N42387Bernau Jeff A · Kalispell, MTS/N 18259000N4238QFisch Markus J · Rock Falls, ILBuilt 1971 · S/N 17260138N4238VHamann David L · Los Lunas, NMBuilt 1948 · S/N 18594N42397Brissey Forrest L · Woodinville, WABuilt 1968 · S/N 18259003N4239FDitmars William R · Redding, CABuilt 1958 · S/N 46139N4239QElizabeth City State University · Elizabeth City, NCS/N 17260139N4239UStowell Thomas W · Gainesville, GABuilt 1963 · S/N 15060239N423DKOliveira Avelino Da Mota · Aventura, FLBuilt 1981 · S/N R18201809N423LL79bravo Leasing LLC · Lincoln, DEBuilt 1975 · S/N 18264071N423RHHunt Robert H · Taylorsville, MSBuilt 1971 · S/N 33701420N424Ross Michael J · Los Angeles, CABuilt 1976 · S/N P3370259N42400Smith Randolph L · Orovada, NVBuilt 1968 · S/N 18259004
Back to AD 87-20-03 R2