OpenAirDocs.org
AD 86-06-08 R1

Registered aircraft · 491

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:86-06-08-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:86-06-08-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.

N6597DHeli Flite Inc · Corona, CAS/N 1017N665GDRegenald Michaud Avition LLC · Willows, CABuilt 1968 · S/N 6717N666SMLeading Edge Helicopter Service Inc · Cambridge, WIS/N (66-4292) 3533N6707DMines Keith A · White Cloud, MIBuilt 1958 · S/N 2187N6711DAnderson Christopher T · Janesville, WIBuilt 1958 · S/N 2192N6720DNorthwind Hilos LLC · Schoolcraft, MIBuilt 1958 · S/N 2204N6744DDyer Randall J · Frazier Park, CAS/N 2238N6749DCj Air LLC · Nezperce, IDBuilt 1959 · S/N 2240N6750DMorten Jesse L · Larimore, NDBuilt 1959 · S/N 2241N6758DCaruso Dennis · Saint Marys, PAS/N 2249N6774DSouthern Cross Aviation · Wilmington, DES/N 2450N6776DMilam Inc · Trussville, ALBuilt 1959 · S/N 2439N6784DNorth Coast Helicopter Svc Inc · Napa, CABuilt 1960 · S/N 2589N68645Advantage Helicopters LLC · White River, SDBuilt 1963 · S/N 2820N68GRMagnum Aviation LLC · Goff, KSS/N 7401N69GRMagnum Aviation LLC · Goff, KSS/N 8646N701GRMagnum Aviation LLC · Goff, KSS/N 7408N7024AHhi Farms LLC · Hamilton, MIBuilt 1972 · S/N 6855N703GRMagnum Aviation LLC · Goff, KSS/N 7406N7060JWilbur-Ellis Co · Salinas, CABuilt 1970 · S/N 25017N7081UHhi Farms LLC · Hamilton, MIS/N 1913N7137ZGreenway Michael D · Friday Harbor, WABuilt 1948 · S/N 19N715BHWilbur-Ellis Co · Salinas, CABuilt 1973 · S/N 25105N7162MFast Toys For Boys Inc · Wenatchee, WABuilt 1967 · S/N 7569N716WCN716wc LLC · Greenwood Village, COBuilt 1966 · S/N 6566N73207Hendrickson Flying Service Inc · Rochelle, ILBuilt 1962 · S/N 2697N73223Churchill Scott W · Le Sueur, MNBuilt 1962 · S/N 2722N73224C-Fleet LLC · Missoula, MTBuilt 1962 · S/N 2759N73228Wheatley Lester E Jr · Priest River, IDS/N 1862N73240Britton John E · Emmett, IDS/N 2772N73249English Air Service LLC · Georgetown, TXBuilt 1964 · S/N 2781N73269Costa James J · Goff, KSBuilt 1962 · S/N 2784N73279Mc Helicopter LLC · Summerfield, FLS/N 3134N73286Sze Alexander · San Francisco, CABuilt 1964 · S/N 2882N737MCCoggin Mark · Burleson, TXBuilt 1967 · S/N 7560N73903Tobler Hans P · Anchorage, AKS/N 2883N73905Fingerlakes Wing And Rotor LLC · Seneca Falls, NYBuilt 1963 · S/N 2860N73907Denlinger Darin · Modesto, CABuilt 1962 · S/N 2857N73909Dsm Inc · White City, ORBuilt 1962 · S/N 2797N73914N73914 Inc · Hobe Sound, FLBuilt 1963 · S/N 2800N73936Quatacker Matt A · Porterville, CABuilt 1963 · S/N 2811N73943Green Rick A · Hudson, IAS/N 2862N73953Ritel Copter Service Inc · Hudson, IABuilt 1963 · S/N 2866N73960Celebrate Freedom Foundation Inc · West Columbia, SCS/N 2839N73965Nockair Helicopters Inc · Longboat Key, FLBuilt 1963 · S/N 2831N73966Forbis Michael J · Calera, OKS/N 2871N73974Triple F Flying Inc · Benton, PABuilt 1964 · S/N 2874N73985City Of Los Angeles · Van Nuys, CABuilt 1963 · S/N 2894N73998Heli-Works Flight Services LLC · Deer Lodge, MTBuilt 1964 · S/N 2902N74004House Guy C · Castle Creek, NYBuilt 1951 · S/N 403
Back to AD 86-06-08 R1