OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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-08-08-R3')
    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-08-08-R3')
  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.

N83076N83076 LLC · Wayne, PABuilt 1980 · S/N 28-8116102N8307LStraight Arrow LLC · Chicago, ILS/N 28R-8118034N8307RKlingerman Chester E Jr · Plymouth, INBuilt 1966 · S/N 28-22176N8307WPeden Travis Austin · Sheridan, WYBuilt 1965 · S/N 28-2476N8307YParis Air Inc · Vero Beach, FLBuilt 1980 · S/N 28-8116100N83089Mountz James M · Birmingham, ALBuilt 1980 · S/N 32-8106025N8308CN8308c LLC · Haymarket, VABuilt 1975 · S/N 28-7690113N8308LClassic Wings · Westlake Village, CAS/N 28-8316017N8308MGfl Aircraft Leasing Corp · Glens Falls, NYBuilt 1980 · S/N 32-8106020N8308RClassic Flyers Club Inc · Hastings, NEBuilt 1966 · S/N 28-22177N8308VCleary Paul D · Guilford, CTBuilt 1980 · S/N 32R-8129016N8308WSchlenker Richard A · Meeteetse, WYBuilt 1965 · S/N 28-2478N8309ASchmidtys Air LLC · Stuart, FLBuilt 1980 · S/N 32-8106026N8309EPlanewright Inc · Newberg, ORBuilt 1983 · S/N 28-8390013N8309KClaridge Michael A · Houston, TXBuilt 1982 · S/N 28-8390015N8309RPipal Cory J · Dublin, TXBuilt 1966 · S/N 28-22179N8309XHaluska Victor · Boca Raton, FLS/N 28-8111034N830BVRegistration Pending · Manhattan, MTRegistration pendingBuilt 1979 · S/N 28-7911289N830PColeman Nathan R · Zephyrhills, FLBuilt 1964 · S/N 28-20554N830PCSprowl Brian M · Millville, NJS/N 28R-7335055N830RCMartin Douglas J · Lutz, FLBuilt 1964 · S/N 28-20558N830SCFf22 LLC · Scottsdale, AZS/N 2881715N830TCRegistered aircraftBuilt 1980 · S/N 32R-8113016N83107Second Chance Aviation LLC · Scenery Hill, PAS/N 32R-8129020N8310HPettit Brian K · Wshngtn Ct Hs, OHBuilt 1982 · S/N 32-8306009N8310WBennett Anthony W · Bradenton, FLBuilt 1965 · S/N 28-2482N8310YRegistration Pending · Kansas City, MORegistration pendingBuilt 1981 · S/N 32R-8113025N83113N83113 LLC · Liberty, NCBuilt 1981 · S/N 28-8116110N8311CProficient Computing Solutions Corp · Fernandina Beach, FLBuilt 1975 · S/N 32R-7680092N8311KEnt Flight Services LLC · Santa Margarita, CABuilt 1982 · S/N 32-8324003N8311LSimpson Robert B · South Pasadena, CABuilt 1980 · S/N 28-8116104N8311NMcallister Joshua R · Gig Harbor, WABuilt 1982 · S/N 32-8324004N8311WAlford Charles Mikael · Meadow Valley, CABuilt 1965 · S/N 28-2483N83126Ttl Aviation LLC · Lexington, KYBuilt 1980 · S/N 28-8111035N8312AToro Aero LLC · Calabasas, CABuilt 1982 · S/N 32R-8313002N8312HAlameda Aero Club · Alameda, CABuilt 1982 · S/N 28-8316020N8312PPerson Timothy Ivan · Lake Stevens, WABuilt 1980 · S/N 28-8190123N8312WGillen James A · Cornville, AZBuilt 1965 · S/N 28-2484N8313ACarter Donald R Jr · Nebo, NCBuilt 1980 · S/N 28-8111041N8313RCardinal Flyers Inc · Stuart, FLBuilt 1980 · S/N 28R-8118041N8313TBehnfeldt Barry W · Napoleon, OHBuilt 1980 · S/N 32R-8113026N8313WLummus Brett D · Forney, TXBuilt 1965 · S/N 28-2486N8314BSchultens Robert R Trustee · The Dalles, ORBuilt 1980 · S/N 32R-8129021N8314CR M W LLC · Florence, SCBuilt 1975 · S/N 32-7600007N8314KRed Dirt Retreat LLC · Colorado Springs, COBuilt 1980 · S/N 32R-8129023N8314WWingsleasing LLC · Wichita, KSBuilt 1965 · S/N 28-2487N8315BRobins Air Force Base Aero Club · Robins Afb, GABuilt 1980 · S/N 28R-8118037N8315HKing 90 LLC · Milwaukie, ORBuilt 1982 · S/N 32-8124028N8315SMagneto Consulting LLC · Grayslake, ILBuilt 1980 · S/N 28R-8131044N8315WJg Aero LLC · Smyrna, DEBuilt 1965 · S/N 28-2488
Back to AD 87-08-08 R3