OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N2860ZCarter Harold · Elizabethton, TNBuilt 1959 · S/N 22-6857N28610Brown Ryan O · Columbia, TNBuilt 1977 · S/N AA5B0677N28614Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843731N28618Morgan Robert J · Mojave, CABuilt 1978 · S/N AA5B0707N2861QBlackmon Robert · San Antonio, TXBuilt 1971 · S/N 17259861N2861TDesert Sky Flight Group Inc · Tucson, AZBuilt 1972 · S/N 28R-7235147N28622Cole Quentin P · Huntingdon Valley, PABuilt 1978 · S/N AA5B0708N28627Key City Fliers Inc · Maquoketa, IAS/N 28-7990420N2862APrecious Heir Holding Company LLC · Tucson, AZBuilt 1979 · S/N 28-7916486N2862PTexas Amphibians LLC · Braunfels, TXBuilt 1978 · S/N 929N2862TReed Thomas F · Maize, KSS/N 28R-7235148N2862XMathews Nancy M · Englewood, TNS/N 17700262N28630Flying Tiger LLC · Chesapeake, VABuilt 1978 · S/N AA5B0711N28631Perry Colin C · Petaluma, CABuilt 1978 · S/N AA5B0712N28633Fritz William J · Carnesville, GABuilt 1978 · S/N AA5B0713N28634Wolvin Michael S · N Fort Myers, FLBuilt 1978 · S/N AA5B0714N28635N28635 LLC · Harding, PABuilt 1978 · S/N AA5B0715N28637Rust Scott Allen · Indianapolis, INBuilt 1978 · S/N AA5B0716N28639International Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N AA5B0718N2863EWetherley Aviation LLC · Boise, IDBuilt 1978 · S/N 17271352N2863MBaillie Ryan B · Hermitage, TNBuilt 1977 · S/N 28-7816318N2863PGic Inc · Oneill, NEBuilt 1979 · S/N 28-7990504N2863QSalsbery Randall E · Sharpsville, INBuilt 1971 · S/N 17259863N2863UEady Paul Clifford · Lakeside, CABuilt 1979 · S/N 28-7990505N2863VBfree2fly LLC · Delaware, OHBuilt 1979 · S/N 28-7990506N2863ZWhitaker Eric L · Detroit, TXS/N 22-6862N28641Cpr Pacific LLC · Salinas, CABuilt 1978 · S/N AA5B0719N28646Kutok Stephen M · Commack, NYBuilt 1978 · S/N AA5B0721N2864QEaglet Flight Operations Lp · Fort Worth, TXBuilt 1971 · S/N 17259864N2864WSpearhead Ranch LLC · Douglas, WYBuilt 1987 · S/N 1001N2864XCardinal Airways LLC · St Johns, FLBuilt 1967 · S/N 17700264N2864YAnderson Bruce A · Seville, OHBuilt 1979 · S/N 28-7911211N2864ZUecker Todd M · Port Townsend, WABuilt 1959 · S/N 22-6871N28650Loseka Tiger LLC · Columbia, ILBuilt 1978 · S/N AA5B0723N28651Dass Aaron · Conroe, TXBuilt 1978 · S/N AA5B0724N28655Straight & Level Aviation LLC · Bradenton, FLBuilt 1978 · S/N AA5B0731N28657Gutelius Kenneth · Lake Orion, MIBuilt 1978 · S/N AA5B0733N28658Hadden Aviation LLC · Sylacauga, ALBuilt 1978 · S/N AA5B0734N28659Timidaiski Daniel · Mikilteo, WABuilt 1978 · S/N AA5B0735N2865QLasalle Charles H · Williamstown, NYBuilt 1971 · S/N 17259865N2865RCarmel Aviation Inc · Boise, IDBuilt 1969 · S/N 28R-35308N2865ZCrouder Trevor J · Fairbanks, AKBuilt 1959 · S/N 22-6864N28663Ramsey Kelly · Argyle, TXBuilt 1978 · S/N AA5B0737N28664Aces Flying Services LLC · Sanford, NCBuilt 1978 · S/N AA5B0738N28667Rehberg Eric · Chattanooga, TNBuilt 1979 · S/N 28-7990422N2866BBulger Edward P · Newburyport, MAS/N 1002N2866QAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1971 · S/N 17259866N2866RCw Arborists Ltd · Sagaponack, NYBuilt 1969 · S/N 28R-35309N2866TPacific Coast Air Museum · Santa Rosa, CAS/N 28-7225258N2866WBowman Field Flying Club Inc · Louisville, KYBuilt 1979 · S/N 28-7916489
Back to AD 87-10-06 R1