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.

N9194VAlva Aviation LLC · Nacogdoches, TXBuilt 1969 · S/N 690040N9194WWatson Paul F · Galloway, NJS/N 28-10852N9194YBanner Jeffrey D · Grove City, PABuilt 1985 · S/N 28-8511007N9195JLau-Camarena Alvaro · Euless, TXBuilt 1966 · S/N 28-3263N9195KWatson Joseph L Jr · Concord, NCBuilt 1976 · S/N 28-7690227N9195LStatewide Transportation LLC · Oklahoma City, OKBuilt 1971 · S/N 293-72N9195PHarstine Lucene May · Claypool, INBuilt 1967 · S/N 24-4688N9195SBailey Thomas P · Cannelton, INBuilt 1975 · S/N MC-368N9195VHunter Robert J DBA · Montgomery, ALBuilt 1969 · S/N 690041N9195WMcguire Aviation LLC · Kalispell, MTBuilt 1967 · S/N 28-10853N9196HLaplante Rene J · Bellingham, WABuilt 1975 · S/N 17266008N9196JScarlett Seth T · Omaha, NEBuilt 1966 · S/N 28-3264N9196LRunyon Larry · Susanville, CABuilt 1971 · S/N 294-72N9196PHarris Michael · Pointblank, TXBuilt 1967 · S/N 24-4689N9196SSkyward Leasing Inc · Dallas, GABuilt 1975 · S/N MC-370N9196VScherbarth Kenneth C · Eatonville, WABuilt 1969 · S/N 690051N9197BEsteban John G · Dublin, NHBuilt 1993 · S/N 2890192N9197JDifabio Jack F · Newtown, PABuilt 1966 · S/N 28-3265N9197LSchutze Curt K · Knoxville, TNBuilt 1971 · S/N 295-72N9197PHardin County Aviation LLC · Kountze, TXBuilt 1967 · S/N 24-4690N9197SEisenhaur Timothy · Wells, MEBuilt 1975 · S/N M-1684N91984A-Line LLC · Kent, WABuilt 1973 · S/N 17261532N9198PBarna George · Castleton, NYBuilt 1967 · S/N 24-4692N9198STolton Grant D · Republic, WABuilt 1975 · S/N M-1712N9199POther Woman LLC · Gulf Shores, ALBuilt 1990 · S/N 4622107N919AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881948N919BTGeorges Thomas A · Santa Teresa, NMBuilt 1997 · S/N 27-0226N919CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8339N919DBPeterson Scott W · Garfield, KSBuilt 2001 · S/N 1198005N919DJPope James D · Lewiston, IDBuilt 2005 · S/N 10644N919HGRegistered aircraftBuilt 2019 · S/N 30062N919JRByrne Ian E · Del Mar, CABuilt 2014 · S/N 70840N919KTAir One Helicopters LLC · Lincoln Park, MIBuilt 2021 · S/N 14457N919LFUnmanned Aerial Research LLC · Freeport, FLBuilt 1978 · S/N AA5B0913N919PMRegistration Pending · Atmore, ALRegistration pendingBuilt 1999 · S/N 001N919RFRegion Flyers LLC · Valparaiso, INBuilt 1981 · S/N 28-8216062N919RVSamadhi Clear Mind Yoga Retreat LLC · San Marcos, TXBuilt 2016 · S/N 72328N919SPGorman Kevin V · Ebensburg, PABuilt 1999 · S/N 3257113N919TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 2000 · S/N 17280843N919UAKarably David P · Earleton, FLS/N 24-1720N91ABMac Services Of Ocala LLC · Ocala, FLBuilt 1991 · S/N 2423N91ANWright William B · Holland, PABuilt 2003 · S/N 90229N91ARBarrier Gary W · Mount Pleasant, NCBuilt 1983 · S/N 7446CN91AUScreaming Duck Air LLC · Houston, TXS/N 32R-8129017N91BLLloyd Aviation LLC · Spring Branch, TXBuilt 1988 · S/N 764N91BPF3 Aviation LLC · Summerville, SCBuilt 1977 · S/N 31-7812034N91BRRegistration Pending · South Boston, VARegistration pendingBuilt 1965 · S/N 24-4326N91BSDt Aviation LLC · Bountiful, UTBuilt 1999 · S/N 1076N91CGRick Jelinek Trucking Inc · Palmyra, WIBuilt 1964 · S/N 28-20214N91CKBurril Benjamin D · Locust, NCS/N 20883
Back to AD 87-10-06 R1