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.

N8628ZSaddler Susan J · Dayton, OHBuilt 1967 · S/N P206-0428N8629TWoodworth Mark P · Golden, COBuilt 1960 · S/N 52529N8629UHedberg Paul D · Atwater, MNBuilt 1965 · S/N 17252530N862CBFolk Tom M · Puyallup, WABuilt 1963 · S/N 205-0254N862TWTailwinds LLC · Ewing, NJBuilt 1978 · S/N 17271025N862WBWings Of Blessing · Ft Worth, TXS/N 18502381N86303Van Dootingh Jeffrey A · Middle Bass, OHBuilt 1969 · S/N 337-1147N863062fly-Safety LLC Trustee · Azle, TXBuilt 1969 · S/N 337-1148N8630GGoehring Melissa S · Grand Rapids, MIBuilt 1965 · S/N 15062730N8630JDean M O · Corpus Christi, TXBuilt 1967 · S/N 15066530N8630THensley Steven Lee Jr Trustee · Scappoose, ORBuilt 1960 · S/N 52530N8630UOcala Aviation Services Inc · Ocala, FLBuilt 1965 · S/N 17252531N8630ZAlaska Village Missions · Homer, AKBuilt 1967 · S/N P206-0430N8631JKing Boyd F · Okmulgee, OKBuilt 1967 · S/N 15066531N8631SSteiger Marley C · Glenham, SDBuilt 1965 · S/N 15061931N8632GChappell Stephen · Wilmington, NCBuilt 1966 · S/N 15062732N8632TLucky Resin Works LLC · Bend, ORBuilt 1960 · S/N 52532N8632ZTate Roger · Redlands, CAS/N P206-0432N8633BPrigmore Phillip M · Alva, OKBuilt 1957 · S/N 36333N8633JHise Mark J · Nolensville, TNBuilt 1967 · S/N 15066533N8633SUhler John A · Rimrock, AZBuilt 1965 · S/N 15061933N8634GRegistration Pending · Princeton, MARegistration pendingBuilt 1966 · S/N 15062734N8634JDestination 55 LLC · Cave Springs, ARBuilt 1967 · S/N 15066534N8634SHersom Jeffrey T · Helena, MTBuilt 1965 · S/N 15061934N8634UTango Thirty One Aero Clube Inc · Mckinney, TXBuilt 1975 · S/N 15077246N86354White Billy C · Crestview, FLBuilt 1973 · S/N 18261928N8635BShafik Mohammed · Las Vegas, NVS/N 36335N8635GSmith Andrew W · Willow, AKBuilt 1965 · S/N 15062735N8635SWood Timothy M · Jefferson, MES/N 15061935N8635UTango Thirty One Aero Clube Inc · Mckinney, TXBuilt 1976 · S/N 15077965N8635ZLipper Stephen W · Griffin, GAFirst renewal noticeBuilt 1967 · S/N P206-0435N8636BFisher'S Crop Care By Air LLC · Fredericktown, OHS/N 36336N8636UMls Holdings · Newbury Park, CABuilt 1965 · S/N 17252538N8637GReichenbach Louis · Northville, MIBuilt 1966 · S/N 15062737N8637THundo Air LLC · Kalispell, MTBuilt 1960 · S/N 52537N86383Euro Aviation Inc · KematenBuilt 1969 · S/N 337-1169N8638SLyon Ronald C · Berlin, VTBuilt 1965 · S/N 15061938N8638ULittle Kenneth C · Driggs, IDBuilt 1965 · S/N 17252540N8638ZEichman David A · Topeka, KSBuilt 1967 · S/N P206-0438N86395Maley Adam W · Shinnston, WVBuilt 1969 · S/N 337-1171N8639GRegistered aircraftBuilt 1966 · S/N 15062739N863GWWellington Gregory D · Parkman, MEBuilt 1969 · S/N 185-1454N863TAKeating Scott G · Ormond Beach, FLBuilt 1985 · S/N 15286026N863WBWings Of Blessing · Fort Worth, TXS/N 18502624N86407Donalds Flying Service Inc · Pantego, NCBuilt 1975 · S/N 18802013TN8640GRoss Peter W · Lufkin, TXBuilt 1965 · S/N 15062740N8640TSkydive Florida Keys Inc · Summerland Key, FLBuilt 1960 · S/N 52540N8640USunnyside Aviation Pllc · Theodosia, MOBuilt 1965 · S/N 17252542N86417Joseph John P II · Willis, TXBuilt 1969 · S/N 337-1181N8641SSimmons Anthony C Jr · Allendale, SCBuilt 1965 · S/N 15061941
Back to AD 87-20-03 R2