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.

N8154FWilson Gary L · Levant, MES/N 15064254N8154UPodgorski James E · Walworth, WIBuilt 1964 · S/N 17252054N8154ZTurner Company LLC · Hearne, TXBuilt 1962 · S/N 205-0154N8155BBrockman Charles · Bend, ORBuilt 1957 · S/N 29955N8155FJapundza Bob · Kokomo, INBuilt 1966 · S/N 15064255N8155SSale Reported · Cherry Valley, CASale reportedS/N 15061755N8155TChristen Richard P · Bend, ORS/N 17556855N8155UShearer Ronald L · Quincy, INBuilt 1964 · S/N 17252055N8156AReetz Duane W · Clintonville, WIBuilt 1952 · S/N 25008N8156FKindlon Aviation Inc · Glenmont, NYBuilt 1966 · S/N 15064256N8156SPyanov Mark · Clinton, MSS/N 15061756N8156XGoebel William · Rhome, TXBuilt 1961 · S/N 17248656N8157ARidge Bryan T Trustee · San Diego, CABuilt 1952 · S/N 25009N8157BLipskoch Anthony P · Buhl, IDS/N 29957N8157LWinfrey Walter A Trustee · Auburn, CAS/N 17256357N8157SAntal Frank Jr · Delta, COBuilt 1965 · S/N 15061757N8157UQuarter To Two Flying Club Inc · Williamsport, PABuilt 1964 · S/N 17252057N8157VReady Aim Flyer LLC · New Castle, DEBuilt 1968 · S/N 188-0407N8157XRiverside Flight Academy LLC · Riverside, CAS/N 17248657N8158LBockman Peter Jr · Anchorage, AKS/N 17256358N8159MHowell Andrew · Pinedale, WYS/N 21062032N8159XClydesdale Aviation LLC · Goodwater, ALS/N 17248659N815GKN114jr LLC · Parrish, FLBuilt 1973 · S/N 18262599N815VNordic Air LLC · Petersburg, AKBuilt 1973 · S/N 18502331N8160FRydell Leonard A · Newberg, ORBuilt 1966 · S/N 15064260N8160LGarcia Geoff M · Tecumseh, OKBuilt 1967 · S/N 17256360N8160TWhite Orion H · Moses Lake, WABuilt 1960 · S/N 17556860N8161ABuck Robert O · Waterbury Center, VTFirst renewal noticeBuilt 1952 · S/N 25013N8161BFehrenbach Chris A · Evansville, INBuilt 1957 · S/N 29961N8161LNexten Flight Academy · Riverside, CABuilt 1967 · S/N 17256361N8161UKaiser James · Fond Du Lac, WIBuilt 1964 · S/N 17252061N8162BMountain Air LLC · Carabaset Vly, MEBuilt 1957 · S/N 29962N8162FWeishuhn Charlie D · La Grange, TXBuilt 1966 · S/N 15064262N8162MMeggers Darin R · Baker, MTBuilt 1972 · S/N 15073212N8162ULunger Eric K · Mifflintown, PABuilt 1964 · S/N 17252062N81631Kelly Jon B · Anchorage, AKBuilt 1981 · S/N U20606371N8163ABarker Donna J · Connersville, INS/N 25015N8163BAerosim Inc · Stockton, CABuilt 1957 · S/N 29963N8163UCave Mark A · Snyder, TXBuilt 1964 · S/N 17252063N8164ASpurlock Daniel C · Harrogate, TNBuilt 1952 · S/N 25016N8164LBowtie Properties LLC · Dadeville, ALBuilt 1967 · S/N 17256364N8164TKent Larry A · Gaylord, MIS/N 17556864N8165BEvans David M · Superior, WIBuilt 1957 · S/N 29965N8165FMoat William A · Braselton, GAS/N 15064265N8165SDickey Jenni M · Willow, AKBuilt 1965 · S/N 15061765N8165TEubanks James D · Horn Lake, MSBuilt 1960 · S/N 17556865N8165UFena Daniel J · Side Lake, MNS/N 17252065N8165ZHenry Kenneth S Trustee · Kingman, AZBuilt 1962 · S/N 205-0165N8166FHassan Nabil Ibrahim · Victorville, CABuilt 1966 · S/N 15064266N8166LBlackerby Dennis N · Wilsonville, ALBuilt 1967 · S/N 17256366
Back to AD 87-20-03 R2