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.

N8531NCaltrider Joseph S · Williamstown, WVBuilt 1969 · S/N 28-11330N8532NNiederberger Edgar C · Idaho Falls, IDBuilt 1969 · S/N 28-11331N8532WSorby Kyle · Fort Ransom, NDBuilt 1963 · S/N 28-10033N8534NVilar Mitch · Brookfield, WIBuilt 1969 · S/N 28-11333N8535EAmerican Compressor Flight Inc · Santa Fe Springs, CABuilt 1976 · S/N 32R-7680150N8535NJeffrey Robert Hudson · Bakersfield, CAS/N 28-11334N8535YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1696N8536Bosco74 LLC · Wilmington, DEBuilt 1975 · S/N 3267N8536DAnderson Kel G · Alta, IABuilt 1957 · S/N 22-5768N8536NMcmath Robert · Seeley Lake, MTS/N 28-11335N8536WFeather Inc · Clarksdale, MSBuilt 1963 · S/N 28-10037N8536XTrask John D · Portsmouth, VABuilt 1984 · S/N 1096N8536YEastern Flight Services Inc · Ronkonkoma, NYBuilt 1984 · S/N 0438N8537Kopaska Linda · Guthrie Center, IABuilt 1973 · S/N 452-73N8537MRegistered aircraftBuilt 1963 · S/N TD-534N8537WGone With The Wind LLC · Sturgis, SDBuilt 1963 · S/N 28-10038N8538DMarble Jere D · Dayton, NVBuilt 1957 · S/N 22-5769N8538JHarrison Gene R · Pendleton, ORS/N BROSE-0001N8538YRothstein Steven R · Punta Gorda, FLBuilt 1967 · S/N 30-1606N8539DEdens Ferlin C · Boone, COBuilt 1957 · S/N 22-5770N8539NMcbride Ivan L · Toddville, IABuilt 1969 · S/N 28-11338N8539WMccarthy Royal B · Eureka, CABuilt 1963 · S/N 28-10040N8539YTwinco Leasing LLC · Yacolt, WABuilt 1967 · S/N 30-1626N853AAAb Prop Plane I LLC · Metairie, LABuilt 2026 · S/N 28010044N853AKKase Gayle L · Wasilla, AKBuilt 2017 · S/N 6901N853CTFaber Aviation LLC · Melbourne, FLBuilt 1969 · S/N 31-614N853LCCox Leon F · Ruffin, NCBuilt 2013 · S/N 70299N853NBuffaloe Thomas N · Mancos, COBuilt 1946 · S/N 91N853NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881369N853RSOlson Helicopters LLC · Corpus Christi, TXS/N 3807N853RVPlumley James Christopher · Travelers Rest, SCBuilt 2007 · S/N 90853N853VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1966 · S/N 32-630N8540FMckenney Charles W · Mount Ida, ARBuilt 1976 · S/N 32R-7780108N8540YCli Aerospace LLC · Appleton, WIS/N 30-1568N8541CHulsey Johnathan James · Wasilla, AKBuilt 1997 · S/N 999N8541EFlying Services Inc · Wilmington, DEBuilt 1984 · S/N 0442N8541NSunrise Aviation LLC · Sumrall, MSS/N 28-11340N8542NSchwechten Kevin · New Waverly, TXBuilt 1969 · S/N 28-11341N8542WChenevert Kenneth F · Seguin, TXBuilt 1963 · S/N 28-10043N8542YAviation Training Solutions LLC · Hilo, HIBuilt 1967 · S/N 30-1598N8543DHuntwork Dayna · Boise, IDBuilt 1957 · S/N 22-5774N8543EAce Aircraft Leasing Inc · Nazareth, PABuilt 1976 · S/N 28-7625140N8544DThames James W · Florence, ALBuilt 1957 · S/N 22-5775N8544HLaw Offices Of Timothy E Nilan A Pro Law Corp · Downey, CABuilt 1970 · S/N 31010N8544LMid Continent Aircraft Corp · Hayti, MOBuilt 1971 · S/N 25-5420N8544NWalton Joseph B · Arlington, TNBuilt 1969 · S/N 28-11343N8544PSetzler Frank · Gilbert, AZBuilt 1964 · S/N 24-4001N8544WTyler Brian W · San Gabriel, CAS/N 28-10045N8545DFour-Five-Delta LLC · Mountainville, NYBuilt 1957 · S/N 22-5776N8545NMatheny Robert S Jr · Beaufort, NCBuilt 1969 · S/N 28-11344
Back to AD 87-10-06 R1