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.

N9246JMckool John Jr · Johnstown, PABuilt 1966 · S/N 28-3321N9246KN9246k Corp LLC · Federal Way, WAFirst renewal noticeBuilt 1976 · S/N 28-7615189N9246MShenkirsch Consulting Inc · Mammoth Lakes, CABuilt 1993 · S/N 4622149N9246PSharp Paul C · Modesto, CABuilt 1967 · S/N 24-4745N9246VBibbs Kevin · Copperas Cove, TXS/N 690063N92471Shoemaker Floyd · Oneida, TNS/N 17261579N9247DLaw C Scott · Oklahoma City, OKBuilt 1958 · S/N 22-6307N9247ELeigh William L · Minonk, ILBuilt 1977 · S/N 7145CN9247JGreco Timothy F · Sewell, NJBuilt 1966 · S/N 28-3322N9247LGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N 31-8152160N9247PEhrenberg David G · Corning, NYBuilt 1968 · S/N 24-4746N9247YWest Bend Air Inc · West Bend, WIBuilt 1968 · S/N 31-322N9248KGerstner Michael J · Ola, ARBuilt 1976 · S/N 28-7690236N9248MTaylor Douglas W · Tucson, AZBuilt 1966 · S/N 1197N9248PPajaro Jaison · Burtonsville, MDBuilt 1966 · S/N 24-4627N9248VBoardman Thomas M · Greenwich, NYBuilt 1969 · S/N 690068N9248WMeyers Andrew W · San Ramon, CABuilt 1967 · S/N 28-10918N9249EThomas Howard M · Hernando, MSBuilt 1977 · S/N 7146CN9249HGencur Paul A · Hudson, OHBuilt 1975 · S/N 17266044N9249MMaverick Aviation LLC · Richmond, KYBuilt 1966 · S/N 1198N9249VRobertson Scot H · Tribune, KSBuilt 1969 · S/N 690064N924CCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1966 · S/N 27-3490N924CSBeinhauer Emerson R · Naperville, ILBuilt 1992 · S/N 1N924DLester Christopher J · Vancouver, WABuilt 1994 · S/N 001N924DBFlying Veterans Club Of San Francisco Inc · Belmont, CABuilt 1973 · S/N 28-7305198N924DCAirmann Leasing LLC · Mount Sterling, KYBuilt 1996 · S/N 4636057N924DMSmoketown Helicopters LLC · Smoketown, PABuilt 2002 · S/N 1253N924DWLive Free And Fly Hard LLC · Santa Cruz, CABuilt 1988 · S/N WOOD-0001N924EIzzard William S · Crescent City, FLBuilt 1996 · S/N 002N924JHSmith Nigel A · Winona, MNBuilt 2007 · S/N 3FX034N924JLGross John L · Carthage, MSBuilt 2015 · S/N 4580N924JPProck Jack A · Auburn, CABuilt 2014 · S/N 3RX128N924JWStephenson James M Jr · Hyampom, CABuilt 2000 · S/N 860-2000N924KAEvanoff Mark Alan · Saint Augustine, FLBuilt 1965 · S/N 28-21295N924MCJ Airco LLC · Nashville, TNBuilt 1985 · S/N 17276509N924NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881886N924PLWilliamson Jay S · Phoenix, AZBuilt 2017 · S/N 36-67/68-749N924RRHigh Timothy Duane · Glenwood, MOBuilt 1977 · S/N 32R-7780450N924SHHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2005 · S/N 3871N924SJRickets And Associates LLC · Ardmore, OKBuilt 2019 · S/N 91838N924TEPlyler Robert S · Spring, TXBuilt 2002 · S/N 10203N924TFRegistered aircraftBuilt 1996 · S/N 27-0218N92500Romeo Charlie Aviation LLC · Stuart, FLBuilt 1994 · S/N 2890207N92505Thunderbird Aviation Inc · Bloomington, MNBuilt 1994 · S/N 2890211N9250CRegion Flyers LLC · Valparaiso, INBuilt 1978 · S/N 28-7816451N9250DJouflas Nikos A · Anchorage, AKBuilt 1958 · S/N 18-6541N9250PBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 24-4747N92511Mckay Donald A · Soldotna, AKS/N 12-34N9251EArrowpoint Investments LLC · Mountain Brk, ALBuilt 1994 · S/N 3213084N9251JGholami Amir K · Santa Rosa, CABuilt 1966 · S/N 28-3326
Back to AD 87-10-06 R1