OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N4573JRoss James A · Barrington, RIS/N 28R-30438N4573RKaufmann Carl S · Springfield, MABuilt 1965 · S/N 28-21314N4574JWakefield Aircraft LLC · Cooperstown, NDBuilt 1968 · S/N 28R-30439N4574RKing Vincent A · Grand Junction, COBuilt 1965 · S/N 28-21316N4574TBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 34-7250137N4575FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 28-7715049N4575PWings Management Co LLC · Rio Rancho, NMBuilt 1960 · S/N 27-84N4575WN4575w LLC · Santa Fe Springs, CABuilt 1976 · S/N 13065N4575XPar Mar Bluffs LLC · Parker, SDS/N 28-7690034N4576FDakota Aviation LLC · Sioux Falls, SDBuilt 1976 · S/N 28-7715050N4576XElon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28R-7635081N4577Gateway Of Sturgis LLC · Sturgis, MIBuilt 1999 · S/N 172S8285N4577XFairhaven LLC · Meridian, MSBuilt 1975 · S/N 32-7600004N4578TMeditz Robert S · Chalfont, PABuilt 1972 · S/N 28R-7235097N4579Kinney Joseph B · Palmer, AKBuilt 2023 · S/N 01946N4579JSnagwood Corp · Brentwood, CABuilt 2012 · S/N 5819N4579RSmelser Brady W · Glendive, MTBuilt 1965 · S/N 28-21321N4579TNavajo Air LLC · Scottsdale, AZBuilt 1972 · S/N 28R-7235098N457ACBrown David R · Niceville, FLBuilt 1999 · S/N 414-99N457AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881757N457ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010057N457BCMorris Thomas Z Trustee · Spokane Valley, WABuilt 1974 · S/N 17264589N457CFHelliwell Anne · Sun City, CAS/N 08N457CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280849N457DHRichardson Justin · Glasgow, KYBuilt 1998 · S/N 20457N457FLApplebee Kevin · White Heath, ILBuilt 1971 · S/N 28-7125252N457GHStephenson George B · Santa Fe, NMBuilt 2018 · S/N 72784N457MCBoguy Air LLC · Kingstree, SCBuilt 1974 · S/N 466-74N457PMHordiienko Yurii · Boston, MABuilt 2018 · S/N 2108N457RBHale Francis J III · Raleigh, NCBuilt 1990 · S/N 1457N457SKWorld Marketing Syndicate I · Wilmington, DEBuilt 1975 · S/N 17264736N457SPSouth Dakota State University · Brookings, SDBuilt 1999 · S/N 172S8321N457TThompson Ernest W Jr · Yukon, OKBuilt 1976 · S/N 28-7690218N457TCLangston Thomas G · Weatherford, TXBuilt 2014 · S/N 785N4580FRegistered aircraftBuilt 1976 · S/N 28-7790045N4580RMartin James E · Rostraver Township, PABuilt 1966 · S/N 28-21322N4581JN634mm LLC · Pelham, ALBuilt 1968 · S/N 28R-30450N4581XRegistered aircraftBuilt 1975 · S/N 28-7690042N45829Registered aircraftBuilt 2004 · S/N 28020CN4582AHart Duane L Trustee · Wasilla, AKS/N 18-4888N4582JTew-Mac Aviation · Tewksbury, MABuilt 1968 · S/N 28R-30451N4582RMartin Robert T · Huntsville, OHBuilt 1965 · S/N 28-21324N45832Arenal Patrick T · Granbury, TXBuilt 1977 · S/N 28-7890048N4583RDmac Aircraft LLC · Savannah, GABuilt 1965 · S/N 28-21325N4583TKeppers Richard W · Alexandria, VABuilt 1972 · S/N 28R-7235099N4583XMarquart Timothy Irving · San Antonio, TXFirst renewal noticeBuilt 1975 · S/N 28-7610037N4584FStorm Flying Service Inc · Webster City, IAFirst renewal noticeBuilt 1976 · S/N 28-7790047N4584JBradley Cody C · Auburn, NEBuilt 1968 · S/N 28R-30454N4584RSiegel William G · Wellington, FLBuilt 1965 · S/N 28-21328N4584TLion Air LLC · South Heart, NDBuilt 1972 · S/N 32-7240087
Back to AD 87-10-06 R1