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.

N70000Carson Mark L Trustee · Northfield, MNBuilt 1976 · S/N 17267178N70004Gbl Aviation LLC · Laurel, MSBuilt 1976 · S/N 17267179N70006Colorado Red LLC · Dillon, COBuilt 1971 · S/N 18501886N7000AHaley Michael R · Hobbs, NMFirst renewal noticeBuilt 1956 · S/N 29100N7000ESchweitzer Mark A · Susanville, CABuilt 1960 · S/N 56500N7000KCohen Phillip A · Hopkinton, MABuilt 1978 · S/N 210-62553N7000LHalstead Michael J · Gresham, ORBuilt 1975 · S/N U20602907N7000MWht LLC · Noonan, NDBuilt 1958 · S/N 55300N7000TCarter Jared · Lebanon, TNBuilt 1959 · S/N 46600N7001ALkp Aviation LLC · Montgomery, INS/N 29101N7001EMaupertuis Philippe F · Winchester, CABuilt 1960 · S/N 56501N7001GWhite Richard L · Pittsburgh, PABuilt 1973 · S/N 15074601N7001MRush Michael J · Nashua, NHBuilt 1958 · S/N 55301N7001XMoore Aviation Service LLC · Selma, ALS/N 15059101N70022Linford Robert M · Spokane, WABuilt 1971 · S/N 18501897N70026Stephens Brandon J · North Pole, AKBuilt 1971 · S/N 18501901N7002AAustin James M · Fort Worth, TXBuilt 1956 · S/N 29102N7002EHickle William H · Inyokern, CABuilt 1960 · S/N 56502N7002FMcdonald Timothy M · Meredith, NHBuilt 1966 · S/N 15063602N7002MApte John W · Biddeford, MEBuilt 1958 · S/N 55302N70032Alpha Wings Inc · Willoughby, OHBuilt 1976 · S/N 17267180N70037Bancroft Contracting Corporation · South Paris, MEBuilt 1971 · S/N 18501905N7003AHuang Sophie M · Newcastle, WABuilt 1956 · S/N 29103N7003EIndy Air Sales LLC · Anderson, INBuilt 1960 · S/N 56503N7003KSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 18259923N70046Zane Newton F · Rllng Hls Est, CAS/N 17267183N70048Trident Resources LLC · Chino Valley, AZS/N 18501917N7004AMitchell Mark A · Pittsford, NYBuilt 1956 · S/N 29104N7004EBoughan Patrick W · Vail, COBuilt 1960 · S/N 56504N7004GMcgreen John R · Albany, NYBuilt 1969 · S/N 17258704N70052Hastings Heidi · Wasilla, AKBuilt 1976 · S/N 17267185N7005AStansell Clayton H · Los Lunas, NMBuilt 1956 · S/N 29105N7005FUS Flight Academy International Inc DBA · Post, TXBuilt 1966 · S/N 15063605N7005GHamilton Peter D · Bear, DEBuilt 1969 · S/N 17258705N7005QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1971 · S/N 17260305N7005TSmith Roy B · Newland, NCBuilt 1959 · S/N 46605N70063Welch Thomas R DBA · Modesto, CABuilt 1974 · S/N 18801827TN7006AFletcher John G · Diamondhead, MSBuilt 1956 · S/N 29106N7006ELienke Kevin E · Beaver Dam, WIBuilt 1960 · S/N 56506N7006QToney Edward L · Hampton, GABuilt 1971 · S/N 17260306N7006SSpicer Greg · Portage, MIBuilt 1967 · S/N 15067706N7006TFraas Stephan H · Meriden, CTBuilt 1959 · S/N 46606N70070Bay Air Inc · Dillingham, AKBuilt 1971 · S/N 18501939N70071Bender Charles A Jr · Orrstown, PABuilt 1971 · S/N 18501940N7007MDouble 07 Mike Flyers Inc · Kalispell, MTBuilt 1958 · S/N 55307N7007SJw Air Ventures LLC · New Smyrna Beach, FLBuilt 1967 · S/N 15067707N70083Air Pacific LLC · Port Angeles, WABuilt 1971 · S/N 18501950N70084Bridges Pamela J · Calais, MES/N 18501951N70085Embley Kenneth · Anchorage, AKS/N 18501952N7008AMitchell Shawn J · Red Bluff, CAS/N 29108
Back to AD 87-20-03 R2