OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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.

N8554TDrake Robin G · Loganville, GABuilt 1959 · S/N 52454N8554UWorkman David A · Putnam, ILBuilt 1965 · S/N 17252454N8555BThompson Greg M · Rigby, IDBuilt 1957 · S/N 36255N8555JBauer Walter G · Neenah, WIBuilt 1967 · S/N 15066455N8555SBray Harvey G · Reidsville, NCBuilt 1965 · S/N 18256655N8555ULeaf Sport LLC · Henning, MNBuilt 1965 · S/N 17252455N8556BKendig Dustin Zarah · Portland, ORBuilt 1957 · S/N 36256N8556SRoyalty Marshall E · Seymour, INBuilt 1965 · S/N 18256656N8557GDoddi Vikram · Austin, TXBuilt 1965 · S/N 15062657N8557JRobertson Billy J Trustee · Cleveland, OKBuilt 1967 · S/N 15066457N8557SLittle River Aviation LLC · Tifton, GABuilt 1965 · S/N 18256657N8557UOconnor Jonathan D · East Aurora, NYS/N 17252457N8557XChauhan Jay S · Oakland, CABuilt 1962 · S/N P17257157N8558BWilliams Ralph J · Essex Junction, VTBuilt 1957 · S/N 36258N8558UNelson David R · Stanwood, WABuilt 1965 · S/N 17252458N8559GAeronautical Technical Service Inc · Collierville, TNS/N 15062659N8559SHanson Robert J · Renton, WABuilt 1965 · S/N 18256659N8559TNorstegaard Mark A · Sturgis, SDBuilt 1959 · S/N 52459N855JWButterfield Rory A · Milan, NMS/N 15071147N855PMSchroeder David W · Brutus, MIS/N 18051722N855SPKirschner Joel D · Clarkesville, GABuilt 1981 · S/N R18201792N855TWMapes Peter B · Oscoda, MIS/N 15065657N8560QLunati Ralph · Mc Alpin, FLBuilt 1976 · S/N U20603416N8560TMcmaster John DBA · Wichita, KSS/N 52460N8561GFox Harvey · Lititz, PABuilt 1965 · S/N 15062661N8561TScriver Cody M · Vashon, WABuilt 1959 · S/N 52461N8561USmith Michael V · Fort Myers, FLBuilt 1964 · S/N 17252461N8561XJ & K Flying LLC · Marengo, OHBuilt 1962 · S/N P17257161N8562TBacksen Rick L · Clarkston, WABuilt 1959 · S/N 52462N8562UMall Craig S · Dingmans Ferry, PABuilt 1965 · S/N 17252462N8563JTschepen Leo R · Bisbee, NDBuilt 1967 · S/N 15066463N8563UCanupp Joseph J · Clinton, SCBuilt 1964 · S/N 17252463N8564BKarpe Kendall K · Plymouth, MNBuilt 1957 · S/N 36264N8564QEnvii Aviation LLC · Monroe, WABuilt 1976 · S/N U20603420N8564TSpeer Gary L · Knoxville, TNBuilt 1959 · S/N 52464N8565BQuill James M · Granby, MABuilt 1957 · S/N 36265N8565GFreedom Flight Service LLC · Glendale, AZBuilt 1965 · S/N 15062665N8565THarris Spraying Inc · Circle, MTBuilt 1959 · S/N 52465N8566GEluwawalage Damayanthie · Reading, PABuilt 1966 · S/N 15062666N8566SVon Borstel Alan W · Grass Valley, ORBuilt 1965 · S/N 18256666N8566TWiggins Jeffrey W · Norwood, NCBuilt 1959 · S/N 52466N8567UPfeiffer Rebecca M · Independence, MNBuilt 1964 · S/N 17252467N8568GSkeen Harry K · Philippi, WVBuilt 1966 · S/N 15062668N8568QSkyhawk Aero LLC · Montevideo, MNBuilt 1967 · S/N 17255780N8569BSpraches Edward J · Franklin, NCS/N 36269N856DASpanaflight LLC · Puyallup, WABuilt 1980 · S/N 15284377N856DRSchreiber Ryan S · Winter Garden, FLBuilt 1955 · S/N 26739N8570BPilot Coaches LLC · Little Falls, MNS/N 36270N8570GGreenville Pilots Association Eaa Chapter 1382 · Greenville, ILS/N 15062670N8570JBitikofer Brent · Kansas City, KSS/N 15066470
Back to AD 87-20-03 R2