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.

N759YMJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266365N759YQPreston Dan R · Medway, MABuilt 1978 · S/N 18266368N759YRDoss Michael G · Austin, TXBuilt 1978 · S/N 18266369N759YSBowers LLC · Englewood, COBuilt 1978 · S/N 18266370N759YURegistered aircraftBuilt 1978 · S/N 18266372N759YWChamberlain Diane L · Houston, TXS/N 18266374N759YXMagee Thomas J · Pasadena, CABuilt 1978 · S/N 18266375N759YYWainwright LLC · Mesa, AZFirst renewal noticeS/N 18266376N759ZDN759zd LLC · Stratford, CTBuilt 1978 · S/N 18266381N759ZETransair Leasing Inc · Miami, FLBuilt 1978 · S/N 18266382N759ZHHatch George R · Avon, MABuilt 1978 · S/N 18266385N759ZKShelley James R · Bowling Green, KYBuilt 1978 · S/N 18266387N759ZMN759zm LLC · Fort Collins, COBuilt 1978 · S/N 18266389N759ZQSlone Bryan E · Omaha, NEBuilt 1978 · S/N 18266392N759ZTSherck Nicholas · Woodbridge, NJBuilt 1978 · S/N 18266395N759ZUFlying Bobcat LLC · Boise, IDS/N 18266396N75ALTeebagy Steven C · Wellington, FLBuilt 1973 · S/N 17701927N75CWilliam Roy S · Kendallville, INBuilt 1978 · S/N 18503664N75CGRichter Aviation Inc · Maxwell, CABuilt 1973 · S/N 18502214N75DAHenderson John L · Ozona, TXBuilt 1979 · S/N 21063172N75DKPaul Mark A · Warren, OHS/N U20603217N75DMPro-Rentals Inc · Athens, OHBuilt 1976 · S/N 21061430N75DWBliss Gregory A · Saint Johns, FLBuilt 1975 · S/N 18263906N75EAero Techniques Inc · Portage, MIBuilt 1966 · S/N 17255365N75EELgc Consulting Inc · Salisbury, NCBuilt 1975 · S/N 21060837N75ERFaulkner John · Urbana, OHBuilt 1977 · S/N 17269776N75FBPhillips Brandon S · Susanville, CABuilt 1966 · S/N 18051707N75GLSkyshare LLC · Boulder, COBuilt 1973 · S/N 21059814N75LERegistered aircraftBuilt 1965 · S/N 185-0870N75LGMarr Lance · Portland, ORBuilt 1978 · S/N P21000015N75MLLowe John Howard II · Tifton, GABuilt 1964 · S/N 18255505N75NSJohnson Dale B · Steele, NDBuilt 1968 · S/N 17257539N75NXAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 33701660N75PJJohnson Peter G · Tower, MNBuilt 1975 · S/N U20602705N75RCJoffe Zalman · Bahama, NCBuilt 1981 · S/N 21064325N75SDVimco N75sd LLC · El Paso, TXBuilt 1973 · S/N 17260829N75SFKlein Neal S · Newberg, ORBuilt 1969 · S/N 18259658N75SMSummit Aviation Adventures LLC · Fairplay, COBuilt 1963 · S/N 18254675N75TCMorales Luis · Florence, ORBuilt 1977 · S/N 17268913N75TRHale Mitchell D · Chugiak, AKS/N 18502790N75VAPfingsten Thomas H · Peachtree City, GABuilt 1968 · S/N 18051936N75VRSlt Global Alliances LLC · Las Vegas, NVBuilt 1979 · S/N P21000429N75WCCedar Valley Air LLC · Lehi, UTS/N 15076045N75WFSjs Holdings LLC · Los Angeles, CABuilt 1980 · S/N P21000617N75WGHenry David Greer Sr · Waco, TXBuilt 1978 · S/N 18266297N75YAHayes David M · Edgewood, TXBuilt 1965 · S/N 21058665N7600HArslanian Brian Haroutun · Brookhaven, GABuilt 1972 · S/N 18261288N7600JBuchanan Jamie · Deforest, WIBuilt 1976 · S/N 18264689N7600MTitan Construction LLC · Pinedale, WYBuilt 1959 · S/N 55900N7600NKeller Douglas O · West Linn, ORBuilt 1977 · S/N U20603704
Back to AD 87-20-03 R2