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.

N8732UHumke John D · Eufaula, OKS/N 17252636N8732XHangar 2 Air LLC · Fort Collins, COBuilt 1960 · S/N 18253132N8732ZZiprik Russell L · Ball Ground, GABuilt 1968 · S/N P206-0532N8733XLaw Offices Of Brent M Ferrel LLC · Albuquerque, NMBuilt 1961 · S/N 18253133N8733ZTerway William · Wilsonville, ORBuilt 1968 · S/N P206-0533N8734TSkimt Aviation LLC · Teaneck, NJBuilt 1960 · S/N 52634N8734UGrow Aviation LLC · Aurora, NEBuilt 1965 · S/N 17252638N8734ZHardin Matthew W · Rutherford, CABuilt 1968 · S/N P206-0534N8735UJkh Aviation LLC · Cumming, GABuilt 1965 · S/N 17252639N8735ZMcgarity Justin D · Paragould, ARBuilt 1968 · S/N P206-0535N8736BCampbell Jack G · Spring Valley, WIBuilt 1957 · S/N 36436N8736GSantana Amaury · Winter Haven, FLBuilt 1966 · S/N 15062836N8736QCourtney Aviation LLC · Columbia, CABuilt 1976 · S/N U20603489N8736UC & M Aviation Holdings LLC · Brockport, NYBuilt 1965 · S/N 17252640N8736XBoggio Richard E · Bradenville, PABuilt 1961 · S/N 18253136N8737BFranklin Rodney S · Burns, ORBuilt 1957 · S/N 36437N8737TSchmitt Gary W · Highlands, NCBuilt 1960 · S/N 52637N8737UMiss Lou Flight LLC · Vidalia, LABuilt 1965 · S/N 17252641N8738URhk Of Kansas · Jefferson City, MOBuilt 1976 · S/N 15077977N8739GKlott William D · Morris, ILBuilt 1966 · S/N 15062839N8739TScranton Brian J · Ridgway, COBuilt 1960 · S/N 52639N8739UAndrews Willard R · Windham, MEBuilt 1965 · S/N 17252643N873TWN873tw LLC · Hurricane, WVS/N 17273301N8740BOltrogge Construction Inc · Absarokee, MTBuilt 1957 · S/N 36440N8740QHampton Harvey E · Simms, MTS/N U20603493N8740SBucks Flight Academy LLC · Cashion, OKS/N 15062040N8740XUnwrapped LLC · Dover, DES/N 18253140N8741BPhoenix Air Inc · Orland Park, ILBuilt 1957 · S/N 36441N8741GDahlberg James C · Ogilvie, MNS/N 15062841N8741SJohnson Zachary R · Burien, WABuilt 1965 · S/N 15062041N8741TTolman Jeremy Charles · Mcalester, OKBuilt 1960 · S/N 52641N8741USexton Mathew G · Rockwell City, IABuilt 1965 · S/N 17252645N8742BTexas Wings LLC · San Antonio, TXBuilt 1957 · S/N 36442N8742GReeve Howard E · Minot, NDS/N 15062842N8742UJennings Jeff L · Kenly, NCS/N 17252646N8742XGarletts Frank A · Jackson, MSBuilt 1960 · S/N 18253142N8744SZiegler Jeffery A · Crescent Springs, KYBuilt 1965 · S/N 15062044N8744TEdhlund Joseph W · Brush Prairie, WAS/N 52644N8745GWildcat Aviation LLC · Schoolcraft, MIBuilt 1966 · S/N 15062845N8745XScott William R · Monroe, GABuilt 1961 · S/N 18253145N8746BHeffron Jacob L · Little Falls, MNBuilt 1957 · S/N 36446N8746XBlack Kevin R · Massillon, OHBuilt 1961 · S/N 18253146N8747SEast County Communications Inc · Hurricane, UTBuilt 1965 · S/N 15062047N8747URegistration Pending · Indio, CARegistration pendingBuilt 1976 · S/N 15077978N8747XJodoin Michael G · Belton, SCBuilt 1960 · S/N 18253147N8747ZMermaid Marine LLC · Auburn, WAS/N 18502906N8748BOstby Larry · Froid, MTBuilt 1957 · S/N 36448N8748SJones Joel K · Summer Shade, KYBuilt 1965 · S/N 15062048N8748TDennis Richard E · Gakona, AKBuilt 1960 · S/N 52648N8749SHart Richard G · Stoneham, MABuilt 1965 · S/N 15062049
Back to AD 87-20-03 R2