OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N17016Mika Brian D · Andover, MNBuilt 1972 · S/N 15073583N17019Reed James W · Boulder City, NVBuilt 1976 · S/N 17702496N1701RM R Planes LLC · Redmond, WABuilt 1974 · S/N 18502423N1701VBeach Chad T · Kilgore, TXBuilt 1974 · S/N 17262851N17021Fletcher John Guy · Diamondhead, MSS/N 15073587N1702CCork Dennis R · Soldotna, AKBuilt 1953 · S/N 30402N1702EExecutive Flight Institute LLC · Murrieta, CABuilt 1978 · S/N 17271101N1702QStrutzenberg Kent R · Manson, IABuilt 1971 · S/N 15073002N1702RDaniel Boone Flying Club Inc · Booneville, MOBuilt 1978 · S/N R18200523N1702VClassic Rotors Museum · Ramona, CABuilt 1974 · S/N 17263717N17033Browning Brad T · Lake Park, MNBuilt 1972 · S/N 150-73594N17039Davidson Luke H · Gilmer, TXS/N 15073597N1703MNesloney Thomas Jeffery · Hilltop Lakes, TXBuilt 1975 · S/N 18264417N1703QTroutman Noah M · Owensboro, KYBuilt 1971 · S/N 15073003N17043Coleman Sherod · Houston, TXBuilt 1972 · S/N 15073600N17045Streichenwein Scott F · Salisbury Mills, NYBuilt 1972 · S/N 15073602N17047Sickinger Alan W · New Philadelphia, OHBuilt 1972 · S/N 15073604N17048Myob Group LLC · Ocala, FLBuilt 1972 · S/N 15073605N17049101 Inc · Bejou, MNBuilt 1976 · S/N 17702497N1704DSykes Gregory P · Arlington, WABuilt 1951 · S/N 20147N1704QOlfert Ronald W Trustee · Frazer, MTS/N 18257248N1704UKuspuk School District · Aniak, AKBuilt 1975 · S/N 20700304N17050Findlow Jerry E · Glasser, NJBuilt 1976 · S/N 17702498N17052Skypilot LLC DBA · Benbrook, TXBuilt 1976 · S/N 17702499N17053Rough Joseph W · Priest Lake, IDBuilt 1953 · S/N 25678N17059N79107 LLC · Orrville, OHBuilt 1982 · S/N R18201915N1705DSchultz Jeffrey J · Wasilla, AKBuilt 1951 · S/N 20148N1705FTennis Gayland L · Bath, MIBuilt 1966 · S/N 17255100N1705RCox Brian Allen · Pasadena, CABuilt 1978 · S/N R18200525N1705VNiles Air LLC · Concord, NCBuilt 1974 · S/N 17263718N17060Jacobsen Lee E · Inchelium, WABuilt 1972 · S/N 15073612N17065Glaser Donald L Jr · Olive Branch, MSS/N 150-73615N17068Adamski Thomas R · Grantham, NHBuilt 1976 · S/N 17702501N17069Joyce Michael P · New Kent, VAS/N 15073619N1706DMaser Matt P · Junction City, ORBuilt 1952 · S/N 20149N1706MStocker Russell · Woodland, CABuilt 1970 · S/N 33701306N17077Shehl George William III · Charleston, WVBuilt 1972 · S/N 15073257N1707DMorse David M · Kernersville, NCBuilt 1951 · S/N 20150N1707FFreije Anthony M · Anchorage, AKBuilt 1966 · S/N 17255102N1707QGarcia Jorge A · Ponce, PRBuilt 1971 · S/N 15073007N1708CHaggard Roy A · Murrieta, CABuilt 1953 · S/N 30408N1708FKnudsen Mark A · Whitmore Lake, MIBuilt 1966 · S/N 17255103N1708QJergovich Jack A · Austin, TXBuilt 1971 · S/N 15073008N1708RHall Alan D Trustee · Big Bear Lake, CABuilt 1974 · S/N 18502430N1708ZVr Jet LLC · Goshen, INBuilt 1963 · S/N 336-0008N17091Martin Stanley B · Lockhart, TXBuilt 1976 · S/N 17702502N17098Lake Michigan Asset Management LLC · Grand Rapids, MIBuilt 1972 · S/N 15073622N1709CDmj Holdings LLC · Kalispell, MTBuilt 1953 · S/N 30409N170AWyrick Randall D · Fairland, OKBuilt 1987 · S/N 19374N170ACBrett Price Excavating Inc · Rigby, IDS/N 18266551
Back to AD 87-20-03 R2