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.

N80711Adsit John · Cambridge, WIS/N 3815N80SQWatkins Arlo S · Chandler, AZBuilt 1959 · S/N 2522N8103JTriple F Flying Inc · Benton, PABuilt 1970 · S/N 25001N8117Henry Mark A · Dickinson, TXBuilt 1967 · S/N K732N8125JGreen Rick · Hudson, IABuilt 1970 · S/N 25004N8135JWilbur-Ellis Co · Salinas, CABuilt 1972 · S/N 25060N8140JGreen Rick A · Hudson, IABuilt 1970 · S/N 25008N8161KSale Reported · Pendleton, ORSale reportedBuilt 1969 · S/N 6743N8185JCosta James J · Goff, KSBuilt 1972 · S/N 6827N821CChase Michael S · Port Orange, FLBuilt 1966 · S/N 6571N8236Horey Scott R · Ione, CABuilt 1955 · S/N 1333N828JLMartinez Ejarque Pablo · Cottonwood, CAS/N 7687N83111Tobler Hans P · Anchorage, AKS/N 6857N8403EChurchill Scott W · Le Sueur, MNBuilt 1960 · S/N 2257N8409ED'Agostino Gerald J · Middleburg Hts, OHBuilt 1960 · S/N 2603N8413DExperimental Aircraft Association Inc · Oshkosh, WIS/N 25091N8424EWheatley Lester E Jr · Priest River, IDS/N 1802N8428EWheatley Lester Edward Jr · Woodcrest, CAS/N 2476N8440ELand Air Enterprises · Boynton Beach, FLBuilt 1960 · S/N 2657N8441EShore Stephen A · Elkin, NCBuilt 1960 · S/N 2609N8452EMagnum Aviation LLC · Goff, KSBuilt 1962 · S/N 2752N8465EEnglish Air Service LLC · Georgetown, TXBuilt 1961 · S/N 2641N8468EScotts Helicopter Services Inc · Le Sueur, MNS/N 2647N846MScotts Helicopter Services · Le Sueur, MNBuilt 1967 · S/N 3770N8478DWood Denton A · Friendswood, TXBuilt 1957 · S/N 1697N8478HBertiling Brad · North Shore, CABuilt 1958 · S/N 2214N8478LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1963 · S/N 3339N8478TLand Sea Air Leasing Corp · Ward Cove, AKBuilt 1971 · S/N 7754N8483EOwens Jeffrey H · Danville, ILBuilt 1961 · S/N 2650N8484EOver The Top Aviation Inc · Jonesboro, ARBuilt 1961 · S/N 2677N8486EBrothers Aviation LLC · Black Rock, ARS/N 2679N8489EQuatacker Mike · Porterville, CABuilt 1961 · S/N 1846N8492EBrooke Ash Inc · Waxahachie, TXBuilt 1961 · S/N 2714N8509FTobler Hans P · Anchorage, AKS/N 3381N8518ZHenry Mark A · Dickinson, TXBuilt 1981 · S/N 47-1980N8520HVegas Baby! Lc · Royal Oak, MIBuilt 1980 · S/N OLYMPIC-01N8522FHhi Farms LLC · Hamilton, MIBuilt 1971 · S/N 7800N8542DScotts Helicopter Services Inc · Le Sueur, MNBuilt 1966 · S/N 3546N8552FBhh Leasing #4 LLC · Pensacola, FLS/N 3705N8554FScotts Helicopter Services Inc · Le Sueur, MNBuilt 1966 · S/N 6508N855ETobler Hans P · Anchorage, AKS/N 41N8562FWilbur-Ellis Co · Salinas, CABuilt 1966 · S/N 7806N8585FUSA Helicopter Inc · West Winfield, NYS/N 3725N8593FTriple F Flying Inc · Benton, PABuilt 1966 · S/N 7820N8645GTobler Hans P · Anchorage, AKBuilt 1953 · S/N 822N86SDYoung Randall K · Clearwater Beach, FLBuilt 1973 · S/N 25118N88754Skypro Industries Inc · Jacksonville, FLBuilt 1953 · S/N 601N88755Old Time Ag Aviation LLC · Bakersfield, CAS/N 2252N88ARLumley William B · Delray Beach, FLBuilt 1957 · S/N 2046N8975Gauntlett Robert Michael · Yukon, OKS/N 607
Back to AD 86-06-08 R1