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.

N9568Medic Choppers LLC · Springdale, ARBuilt 1972 · S/N 091N9568CMitchell Stephen D · Wichita, KSBuilt 1978 · S/N 28-7890423N9568GTakai Hiroyasu · San Jose, CABuilt 1979 · S/N 17273631N9568JJeep Kenneth M · Wadsworth, ILBuilt 1998 · S/N 18280275N9568LD & S Aviation LLC · Spring, TXBuilt 1986 · S/N 17276580N9568MKinney William A · Missouri City, TXBuilt 1966 · S/N 670145N9568URegistration Pending · Bath, PARegistration pendingBuilt 1975 · S/N AA5A-0068N9568VAnderson Zachery D · Bigfork, MTBuilt 1974 · S/N 17264370N9568WSale Reported · Cimarron, KSSale reportedBuilt 1967 · S/N 28-23006N95690Daly Arthur P · El Paso, TXBuilt 2004 · S/N 101N9569FClassic Helicopter Corp · Auburn, WABuilt 1971 · S/N 310461N9569HOsborn Larry R · Summerville, SCBuilt 1975 · S/N 17266235N956ACJpe Aviation LLC · Fairview, TXBuilt 1999 · S/N 3257109N956CFHighwind Aero LLC · Inyokern, CABuilt 2002 · S/N 18281075N956CRCreamer Michael · Miami, FLBuilt 2002 · S/N 3257294N956DCLefthalfplane LLC · Kalispell, MTBuilt 2004 · S/N 752EN956GTTargonski Gregory · Williamson, GABuilt 2013 · S/N 91433N956JBJ Robb Consulting LLC · Scottsdale, AZBuilt 2004 · S/N 40.390N956LBStark Robert C · Hillsboro, ORBuilt 2016 · S/N CCK-1865-0036N956MAAllen William D · Tampa, FLBuilt 1966 · S/N 3431N956MDDigit Aviation LLC · Hampton, NHBuilt 1956 · S/N 18-4884N956PMSparks James D · Glennallen, AKBuilt 2015 · S/N CH1502N956RHHuston Ben E · Sanger, TXBuilt 2006 · S/N 510-2007N956RVKemph Jeffrey A · Howell, MIBuilt 2008 · S/N 91131N956SLLittle James S · Douglass, TXBuilt 1977 · S/N 846N956SPN3812q LLC · San Diego, CABuilt 1999 · S/N 172S8156N956TAAir Corriente LLC · Wilmington, DEBuilt 2014 · S/N 2380N956TERaw Logistics LLC · Bethel, NCBuilt 2004 · S/N 10235N9570AUpper Fifteen Inc · Latham, NYBuilt 1998 · S/N 18280286N9570JCharlie November Romeo LLC · Denver City, TXBuilt 1966 · S/N 28-3707N9570UFranken Todd V · Martindale, TXBuilt 1975 · S/N AA5A-0070N9570VAwp Holdings LLC · Murphysboro, ILS/N 18280285N9571HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266236N9571JMeunier Barry · Rehoboth, MABuilt 1966 · S/N 28-3708N9571KOtter Fly LLC · Maricopa, AZS/N 28-7615213N9571MSale Reported · Sacramento, CASale reportedBuilt 1966 · S/N 670148N9571VTempleton John E · Loami, ILBuilt 1974 · S/N 17264373N9572AEagle Eye Marketing LLC · Reno, NVBuilt 1998 · S/N 18280279N9572HGeneral Aviation LLC · Henderson, NVBuilt 1975 · S/N 17266237N9572LJav Air Services LLC · Anchorage, AKBuilt 1986 · S/N 17276582N9572VHill Timothy E · Hooks, TXBuilt 1974 · S/N 17264374N9572WDr Equipment LLC · Ackerly, TXBuilt 1998 · S/N 17280544N9573Styer David B · Pendleton, ORBuilt 1972 · S/N 131N9573BDocarmo Aviation LLC · Dallas, TXBuilt 1981 · S/N 172RG0890N9573LCrosetto Pierre F · Downey, CABuilt 1974 · S/N AA5-0573N9573MAndrews Geoffrey M · Stoneham, MABuilt 1966 · S/N 670150N9573PAerial Banners Inc · Pembroke Pines, FLBuilt 1974 · S/N 25-7405683N9573SOppegard Nicholas D · Eagle River, AKBuilt 1966 · S/N 66N9573VReynolds Darryl G · Wills Point, TXBuilt 1974 · S/N 17264375N9573WPyxl Sky LLC · Cogan Station, PABuilt 1967 · S/N 28-23013
Back to AD 87-10-06 R1