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.

N3728LN3728l LLC · Statesville, NCBuilt 1965 · S/N 17253897N3728RRaks Aviation LLC · Hillsborough, NJBuilt 1966 · S/N 17255528N3728UMaupin Daniel D · Corvallis, ORBuilt 1963 · S/N 18255128N3728YPrt Aviation Corp · Wilmington, DEBuilt 1963 · S/N 21058228N3729FPena Miguel A · Live Oak, FLS/N 17255224N3729LWells Timothy P · Raynham, MAS/N 17253898N372DRees Ryan G · Loa, UTS/N 15070466N372GGIal Corp · Lewes, DEBuilt 1981 · S/N 17274926N372SAJoe Wagner IV Construction LLC · Zebulon, NCBuilt 1979 · S/N 17272854N372SFBrophy Martin Joseph · Fort Collins, COBuilt 1978 · S/N 18266569N372VUPerry Robert P · Chelan, WABuilt 1955 · S/N 31428N3730DLedbetter Jeffrey Allen · Huntley, ILS/N 34430N3730RChief Joseph Flyers Inc · Joseph, ORBuilt 1966 · S/N 17255530N3730UWarren Kevin · Berger, MOBuilt 1963 · S/N 18255130N3731LSturguess James K · Boonville, MOS/N 17253900N3731SHerzfeld-Van Dyke Holly A · Conway, ARBuilt 1963 · S/N 17250931N3731YHaglin Dana · Erie, COBuilt 1963 · S/N 21058231N3732DClark William M · Ann Arbor, MIBuilt 1957 · S/N 34432N3732LSumma Dawn K · Medina, OHBuilt 1965 · S/N 17253901N3732SMccague Kelly M · Las Cruces, NMBuilt 1963 · S/N 17250932N3732UGifford Tracy G · Stephenville, TXBuilt 1963 · S/N 18255132N3733FBurch Samuel Owen · Roxboro, NCBuilt 1966 · S/N 17255228N3733LHillstrom Rudolph A · Oakville, WABuilt 1965 · S/N 17253902N3733RCouick Donald Michael · Monroe, NCBuilt 1966 · S/N 17255533N3733SBrn Technical Inc · Boca Raton, FLBuilt 1963 · S/N 17250933N3733VToccoa Aviation · Toccoa, GABuilt 1975 · S/N 15076605N3733YHolliday Ivan Scott · Poplarville, MSBuilt 1963 · S/N 21058233N3734DVessey William M · Yuma, AZBuilt 1957 · S/N 34434N3734JTrue Course LLC · Honolulu, HIBuilt 1966 · S/N 15065034N3734LBertrand Todd A · Anchorage, AKBuilt 1965 · S/N 17253903N3734VBurrell Dennis E · Parma, IDS/N 15076606N3735FEb Flight Training LLC · Daytona Beach, FLBuilt 1966 · S/N 17255230N3735JPetersen Kenton D · Jefferson, SDBuilt 1966 · S/N 15065035N3735SBeucler Brian G · Sandown, NHFirst renewal noticeBuilt 1963 · S/N 17250935N3736UDelong Don R · Wheeler, MIBuilt 1963 · S/N 18255136N3737VClarke Adrian N · Aledo, TXBuilt 1975 · S/N 15076607N3738DHall Chris S · Garden City, MOBuilt 1959 · S/N 34438N3738LTran Tuan M · Canton, MIBuilt 1965 · S/N 17253907N3738YAirborne Solutions Group LLC · Dayton, OHBuilt 1963 · S/N 21058238N3739DBodie Aviation Ltd · Laporte, COS/N 34439N3739FSchlueter Helmuth K · San Tan Valley, AZS/N 17255234N3739LMattson David G · Lake Park, MNBuilt 1965 · S/N 17253908N3739RRusak Robert J · Paris, TXBuilt 1966 · S/N 17255539N3739UYown Inc · Ethridge, MTBuilt 1963 · S/N 18255139N3739YCessna 210 LLC · Ogden, UTBuilt 1963 · S/N 21058239N373ARPaul Brightwell Dirtworks Inc · Springer, OKBuilt 1979 · S/N P21000308N373HShumate Johnny E · Spring, TXBuilt 1974 · S/N 21060190N373KVCrystalinas Johnathan · Rancho Cordova, CABuilt 1966 · S/N 15064401N373PJRock Creek Corp · Henderson, NVBuilt 1978 · S/N 21062887N3740FLavalley Asset Management · Potsdam, NYBuilt 1966 · S/N 17255235
Back to AD 87-20-03 R2