OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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.

N6059TSible Andrew · Mckinleyville, CABuilt 1964 · S/N 15060759N605NBRegistered aircraftBuilt 1976 · S/N 18052732N605NRState Of Minnesota · Grand Rapids, MNBuilt 1985 · S/N 18504437N605PMSky Baja LLC · Helena, MTS/N 18267188N60602Ratcliff Philip A · White City, ORBuilt 1969 · S/N 15070437N60607Resch Stephen · Fairfax, VAS/N 15070441N6060APowers Michael E · Sierra Madre, CABuilt 1956 · S/N 28660N6060GPrimo Haim · Fredericksburg, VABuilt 1969 · S/N 15071560N6060RRiviello Taylor · Costa Mesa, CAS/N 17253729N60611Feryok John II · Sitka, AKBuilt 1969 · S/N 15070444N60612Hamel Moody · Atlanta, GABuilt 1969 · S/N 15070445N60614Hendryx Alec B · Coffeyville, KSBuilt 1969 · S/N 15070446N60617Williams Robert M · Red Hook, NYBuilt 1974 · S/N 21060595N6061ADickman Edward A · Melba, IDBuilt 1956 · S/N 28661N6061FGustafson John S · Aledo, TXBuilt 1975 · S/N 18264077N6061GJohnson Victor R · Modesto, CABuilt 1969 · S/N 15071561N6061TForgues Inc · Wilmington, DEBuilt 1966 · S/N 182-57058N60624Ketter Kevin M · Bloomington, MNBuilt 1969 · S/N 15070456N60628Aukeman Mark C · Georgetown, MEBuilt 1969 · S/N 15070460N6062FWildcat Airplane Co LLC · Portland, ORBuilt 1975 · S/N 18264078N60630Bichell Kevin C · Corsicana, TXBuilt 1969 · S/N 15070461N60632Lawlyes Bill · Aguanga, CABuilt 1969 · S/N 15070463N60633Newby Terry · Kokomo, INBuilt 1969 · S/N 15070464N60636Allard Michael L · Penrose, COS/N 21060596N60639International Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 15070468N6063ELawrence Aviation LLC · Overland Park, KSS/N 17271987N6063RGarcia Pinedo Adolfo · Miami, FLBuilt 1965 · S/N 17253732N6063TMid Florida Chapter 534 · Leesburg, FLBuilt 1964 · S/N 15060763N60640Lazarus Benjamin · Blaine, WAS/N 15070469N60641Motory Group LLC · Alachua, FLBuilt 1969 · S/N 15070470N60649Anglin Cheryl L · Jackson, MSFirst renewal noticeBuilt 1969 · S/N 15070477N6064JTreger Mark · Dallas, TXFirst renewal noticeBuilt 1972 · S/N A1500364N6064TEsquivel Francisco · Thermal, CAS/N 15060764N60650St Arneault Carmen M · Milton, NHBuilt 1969 · S/N 15070478N60652Broughton Stanley K · Salt Lick, KYBuilt 1969 · S/N 15070479N60653Russo Joseph M · Pleasant Grove, CABuilt 1969 · S/N 15070480N6065AMam Air LLC · Stone Creek, OHBuilt 1956 · S/N 28665N6065JBrown Charles A · Boise, IDBuilt 1972 · S/N A1500365N6065KMiller Durwood B · Screven, GABuilt 1975 · S/N 15077505N60660Nichols William · Wild Rose, WIS/N 26868N6066AAndrews Peter F · Rangeley, MEBuilt 1956 · S/N 28666N6066FMeyer Justin R · Telluride, COBuilt 1975 · S/N 18264082N6066GGisselman Scott D · Lago Vista, TXBuilt 1969 · S/N 15071566N6066JTouchett Air Inc · Long Lake, WIS/N 18263621N6066TDonaldson Ted · Thatcher, AZBuilt 1964 · S/N 15060766N60672Johnson Jeffry L · Eufaula, OKS/N 15070491N6067FPitts Ryan · Brewton, ALBuilt 1975 · S/N 18264083N6067GWildroot Aviation LLC · Bellingham, WABuilt 1969 · S/N 15071567N6067JSale Reported · Ephrata, WASale reportedBuilt 1972 · S/N A1500367N6067RZhu Kevin · Tigard, ORBuilt 1965 · S/N 17253736
Back to AD 87-20-03 R2