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.

N9212XNs Aviation Inc · Ottumwa, IABuilt 1961 · S/N 18253612N92131Cavu Flyers Of Long Island Inc · Ronkonkoma, NYBuilt 1973 · S/N 17261546N9213BWallace Gary E · La Junta, COS/N 55013N9213CGriffith Thomas J · Watertown, MNBuilt 1955 · S/N 31312N9213XChung Thomas · Stanwood, WABuilt 1961 · S/N 18253613N92140Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1981 · S/N 15285371N92141High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17261549N92147Bielstein David P · Plainville, GABuilt 1969 · S/N 18260063N9214CSchumacher Gregory L · Anchorage, AKS/N 31313N9214GOwens Joseph F · Tallahassee, FLBuilt 1971 · S/N 18260754N92150Pessolano Vincent F · Naples, FLBuilt 1969 · S/N 18260064N92151Adiabatic Adventures LLC · Morrison, COBuilt 1969 · S/N 18260065N92152Pank Thomas E · Walkersville, MDS/N 18260066N92158Ackerman Jefferson P · Beaufort, SCBuilt 1969 · S/N 18260068N92159Buster Aviation LLC · Harveys Lake, PABuilt 1973 · S/N 17261550N9215CIrlbeck Joshua W · Northfield, MNBuilt 1954 · S/N 31314N92161Skywarrior Flight Training Inc · Pensacola, FLBuilt 1973 · S/N 17261551N92169Welch William Ben · Danville, ILBuilt 1973 · S/N 17261553N9216GComdess Company Inc · Seville, OHBuilt 1971 · S/N 18260756N9216HBurgess Alan P · Corona, CABuilt 1975 · S/N 17266020N92172Fly Like An Eagle LLC · Springfield, MOBuilt 1969 · S/N 18260073N92175Richards Joseph · Gardiner, NYBuilt 1969 · S/N 18260074N9217AAlumitank Inc · Harvard, ILBuilt 1955 · S/N 26619N9217GRegister Otis E · Rolla, MOBuilt 1971 · S/N 18260757N9217RHunt Galen C · Bellevue, WABuilt 1984 · S/N U20606826N9217UWallace John L · Bethel, AKS/N 15078167N92180Mahanti Robert L · Flagstaff, AZBuilt 1969 · S/N 18260075N92183Desselle Trent · New Orleans, LAS/N 18260077N92184Aviatrix Adventures LLC · Tallahassee, FLBuilt 1969 · S/N 18260078N92187Med Eagle LLC · Folsom, CABuilt 1969 · S/N 18260079N9218BWilliams Leslie D · Oneida, TNBuilt 1958 · S/N 55018N9218CArensmeyer Michael W · Longmont, COBuilt 1978 · S/N R18200448N9218GTpec LLC · Madison, MSBuilt 1971 · S/N 18260758N9218UHolzgrove Thomas H · Pipestone, MNS/N 15078168N92190Rimkus Fisher · Rio Frio, TXBuilt 1969 · S/N 18260081N92193Hendricks Alan M · Greenville, TXBuilt 1969 · S/N 18260082N92198Hanson Steven Dale · Livermore, CABuilt 1969 · S/N 18260084N9219AWatkins Donley E · Cheyenne, WYBuilt 1949 · S/N 18980N9219COtt Tucker Kyle · Belgrade, MTBuilt 1955 · S/N 31318N9219HKful Flyers Foundation Inc · Fullerton, CABuilt 1975 · S/N 17266021N9219UCarlson Farms Inc · Plentywood, MTBuilt 1976 · S/N 15078169N921AARegistration Pending · Deland, FLRegistration pendingBuilt 1973 · S/N 17261752N921ASA2g International LLC · San Juan Capo, CAS/N 33701858N921KPCenturion N709jm LLC · Minneapolis, MNBuilt 1978 · S/N R18200298N921MAMoxie Vincent B · Sarver, PABuilt 1969 · S/N 15071284N92207Eason William E · Gloucester, MAS/N 18260090N92208Full Throttle Aviation LLC · Nashville, ARBuilt 1969 · S/N 18260091N92209Stanton Gregory R Jr · Newport, ORBuilt 1969 · S/N 18260092N9220ABrown Douglas C · Daytona Beach, FLS/N 18981N92214Sfh Aviation LLC · Birmingham, MIBuilt 1969 · S/N 18260094
Back to AD 87-20-03 R2