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.

N714HHPhelps Clay DBA · Santa Paula, CABuilt 1977 · S/N 15079185N714HKDent Kelly J · Locust Grove, GABuilt 1977 · S/N 15079187N714HLSlate Mitchell P · Colorado Springs, COBuilt 1977 · S/N 15079188N714HPTic Aerospace Inc · Miami, FLBuilt 1982 · S/N 172RG1123N714HRHendry Joshua R · Carthage, TNS/N 15079193N714HUSingh Paviter · Beavercreek, OHBuilt 1977 · S/N 15079196N714HVStrahan Sam · San Angelo, TXBuilt 1964 · S/N 15060890N714HYLeft Final LLC · Gastonia, NCS/N 15079199N714JMartinez Ivan · Oro Valley, AZBuilt 1977 · S/N 15079382N714JCAries Flyers Inc · Santa Clara, CABuilt 1977 · S/N 15079203N714JDGuthrie Bobby D · El Dorado, ARS/N 15079204N714JEAllred Mark · Farmington, UTBuilt 1983 · S/N 18504398N714JFMetcalf Christopher A · Meadowview, VABuilt 1977 · S/N 15079206N714JKDrouin Arnold R · Berlin, NHBuilt 1977 · S/N 15079210N714JLWestra Todd A · Ireton, IABuilt 1977 · S/N 15079211N714JPCp Aviation Inc · Santa Paula, CABuilt 1966 · S/N 15065030N714JQDepartment Of Marine Resources · Augusta, MES/N 18504399N714JTThompson John · Stevens Point, WIBuilt 1977 · S/N 15079217N714JXPiteck Timothy S · Battle Ground, WAS/N 15079221N714KEGustin Ralph P · New Smyrna Beach, FLFirst renewal noticeBuilt 1977 · S/N 15079228N714KHFlying Moose Alaska LLC · Clear, AKBuilt 1983 · S/N 18504400N714KKMcnally Robert H · Tulsa, OKS/N 15079233N714KMDavis Steven M · Eastsound, WABuilt 1977 · S/N 15079234N714KQBowser Dwight H · Anchorage, AKBuilt 1977 · S/N 15079237N714KRB2 W Corporation · Winona, MNBuilt 1977 · S/N 15079238N714KTCox Garry G · Coleman, TXS/N 15079240N714KUInsalaco Stephen C · Benson, AZS/N 15079241N714KWHerbert Michael S · Crawford, COBuilt 1977 · S/N 15079243N714KXLowder Harold E · Fresno, CABuilt 1977 · S/N 15079244N714KZGlomb Andrew · Las Vegas, NVBuilt 1977 · S/N 15079246N714LCCruz Martin G Jr · Prosper, TXBuilt 1977 · S/N 15079249N714LFRollins David M · Martinsville, INBuilt 1977 · S/N 15079252N714LPBlue Skies Time Builders LLC · Roy, WAS/N 15079260N714LRSt Johns Aviation LLC · Saint Johns, MIS/N 15079262N714LSHard Luck Aviation LLC · Tok, AKBuilt 1983 · S/N 18504402N714LWMorcom Aviation Services Inc DBA · Everett, WABuilt 1977 · S/N 15079267N714LXMock Joseph R · Huntsville, TXBuilt 1977 · S/N 15079268N714LZKhosrovyan Rafayel · Fort Worth, TXS/N 15079270N714MWicked Wings LLC · Falls Of Rough, KYS/N 15079274N714MCAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 15079273N714MGManandhar Raj P · Hawthorne, CABuilt 1977 · S/N 15079277N714MJRheintgen Rachel L · Saint Petersburg, FLBuilt 1977 · S/N 15079279N714MKMoe Hudson T · Anchorage, AKBuilt 1977 · S/N 15079280N714MMBragg Peter M · Brooklet, GABuilt 1977 · S/N 15079282N714MPHendrickson Reino W · Osage, MNBuilt 1977 · S/N 15079284N714MWGanser Mark E · Seward, AKBuilt 1977 · S/N 15079290N714MXKubeck Roger A · Dearing, GABuilt 1983 · S/N 18504404N714MZAirgo Inc · Centralia, ILFirst renewal noticeBuilt 1977 · S/N 15079293N714NFSierra Lima Aviation LLC · Riverton, UTBuilt 1977 · S/N 15079298N714NGIngold Terry L · Albemarle, NCBuilt 1977 · S/N 15079299
Back to AD 87-20-03 R2