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.

N8971DThomas James W · Jay, FLBuilt 1958 · S/N 18-6408N8971JSwearingen Louis S · Summerfield, FLBuilt 1965 · S/N 28-2994N8971PDerrel Luce Pc · Waco, TXBuilt 1966 · S/N 24-4428N8971VGibson Aviation Services LLC · Hudson, WIBuilt 1974 · S/N 17264327N8971YLaubscher John E · Cazenovia, NYBuilt 1972 · S/N 39-134N89721Propability One LLC · Daytona Beach, FLBuilt 1983 · S/N 17276010N8972CBosn Richard O · Scottsbluff, NEBuilt 1976 · S/N 28-7690174N8972DClarke Timothy B · Howard, SDBuilt 1958 · S/N 18-6411N8972JPascua Jonathan J · Coventry, RIBuilt 1966 · S/N 28-2995N8972PHardy Douglas · Lakewood, CABuilt 1966 · S/N 24-4429N8972VPearce Michael J · Phoenix, AZBuilt 1974 · S/N 17264328N8972WIma Pilot LLC · Sauk Rapids, MNBuilt 1964 · S/N 28-10550N8973DSnider Scott E DBA · Turner, MTBuilt 1958 · S/N 18-6412N8973FAvelan Enterprises Inc · Elm Grove, LABuilt 1973 · S/N 430195N8973JMuleshoe Flight Club LLC · Muleshoe, TXBuilt 1965 · S/N 28-2996N8973PBrockwell Derrell Randel · Oakland, TNBuilt 1966 · S/N 24-4430N8973VOcean Flyers LLC · Chatham, NJBuilt 1974 · S/N 17264329N8973WPlasek Christopher · Owatonna, MNBuilt 1966 · S/N 28-10810N8973YAire Ryder LLC · Roseville, MNS/N 39-139N8974P4papa LLC · Gig Harbor, WABuilt 1966 · S/N 24-4432N8974WRassmussen Troy · Fayetteville, NCBuilt 1966 · S/N 28-10811N8975VMauser James E · Zionsville, PABuilt 1974 · S/N 17264331N8976Bouchard Paul Marcel · Yellville, ARBuilt 1998 · S/N 3318N8976DWilliams Aircraft LLC · Anchorage, AKBuilt 1956 · S/N 18-4887N8976JGreat Plains Aviation LLC · Lincoln, NEBuilt 1966 · S/N 28-2999N8976YAfricano Aircraft Management LLC DBA · Chicago, ILS/N 39-142N8977DWilliams Aircraft LLC · Anchorage, AKBuilt 1956 · S/N 18-5083N8977JJohnson Bradley F · West Babylon, NYBuilt 1966 · S/N 28-3000N8977PWarrior Up LLC · Clayton, NCBuilt 1966 · S/N 24-4435N8977RCozine Mark R · Cherokee, IABuilt 1960 · S/N 7KC-1N8977WRice Elden · Black Hawk, SDBuilt 1965 · S/N 28-10555N8978DShuman Cecil R Trustee · Chugiak, AKBuilt 1958 · S/N 18-6418N8979DBurnett Kris W · Anchorage, AKBuilt 1975 · S/N 18-7509053N8979MBean George W Jr · Fort Worth, TXBuilt 1964 · S/N TD-564N8979NPeeling Clyde R · Allenwood, PABuilt 1969 · S/N 32-40862N8979PShortridge Mary E · Bennet, NEBuilt 1966 · S/N 24-4438N8979RSeeley Lenard D · Osage, WYBuilt 1960 · S/N 13N8979VAvel Aircraft Inc · West Chicago, ILBuilt 1974 · S/N 17264335N897ALJansky Sand & Gravel Inc · Hallettsville, TXBuilt 1973 · S/N 28R-7335331N897DCRed Baron LLC · Middletown, DES/N 20012CN897DSHolliday Richard A · Fort Worth, TXBuilt 1996 · S/N 1928N897ECMatacia Thomas Eugene · Evergreen, NCBuilt 1969 · S/N 28R-35376N897GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881072N897GAPruim Bradley · Dorr, MIBuilt 1991 · S/N 10076N897HParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020244N897JSMurray James P · Parrish, FLBuilt 2004 · S/N 90430N897JWAmh Properties LLC · Auburn, ALFirst renewal noticeBuilt 2011 · S/N 2843698N897MGlenn David H · Big Lake, AKBuilt 1989 · S/N 4064CN897MAPate Jimmy B · Fredericksburg, TXBuilt 1997 · S/N 3246083N897MBJts Aircraft LLC · Rock Hill, SCBuilt 1966 · S/N 28-21978
Back to AD 87-10-06 R1