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.

N3265JFord-Umfuhrer Austin Donavan · Carrollton, GAS/N 15065965N3265SZehntner David R · Labelle, FLBuilt 1964 · S/N 18255765N3265UPreissler Daniel E · Giltner, NEBuilt 1963 · S/N 18254665N3266EN3266e LLC · Homestead, FLBuilt 1978 · S/N 17271484N3266LWolverine LLC · Roanoke, VABuilt 1967 · S/N 17256166N3266UVingers Michael T · Dellwood, MNBuilt 1963 · S/N 18254666N3267DDavidson Danny F · Anchorage, AKBuilt 1955 · S/N 32065N3267LBetter Fly Inc · Litchfield, ILS/N 17256167N3268CLane Ryan Auctions LLC · Palmyra, PAS/N R18200262N3268JMiller Robert F · Locust Grove, GAS/N 15065968N3268KRegistered aircraftBuilt 1968 · S/N 17700519N3268SSquier Mark R · Lake Dallas, TXBuilt 1964 · S/N 18255768N3268TKawsara Sabah M · Fort Worth, TXBuilt 1967 · S/N 17700568N3268USchafer Gerhard Walter · Fairbanks, AKS/N 20956N326AMAviatzone LLC · Fort Lauderdale, FLS/N R18201474N3270DMcbride Robert W Jr · Cedar Park, TXBuilt 1955 · S/N 32068N3270UScott Brian W · Sagle, IDBuilt 1963 · S/N 18254670N3271AJohnson Jackson B · Wasilla, AKBuilt 1953 · S/N 25915N3271LHenson Raul Andre · Fox Island, WABuilt 1967 · S/N 17256171N3271UDallas Avionics Inc · Dallas, TXBuilt 1963 · S/N 18254671N3271YWoodbury Ivan D · Bowling Green, OHBuilt 1962 · S/N 18254271N3272TSonoras John G Jr · Newport, MIBuilt 1967 · S/N 17700572N3272YOlsen Chris M · Othello, WAS/N 18254272N3273DMonitor Ventures Group LLC · Anaheim, CABuilt 1973 · S/N 33701491N3273EAnderson Thomas J · Big Bear City, CABuilt 1978 · S/N 17271486N3273MLindeen Michael · Anchorage, AKBuilt 1967 · S/N 185-1210N3273SHepfer John E DBA · Midland, TXBuilt 1964 · S/N 18255773N3273TSommers Bradley D · Robinson, KSBuilt 1967 · S/N 17700573N3274DMcroberts David M · Washoe, NVBuilt 1955 · S/N 32072N3274EBitzer John · Cologne, MNBuilt 1978 · S/N 17271487N3274JOgrady John Thomas · West Chicago, ILBuilt 1966 · S/N 15065974N3274LHk Ventures LLC · Paynesville, MNS/N 17256174N3274TRinkle Michael G · Sussex, NJBuilt 1967 · S/N 17700574N3275CMoore Hazel Grace · Boise, IDBuilt 1978 · S/N R18200263N3275DCrystoff James J · Kodiak, AKBuilt 1955 · S/N 32073N3275LMil2atp Inc · Pikeville, NCBuilt 1967 · S/N 17256175N3276DFarkas Jonathan · Mukwonago, WIBuilt 1955 · S/N 32074N3276SLewinsky Marlon · Carrollton, TXBuilt 1964 · S/N 18255776N3276UNk Innovations LLC · Spokane, WABuilt 1963 · S/N 18254676N3277ALandry Anthony H · Port Orchard, WABuilt 1953 · S/N 25921N3277CSandstrom Mark R · Minot, NDBuilt 1978 · S/N R18200264N3277JBranson William E · Stokesdale, NCBuilt 1966 · S/N 15065977N3277LDeshpande Peter N · Eugene, ORBuilt 1967 · S/N 17256177N3277SBayless Smoky · Coronado, CABuilt 1964 · S/N 18255777N3277YLapinsky Richard G · Los Lunas, NMBuilt 1962 · S/N 18254277N3278JSarrafi Frank H · Tarzana, CABuilt 1966 · S/N 15065978N3278LPeterson Donald A · Ajo, AZBuilt 1967 · S/N 17256178N3278SStrong Brian S · Southport, NCBuilt 1964 · S/N 18255778N3278UCarver Thomas G · St Maries, IDBuilt 1963 · S/N 18254678N3278VMathison John · Vancouver, WABuilt 1974 · S/N 15076448
Back to AD 87-20-03 R2