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.

N897RVPorter David T · Martinsburg, WVBuilt 2017 · S/N 74311N897SCPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 2881801N8980PLittle Wood LLC · Bellevue, MIBuilt 1966 · S/N 24-4439N8980RHolmes Aviation Inc · Cannon Falls, MNBuilt 1960 · S/N 7GCB-14N8980VSweitz-Air Inc · Stewartstown, PAS/N 17264336N8980WAddis Timothy David · Mount Vernon, OHBuilt 1965 · S/N 28-10559N8980YTomu Fly LLC · Vero Beach, FLS/N 39-146N89811Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1983 · S/N 17276013N8981AAmerican Aircraft Sales LLC · Lincolnshire, ILBuilt 1978 · S/N 32-7840190N8981RBlock Raymond J · Palmer, AKS/N 7GCB-10N8981YGrey Enterprises Holdings LLC · Kalispell, MTBuilt 1972 · S/N 39-138N8982DNorth Sound Aviation Inc · Sedro Woolley, WABuilt 1958 · S/N 18-6377N8982PAviation & Aerospace Consulting & Mgmt Svcs LLC · Bullhead City, AZBuilt 1966 · S/N 24-4441N8982RBoo Steven R · Chisago City, MNBuilt 1960 · S/N 7GCB-15N8982VHirsch John K Trustee · Gerald, MOBuilt 1974 · S/N 17264338N8982WTorres Lewis A · Pasadena, CABuilt 1966 · S/N 28-10815N8982YCovington James P · Poplar Grove, ILBuilt 1972 · S/N 39-147N8983JStensrud Maynard R · Waseca, MNBuilt 1966 · S/N 28-3006N8983PBlum Kenneth J · Truckee, CABuilt 1966 · S/N 24-4442N8983VMoon Reagan E · Bossier City, LABuilt 1974 · S/N 17264339N8984JKlassen Wayne V · New Ulm, MNBuilt 1965 · S/N 28-3007N8984NBlair Gary B · Salado, TXBuilt 1969 · S/N 32-40867N8984PMarchant Scott · Clackamas, ORBuilt 1966 · S/N 24-4443N8985CCornelius James Sean · Hamilton, MOBuilt 1976 · S/N 32R-7680147N8985PSharp Charles Barry · Fulton, KYBuilt 1966 · S/N 24-4445N8985WKeskintepe Levent · Las Vegas, NVBuilt 1964 · S/N 28-10564N8986JKleinberg Kenneth A · Saugerties, NYBuilt 1965 · S/N 28-3009N8986NBay Air Inc · Dillingham, AKS/N 32-40869N8986PNielsen James R · Carson City, NVS/N 24-4446N8986RYarbanton John Robert · Muskegon, MIBuilt 1960 · S/N 7GCB-16N8986VAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1974 · S/N 17264342N8986WCandler Derrick · Tampa, FLBuilt 1964 · S/N 28-10565N89878Corwin Shawn M · Tucson, AZBuilt 1983 · S/N 17276015N8987CDouble M Charters LLC · Lakeland, FLBuilt 1976 · S/N 32R-7680148N8987VPiper Capital Growth Fund LLC · Scottsdale, AZBuilt 1974 · S/N 17264343N8987WSonrise Aviation LLC · Lake Havasu City, AZBuilt 1964 · S/N 28-10566N8987YHanson William D · Soldotna, AKBuilt 1974 · S/N 18-7409132N8988JMerkle Hunter T · Mattawa, WABuilt 1966 · S/N 28-3011N8988NCicero Flying Club LLC · Indianapolis, INBuilt 1969 · S/N 32-40871N8988RYoung Andrew J · Eagle River, AKBuilt 1960 · S/N 7EC-732N8988VWahle Daniel C · Missoula, MTBuilt 1974 · S/N 17264344N8988WGonzaga Michaelr · Chino Hills, CABuilt 1965 · S/N 28-10567N8989JJohnston Family Clinic Inc · Meridian, MSS/N 28-3012N8989XCascadia Aircraft LLC · Sandpoint, IDBuilt 2016 · S/N 001N898AMWyatt LLC · Hot Springs, SDBuilt 1998 · S/N 1427N898CPThomas Robert M Jr · Kissimmee, FLBuilt 1975 · S/N 32-7640031N898DANopat LLC · North Charleston, SCBuilt 2000 · S/N 2843377N898DKPratt Christopher J · Dallas, TXBuilt 2005 · S/N 80898N898DSBeretta James P · Indian Springs, ALBuilt 1977 · S/N 32R-7780358N898GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881470
Back to AD 87-10-06 R1