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.

N6624HSakata Lissa C · Falls Church, VAS/N 17265515N6624YGay Don A · Garfield, GABuilt 1972 · S/N 15072675N66254Beachy Matthew F · Russellville, KYBuilt 1974 · S/N 15075957N6625FManos Norman A · Omaha, NEBuilt 1966 · S/N 15063225N6625NRogers Charles W Trustee · Newbury Park, CABuilt 1978 · S/N 21063126N6625XBothell Eric L · Center, COS/N 21057625N66260Schile James · Janesville, MNS/N 15075962N66261Gregor John P · Allentown, NJBuilt 1974 · S/N 15075963N66266Cleveland Monica L · Penn Yan, NYBuilt 1977 · S/N 18052932N66268Rahden Tiffany · Bellevue, WABuilt 1974 · S/N 15075967N6626AKrystofiak Steven · Scottsdale, AZS/N 28726N6626FByler Joseph C · Spartansburg, PABuilt 1966 · S/N 15063226N6626SFast Aircraft Aerowork Corp · Miami, FLBuilt 1967 · S/N 15067426N66271Registration Pending · Waverly, IARegistration pendingBuilt 1974 · S/N 15075969N66273Delgadillo Jose M · League City, TXBuilt 1974 · S/N 15075970N66277Mcclure Wayne R · Anchorage, AKBuilt 1974 · S/N 15075972N6627AMcgowan Dan J · Springville, CABuilt 1956 · S/N 28727N6627FLeading Phase LLC · Ham Lake, MNS/N 15063227N6627GBelov Konstantin V · Sierra Madre, CABuilt 1970 · S/N 15072127N6627MWojciak Alan J · Colorado Springs, COBuilt 1975 · S/N 18263785N6627TWalkup Justin · Corpus Christi, TXBuilt 1960 · S/N 15059027N66281Alaska Sky School LLC · Anchorage, AKBuilt 1974 · S/N 15075974N66289Brine William H · Edgartown, MAS/N 18052934N6628AJohnson Steve D · Oklahoma City, OKFirst renewal noticeS/N 28728N6628SN6628s LLC · Arlington, TXBuilt 1967 · S/N 15067428N6629TSimpson Eric J · Salome, AZBuilt 1960 · S/N 15059029N662BDMetcalf Charles M · Thomaston, GABuilt 1966 · S/N 15063664N662HRRaymond Thomas D · Somerset, TXS/N 28725N662KC216 Skymaster Series LLC · Keller, TXS/N P3370216N662SHRay Lonnie D · Murfreesboro, TNBuilt 1962 · S/N 15059641N6630SRoss Air Chicago LLC · Chicago, ILBuilt 1967 · S/N 15067430N66314Tan Cfi LLC · Plano, TXS/N 15075983N6631AUnternaehrer Robert U Trustee · Brunswick, MOBuilt 1956 · S/N 28731N6631EArmstrong Bruce · Port Orchard, WABuilt 1959 · S/N 56131N6631GRegistration Pending · Oak Creek, WIRegistration pendingBuilt 1970 · S/N 15072131N6631MMinuteman Aviation Inc · Missoula, MTBuilt 1975 · S/N 18263786N6631THaas David P · Bixby, OKBuilt 1960 · S/N 15059031N6631XPelland John J · Antioch, ILBuilt 1961 · S/N 21057631N66321Swenson Donald C · Stanchfield, MNBuilt 1977 · S/N 18052935N66322Barker Michael S · Stanford, KYS/N 15075986N6632A3 Fly-N LLC · Carlisle, KYBuilt 1956 · S/N 28732N66333Registration Pending · Cooksville, MDRegistration pendingBuilt 1974 · S/N 15075988N6633AKolp Mark H · Andrews, TXFirst renewal noticeBuilt 1956 · S/N 28733N6633SRegistered aircraftBuilt 1967 · S/N 15067433N66349Kecy Kevin · Owls Head, MEBuilt 1974 · S/N 15075990N6634AKallabis Harry · Camino, CABuilt 1956 · S/N 28734N6634EWinkles Ron M · Ardmore, OKBuilt 1959 · S/N 56134N6634PAviation-Avsec Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1978 · S/N P21000194N6634TBensaida Said · Hawarden, IABuilt 1960 · S/N 15059034N6635ALewis John · Abbyville, KSBuilt 1956 · S/N 28735
Back to AD 87-20-03 R2