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.

N61769Jackson Lynn B · Cocoa Beach, FLBuilt 1975 · S/N 17264787N6176DSawyer Stephen W · Brigham City, UTBuilt 1957 · S/N 22-4823N6176GGaruda Flight Training LLC · Miami, FLBuilt 1979 · S/N 17273575N6176JWertz Joseph S Jr · Shoemakersville, PABuilt 1976 · S/N 28-76-15321N61770Mwbw LLC · Shawano, WIBuilt 1975 · S/N 17264788N61772Henry Donald R · Lake Stevens, WABuilt 1975 · S/N 17264789N61778Cambridge Valley Flying Club Inc · Shushan, NYBuilt 1975 · S/N 17264793N6177NDesmarais Dan · Soldotna, AKBuilt 1993 · S/N 839N61780Delaney Kevin P · Germantown, TNBuilt 1975 · S/N 17264794N61783Copper River Airmotive LLC · Copper Center, AKBuilt 1975 · S/N 17264797N61785Fort Sam Houston Flying Club · San Antonio, TXBuilt 1975 · S/N 17264799N61786Northwest Wings LLC · Hillsboro, ORBuilt 1975 · S/N 17264800N61789Padilla Frank J · Vacaville, CAS/N 17264802N6178PFolse Eldred J · North Las Vegas, NVBuilt 1959 · S/N 24-1280N61794Dm Asset Management LLC · Plain City, OHBuilt 1975 · S/N 17264807N61799Flf Aviation LLC · West Columbia, SCBuilt 1975 · S/N 17264810N6179JSanders Jeffrey A · Aurora, COBuilt 1976 · S/N 32R-7680326N6179PHarris Robert C · Spring Hill, FLS/N 90849N6179RMcclinton Charles R · Cape Coral, FLBuilt 1979 · S/N 172RG0104N617ARReeves Douglas G · Lewisville, TXBuilt 2002 · S/N 24968N617CMGravatt Eric Kenneth · Ammon, IDBuilt 1967 · S/N 28-10899N617DGFournier Jean Paul R · Ocala, FLBuilt 2003 · S/N 60185N617EMarsh Michael B · Freeland, MIBuilt 2013 · S/N 75-8234N617ECHungerford Brett · Cincinnati, OHBuilt 1975 · S/N 32R-7680096N617EDMente Charles · Homestead, FLBuilt 1968 · S/N 24-4765N617ETBunck Richard DBA · Apple Valley, CABuilt 1967 · S/N 32-40205N617FLHarris Nancy B · Christiansburg, VABuilt 1971 · S/N 28-7125502N617FMBurruss Lawrence R Jr · Charlottesville, VABuilt 1998 · S/N 22557N617GYagues Kevin B · Boise, IDBuilt 2006 · S/N 5752N617JAYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 28020265N617JBDoll Joseph L · Patterson, NCBuilt 2023 · S/N 69N617JLHeli Concepts LLC · Austin, TXBuilt 2006 · S/N 11161N617MAAs The Crow Flies LLC · Belmont, WIBuilt 2003 · S/N 444-2003N617MCCigal Mark A · Hendersonville, NCBuilt 2004 · S/N 81530N617MZDouglas Weske P · Blaine, MNS/N 81064N617TCCamp Thomas H · Melbourne, FLBuilt 1974 · S/N 18-7409120N617TNNichols Todd Eric · Kansas City, MOBuilt 2024 · S/N 001N617TWTango Whiskey Aviation LLC · Cody, WYBuilt 2002 · S/N 18281176N617WWood Jim · Seminole, TXBuilt 1973 · S/N 579-73N61801Tampa Aviation Club Inc · Tampa, FLBuilt 1975 · S/N 17264811N61803N61803 LLC · Manassas, VABuilt 1975 · S/N 17264812N61804Skyhawk Virginia LLC · Chester, VABuilt 1975 · S/N 17264813N6180LAryvue Inc · Cordele, GABuilt 1972 · S/N AA5-0280N6180YChilton Leonard Jay · Caddo Mills, TXS/N 27-3406N61812Craft Robert L · Cynthiana, KYBuilt 1975 · S/N 17264818N61813Nationwide Aviation LLC · Hudson Oak, TXBuilt 1975 · S/N 17264819N61814On Glideslope LLC · Middletown, DEBuilt 1975 · S/N 17264820N61817Rb Aviation LLC · Vassar, MIBuilt 1975 · S/N 17264821N6181DNolta Christopher D · Corcoran, CABuilt 1957 · S/N 18-5468N6181FTarchinski James E · Rochester Hills, MIBuilt 1979 · S/N 17273161
Back to AD 87-10-06 R1