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.

N2230898x LLC · Caddo Mills, TXBuilt 1968 · S/N 15068208N2230CHendricks Construction LLC · Phoenix, AZS/N 30530N2230DHendricks Construction LLC · Phoenix, AZBuilt 1976 · S/N 18503053N2230JCragg Gordon E · Georgetown, TXS/N 15065430N2230WJac & Phill Corp · San Ysidro, CAS/N 17250077N22310Tackett Eric · Huntington, INBuilt 1968 · S/N 15068210N22318Reggie Denis A Jr · Marietta, GABuilt 1968 · S/N 15068214N2231DFisher Air LLC · Cardington, OHBuilt 1952 · S/N 20383N2231GKelly Richard · Ogdensburg, NYS/N 51531N2231THewitt David E · Newcastle, MEBuilt 1968 · S/N 185-1383N22325Marlee B Thomas · Tolar, TXBuilt 1968 · S/N 15068216N22329Guernsey G R · Belen, NMBuilt 1968 · S/N 15068219N2232EPink Skies Inc · Willoughby, OHBuilt 1978 · S/N 17271195N2232GBigler Mark · Topeka, KSS/N 51532N22335Johnson Marissa N · Avon, INBuilt 1968 · S/N 15068222N2233DMerrill Christopher D · Albany Twp, MES/N 20385N2233GA F Flyers LLC · American Falls, IDBuilt 1958 · S/N 51533N2233JPalmer Kim W · Lockport, NYBuilt 1966 · S/N 15065433N2233RDorman William James Trustee · Anchorage, AKBuilt 1975 · S/N 18502859N2233SRichardson Robert O · Spring Grove, ILBuilt 1976 · S/N 21061178N2233TSeward Air Taxi LLC · Seward, AKS/N 185-1386N2234GBaldwin Trevor K · Owasso, OKBuilt 1958 · S/N 51534N2234RJones Lennis William III · Rule, TXBuilt 1968 · S/N T210-0384N22351Air Discovery La LLC · North Hollywood, CABuilt 1968 · S/N 15068229N22354Franks Cory · Idalou, TXS/N 15068232N22355Quinones Steven · Forney, TXBuilt 1968 · S/N 15068233N2235DHasner Mark A · Fairbanks, AKS/N 20387N2235ELivingston Eric L DBA · Winchester, INBuilt 1978 · S/N 17271198N2235SN2235s LLC · Overland Park, KSBuilt 1976 · S/N 21061180N22360Levy Peter F · Augusta, KSBuilt 1968 · S/N 15068236N22361Youngblood Steve R · Young Harris, GABuilt 1968 · S/N 15068237N2236RSouthern Skies Aviation Inc · Cedar City, UTS/N T210-0386N2236TParks Walter G · Chugiak, AKBuilt 1968 · S/N 185-1390N2237GSmith Caleb · Beggs, OKBuilt 1958 · S/N 51537N2237JSudduth Mark E · Lancaster, PABuilt 1966 · S/N 15065437N22385Knutson Wayne R · Thompson, NDBuilt 1968 · S/N 15068248N2238CGorham Wendy J · Grand Rapids, MNBuilt 1953 · S/N 30538N2238DFanoni Michael A · Colfax, CABuilt 1952 · S/N 20390N2238EAtd Pilot Training LLC · Kansas City, MOS/N 17271199N2238HRhodes Mike A · Independence, ORBuilt 1953 · S/N 25644N2238JPearce William · Grants Pass, ORBuilt 1966 · S/N 15065438N2238XStyron Mark A · Pasadena, TXS/N 337-0138N2238YFerrara Edmond · La Puente, CABuilt 1967 · S/N 17700038N22395Morrison Donald D · Santa Clarita, CABuilt 1974 · S/N 17264063N22396Jordan Lennon D · Bartow, FLBuilt 1972 · S/N 21059741N2239GPotter Cleve J · Fresno, CABuilt 1958 · S/N 51539N223BDN223bd LLC · Fresno, CABuilt 1980 · S/N R18201454N223BECampbell Edward A · Anchorage, AKBuilt 1977 · S/N 17268915N223BTMull David L · Kathleen, GABuilt 1978 · S/N R18200360N223LDGaston'S White River Resort Inc · Lakeview, ARBuilt 1965 · S/N U206-0493
Back to AD 87-20-03 R2