OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N3650CTotty Michael N · Gainesville, MOBuilt 1954 · S/N 31148N3650JPostle Jessica Grace · Newark, OHBuilt 1966 · S/N 15064950N3650LTom Wrolstad Aircraft LLC · Molalla, ORBuilt 1965 · S/N 17253819N3651CHately William · Anchorage, AKBuilt 1978 · S/N R18200295N3651UDeibel Adam · Flagstaff, AZS/N 18255051N3652JJet Boy LLC · Carlsbad, CABuilt 1966 · S/N 15064952N3652LJbm Aviation LLC · Mc Leansboro, ILBuilt 1965 · S/N 17253821N3652SBennett Quinn S · Sterling, AKS/N 15062745N3652YMokhtari Rasoul · Nashville, TNBuilt 1963 · S/N 21058152N3653CDomingquez Clara · Anchorage, AKBuilt 1954 · S/N 31151N3653JGrachev Timofey · Hammond, WIBuilt 1966 · S/N 15064953N3653LRistau Kent T · Eagle Grove, IABuilt 1965 · S/N 17253822N3653UMedeiros Germano Manuel · Caruthers, CABuilt 1963 · S/N 18255053N3654CRose Hugh S · Fairbanks, AKBuilt 1954 · S/N 31152N3654LHeritage In Flight Museum Inc · Lincoln, ILBuilt 1965 · S/N 17253823N3655CViavant Toby S · Ester, AKBuilt 1954 · S/N 31153N3655UBoggs Dennis E · Buffalo, WYBuilt 1963 · S/N 18255055N3656JLofland Aviaiton LLC · Moscow Mills, MOBuilt 1966 · S/N 15064956N3656SBell Michael L · Spokane, WAS/N 17250856N3656UMccarty Troy Allen · New Plymouth, IDBuilt 1963 · S/N 18255056N3657LHollabaugh David S · Fulton, MOBuilt 1965 · S/N 17253826N3657SIsakson Dennis E · Van Tassell, WYBuilt 1963 · S/N 17250857N3657YSims Daniel G · Martinez, CABuilt 1963 · S/N 21058157N3658JBernbeck Alan R · Benton, KSBuilt 1966 · S/N 15064958N3658LGraczyk Michael E · Lake Elmo, MNBuilt 1965 · S/N 17253827N3658SOrlovich John A · Boise, IDS/N 17250858N3658YJo Co Inc · Knoxville, TNFirst renewal noticeBuilt 1963 · S/N 21058158N3659CWhite Paul S · Clarksville, TNBuilt 1954 · S/N 31158N3659JHenderson Mark A · Duluth, GABuilt 1966 · S/N 15064959N3659SWeed Thomas W · Limington, MEBuilt 1963 · S/N 17250859N3659YPeterson Laurel R · Hart, MIBuilt 1963 · S/N 21058159N365FCRegistration Pending · Kalispell, MTRegistration pendingBuilt 1973 · S/N 18502233N365JBHentges Dave · Canby, MNBuilt 1952 · S/N 25419N365PCWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271033N365RARanger Airfield Foundation · Ranger, TXBuilt 1972 · S/N 15073416N3660LBersig James R · La Palma, CAS/N 17253829N3661CAas LLC · Ovid, MIBuilt 1954 · S/N 31160N3661SMiller Harvey L · Livonia, MIBuilt 1963 · S/N 17250861N3661TOmega 1 Corp · Middletown, DEBuilt 1958 · S/N 51001N3661UGlenney Christopher · Milan, NHBuilt 1963 · S/N 18255061N3662CArmi LLC · Nevada, IABuilt 1978 · S/N R18200297N3662JDeninger William J · Northbrook, ILS/N 15064962N3662LPrice John C · Bennington, KSBuilt 1965 · S/N 17253831N3662UBenter Wayne D · Crosby, NDBuilt 1963 · S/N 18255062N3663SFranks Richard W · Moville, IAS/N 17250863N3663UWilliams James R · Austin, TXBuilt 1963 · S/N 18255063N3663VCordova Jose F · Anaheim, CABuilt 1975 · S/N 15076578N3663YBrown Robert Scott · Troutman, NCBuilt 1963 · S/N 21058163N36645Kaufmann Chad · Lewiston, IDBuilt 1958 · S/N 36645N3664LNixon Robert W · Mc Alpin, FLBuilt 1965 · S/N 17253833
Back to AD 87-20-03 R2