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.

N80772Payne Michael S · Sequim, WABuilt 1946 · S/N 175N80773Boyl Traci L · Ukiah, CABuilt 1976 · S/N 17266740N80774Dugger Aviation LLC · Merritt Island, FLBuilt 1976 · S/N 17266741N80775Sierra Bravo LLC · Littleton, COBuilt 1946 · S/N 178N80779Stein William R · Aptos, CABuilt 1946 · S/N 182N8077ESws Aviation Services Inc · Titusville, FLBuilt 1978 · S/N 17272133N8077H8077h LLC · Southington, CTBuilt 1979 · S/N 28-8090067N8077NRodgers Wesley T · Enterprise, ALS/N 28-25328N8077QWakefield Robert · Toccoa, GABuilt 1979 · S/N 28-8090069N8077RIscovich Mario S · Thousand Oaks, CABuilt 1979 · S/N 28-8090070N8077WN8077w Inc · Bloomfield Hills, MIBuilt 1979 · S/N 28-8090072N8077YMagenta Line LLC · Geneva, NYBuilt 1982 · S/N 32R-8213029N8078Tkg Aviation LLC · Denver, COBuilt 1977 · S/N 1-0054N80781P D H S Aerial Photography Inc · Spicewood, TXBuilt 1976 · S/N 17266745N80784Stamm David A · Lake Almanor, CAS/N 17266747N80785Campbell Air LLC · Angola, INBuilt 1979 · S/N 28-8090077N80788Bell Aa Flying Club Inc · Mechanicsburg, PABuilt 1976 · S/N 17266748N8078DStevenson William E · Sutton, AKBuilt 1957 · S/N 18-6061N8078PComanche Partners · Manhattan, MTFirst renewal noticeBuilt 1962 · S/N 24-3326N8078RKhozam George · Murrieta, CABuilt 1979 · S/N 28-8090073N8078ZL & A Bennett Second Family Lp · Renton, WAS/N 28-8090076N80790Wingsleasing LLC · Wichita, KSBuilt 1976 · S/N 17266749N80797Neitz Frank · Bethel, AKS/N 17266750N80798Thomas Dean Properties LLC · O Fallon, MOBuilt 1976 · S/N 17266751N8079JTd Aviation LLC · Canton, GABuilt 1978 · S/N 6005667961184N8079WFox Michael · Winfield, KSBuilt 1965 · S/N 28-2168N8079YKaszuba Peter M · Bradenton, FLBuilt 1979 · S/N 28-8016049N807ABSunward Aviation Services LLC · Merritt Island, FLS/N 31-8152183N807APTexas South Wind Aviation LLC · Kenedy, TXBuilt 1975 · S/N 28-7615086N807DAMays Gloriaj · College Station, TXBuilt 1977 · S/N 28-7816227N807DBAnderson Richard D · Trophy Club, TXBuilt 2019 · S/N 001N807EHLindsey Daniel Rey · Clovis, NMS/N 1242N807EJBaldmans Aircraft Services LLC · Wilmington, DES/N 18-3519N807FPM&A Industrial Construction LLC · Atkinson, NEBuilt 1977 · S/N 32R-7780518N807HDTubbs Jerry M · Manns Harbor, NCBuilt 1976 · S/N 17266730N807LELeading Edge Flight Academy LLC · Bend, ORBuilt 2005 · S/N 10807N807NVUnited Helicopter Leasing LLC · Honolulu, HIBuilt 1999 · S/N 0597N807RVMayerhofer Andrew M · Sugar Grove, ILBuilt 2004 · S/N 70604N807SPCawthon James B · Chelsea, ALBuilt 1999 · S/N 172S8111N807TATigersair LLC · Amityville, NYBuilt 1966 · S/N 24-4568N807TFAir Fleet Holdings LLC · Addison, TXBuilt 2024 · S/N 2881700N807TMLidija LLC · Grass Valley, CABuilt 1980 · S/N 61P08468163446N807WMGriswold George B III · Cedar Point, NCBuilt 1967 · S/N 28R-30186N807WTWindigo Transportation Inc · Waterloo, IABuilt 2017 · S/N CC19-0025N80800West Bend Air Inc · West Bend, WIBuilt 1976 · S/N 17266752N80803Bradley Charles S · East Bethel, MNS/N 17266754N80807Wings Over Texas Holdings LLC · Denton, TXS/N 17266755N8080AChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1979 · S/N 28-8016051N8080UMaas Justin J · Columbus, INBuilt 1977 · S/N 28R7737056N8080YEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1356
Back to AD 87-10-06 R1