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.

N4140VDirigo Aerospace Solutions LLC · Sumner, MEBuilt 1948 · S/N 18472N4141LPeder Richard A · Sequim, WABuilt 1966 · S/N 17254210N4142LSegura Michelle Marie · Dallas, TXBuilt 1966 · S/N 17254211N4143FSteier Tim A · Salome, AZBuilt 1958 · S/N 46043N4143VRegistered aircraftBuilt 1948 · S/N 18475N4144FKoch Gerald P · Mount Vernon, SDBuilt 1958 · S/N 46044N4144URinaudo James J · Gulf Shores, ALBuilt 1963 · S/N 15060144N4144VLadage Terry L · Champaign, ILBuilt 1948 · S/N 18622N4145Dittlinger Bret W · Anchorage, AKBuilt 1957 · S/N 32840N4145USt Peter John P · Hicksville, OHBuilt 1963 · S/N 15060145N4146FGompert Andrew B · Burwell, NEBuilt 1958 · S/N 46046N4146UKobza Leslie J · White Bear Lake, MNBuilt 1963 · S/N 15060146N4147FSwan Steve · Jackson, WYBuilt 1958 · S/N 46047N4147UEast Tennessee Pilots Club Inc · Knoxville, TNBuilt 1963 · S/N 15060147N4148CMjolhus Knut G · Amarillo, TXBuilt 1978 · S/N R18200329N4148FBorders Jimmie L · Tompkinsville, KYBuilt 1958 · S/N 46048N4149FCarruth Peter J · Benson, MNS/N 46049N4149LRegistration Pending · Bryan, OHRegistration pendingS/N 17254218N4149UMinard Nicholas R · Chandler, AZS/N 15060149N4149VBush Brett C · Cody, WYBuilt 1948 · S/N 18481N414EDDavis Gabriel L · Dillingham, AKBuilt 1971 · S/N 18501838N414FHSewell Stephen A · Navasota, TXBuilt 1980 · S/N R18201639N414KFDilworth Andrew R DBA · Los Gatos, CABuilt 1980 · S/N 180-53147N414SCPaul Sachitano LLC · Beaumont, TXBuilt 1978 · S/N 18266352N414WDDonaldson Ted M · Thatcher, AZBuilt 1956 · S/N 33654N4150FRegistration Pending · Clinton Township, MIRegistration pendingS/N 46050N4150LBlankenship Daniel S · Paso Robles, CABuilt 1966 · S/N 17254219N4150ULong Sarah Louise · Fort Wayne, INS/N 15060150N4150VDorsey Christopher · Round Rock, TXBuilt 1948 · S/N 18482N4151LPardun Phillip R · Mason City, IABuilt 1966 · S/N 17254220N4151UHuskey Ryan J · Edmond, OKS/N 15060151N4151VRisner Rick · Vernon, TXS/N 18483N4152FGaertner Kim L · Oconto, WIBuilt 1958 · S/N 46052N4152LLambert Robert · Paoli, INBuilt 1966 · S/N 17254221N4152VBrewer Samuel T · Wasilla, AKS/N 18484N4153CJet Care Corp · Roseville, CAS/N R18200330N4153FChaffee Craig O · Le Raysville, PABuilt 1958 · S/N 46053N4153VBenoit Bob W · Hot Springs, ARBuilt 1963 · S/N 18485N4154DBriggs John M · Vancouver, WABuilt 1951 · S/N 20037N4154VWindsock Capital LLC · Bertram, TXS/N 18486N4154YMehling Robert C · Hardin, MTS/N 185-0354N4155VBeavert Curt E · Murfreesboro, ARBuilt 1948 · S/N 18487N4156FPintar Robert · Spokane, WAS/N 46056N4156LZimmer Marc R · Moses Lake, WABuilt 1966 · S/N 17254225N4157FBeasley John V III · Amarillo, TXS/N 46057N4157VMoran Charles L Jr · Fresno, CABuilt 1948 · S/N 18489N4158FKraft Dean B · Mapleton, NDBuilt 1958 · S/N 46058N4159LGrassetti Raymond J · Monson, MABuilt 1966 · S/N 17254228N4159UTodhunter John S · Hemet, CABuilt 1963 · S/N 15060159N415SVPoytress Earl F Jr · Montrose, COBuilt 1969 · S/N 337-1135
Back to AD 87-20-03 R2