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.

N6166DClb LLC · Boerne, TXBuilt 1957 · S/N 22-4813N6166JBorder Steven C · Wharton, TXBuilt 1976 · S/N 28-7615318N6166MBradley Aero Services Inc · Southwick, MABuilt 1978 · S/N 7178CN61670Registered aircraftBuilt 1975 · S/N 17264717N61671Charlotte Flyers Inc · Fort Myers, FLBuilt 1975 · S/N 17264718N61672American Patrols Inc · Midland, TXBuilt 1975 · S/N 17264719N61676Vectors LLC · Sterling, VABuilt 1975 · S/N 17264721N61677Morcom Aviation Services Inc DBA · Everett, WABuilt 1975 · S/N 17264722N6167KDuncan Marianna G · Lufkin, TXBuilt 2004 · S/N 18281379N6167LEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2004 · S/N 18281380N6167PRico Nathaniel J · Astoria, ORBuilt 1959 · S/N 24-1268N6167SHeaberlin Henry L · Corbin, KYBuilt 1965 · S/N 18-71N61680Kaye Linda · Grove, OKBuilt 1975 · S/N 17264724N61683Migdalski Randall C · Pembroke Pines, FLBuilt 1975 · S/N 17264727N61684Odyssey Aircraft LLC · Topeka, KSBuilt 1975 · S/N 17264728N61687Advanced Rehab Specialties Pa · Leesburg, FLS/N 17264731N61689Bc 414 LLC · Los Angeles, CABuilt 1975 · S/N 17264732N6168DMadison James E · Concord, CABuilt 1957 · S/N 22-4815N6168HWayne Air LLC · Collinwood, TNBuilt 1977 · S/N 32R-7880046N6168SFerrell William W II · Flagstaff, AZBuilt 1980 · S/N R18201635N6168VYoung Martin H II · Rogers, ARBuilt 1997 · S/N JC6N6168WSchwenning Donald R · Upper Sundusky, OHBuilt 1964 · S/N 28-20186N6168XKey Daemon S · Lexington, TNBuilt 1993 · S/N JC-4N6168YIngalls Donald H · Morgan Hill, CABuilt 1995 · S/N JC5N61692Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1975 · S/N 17264734N61696Bakker Margaret E Trustee · Petaluma, CABuilt 1975 · S/N 17264737N61697L&W Aircraft Investment LLC · Homestead, FLBuilt 1975 · S/N 17264738N61699Erickson Steve · St Michael, MNBuilt 1975 · S/N 17264740N6169PKlier John M · Alpine, CABuilt 1959 · S/N 24-1270N6169RN999gk LLC · Nantucket, MAS/N 172RG0102N6169YWiesen Enterprises Ltd · Empire, MIBuilt 1966 · S/N 27-3317N616AADowns Kenneth · Houston, TXBuilt 1975 · S/N 17265524N616ACN616ac LLC · Westfield, MABuilt 2021 · S/N 28020038N616ADArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843736N616AMMusson Brian D · Camas, WABuilt 2003 · S/N 60386N616AWAtd Pilot Training Lllc · Kansas City, MOBuilt 1976 · S/N 28-7790171N616CGPeterson Colin C · Plano, TXBuilt 2019 · S/N 01N616CNN616cn LLC · Spencer, INBuilt 2007 · S/N 26019CN616DMMoorman Jesse David · Centerville, IABuilt 2001 · S/N 25183N616ESDiamond Larry Michael · Galax, VABuilt 1999 · S/N 21067CN616FLFlight Gear Aviation LLC · Pickerington, OHBuilt 1971 · S/N 28-7125498N616HTWright S A Trustee · Cave Creek, AZBuilt 1993 · S/N 2811043N616JPWb Painting Contractors LLC · Greenville, MSBuilt 1967 · S/N 32-40420N616JWWilkinson Dane W · Morgan, UTS/N 5091N616KCN616kc LLC · Conway, ARBuilt 1975 · S/N M-1726N616LYPanzer Jessica DBA · Lincoln, NEBuilt 1980 · S/N J-B-2N616MCFletcher Flying LLC · Russellville, ARS/N 18281616N616PCPork Chop Aviation II LLC · Hilliard, OHBuilt 2023 · S/N 28020117N616RHangar 21 Aviation Inc · Orange, CABuilt 2005 · S/N 10787N616RSHubert Richard A · Fowlerville, MIBuilt 2012 · S/N 700
Back to AD 87-10-06 R1