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.

N22SHBryan Robert C · Waller, TXBuilt 1952 · S/N 52-7953N237DJJames David R · Wayne, MIS/N 237N238WFStaas Justin · Sacramento, CAS/N 2926N24067Pearce Michael J · Phoenix, AZBuilt 1953 · S/N 1220N2469BKothman Kenn Kode · Sheffield, TXS/N 1446N2473BKerr Douglas E · Oakland, CABuilt 1955 · S/N 1450N2476BClaridge Joseph M · Somis, CABuilt 1956 · S/N 1365N247WWildhorse Helicopter Co Inc · Pendleton, ORBuilt 1968 · S/N 6683N2480BWillert Fred J · San Diego, CABuilt 1955 · S/N 1360N2490BExperimental Acft Assoc Inc · Oshkosh, WIBuilt 1956 · S/N 1516N24MPWildhorse Helicopters Inc · Pendleton, ORBuilt 1972 · S/N 6836N2507X4 Star Aviation Inc · Jefferson City, MOS/N 6073N250894 Star Aviation Inc · Jefferson City, MOS/N 6078N2508K4 Star Aviation Inc · Jefferson City, MOS/N 6076N2509F4 Star Aviation Inc · Jefferson City, MOS/N 6080N255PHEgenolf Evan Patrick · Laramie, WYS/N 3307N256SWMountain 47 LLC · Boulder, COS/N 6754N257PCPinellas County · Clearwater, FLBuilt 1972 · S/N 25077N25LBScotts Helicopter Services Inc · Le Sueur, MNBuilt 1972 · S/N 25102N25SDArgosy Venture Corp · Santa Fe, NMBuilt 1968 · S/N 3747N2618WEnglish Air Service LLC · Georgetown, TXBuilt 1966 · S/N 6580N2625NRuggles Don C · Texarkana, ARS/N 66-8130N262MVCavanaugh Charters Inc · Addison, TXBuilt 1958 · S/N 2232N2795AMiles Flying Service Inc · Bono, ARS/N 471N2801BTaz Air Service Inc · Middletown, DES/N 1526N2802BN2802b LLC · Crestview, FLS/N 1527N2806BHeliflight Leasing LLC · Bulverde, TXBuilt 1956 · S/N 1490N2807BSuess Robert D · San Jose, CABuilt 1956 · S/N 1495N2814BC-Fleet LLC · Missoula, MTBuilt 1956 · S/N 1528N2817BNew Air Inc · Pocahontas, IABuilt 1956 · S/N 1500N2821BLumley William B · Delray Beach, FLBuilt 1956 · S/N 1530N2822BEnglish Air Service LLC · Georgetown, TXBuilt 1956 · S/N 1470N2823BGulf Helicopters LLC · Santa Fe, TXBuilt 1956 · S/N 1471N2831BTaz Air Service Inc · Middletown, DEBuilt 1957 · S/N 1361N2838BBlessed Beginnings Broadcasting Inc · Warsaw, INBuilt 1957 · S/N 1424N285TTValiair Lc Trustee · Casper, WYBuilt 1971 · S/N 7746N2861BScotts Helicopter Service Inc · Le Sueur, MNBuilt 1958 · S/N 1436N2862BGraulich David A · Sharon Springs, NYBuilt 1957 · S/N 1689N2870BBell Homer K · Hillsboro, OHBuilt 1957 · S/N 1975N2890BBolton Air Co · Niles, MIBuilt 1957 · S/N 1565N2891BCosta James J · Goff, KSBuilt 1957 · S/N 1535N2895BA And S Helicopters Inc · Cahokia, ILBuilt 1957 · S/N 1572N2899BClassic Rotors Museum · Ramona, CAS/N 1999N290SSMagnum Aviation LLC · Goff, KSS/N 2929N2918WScotts Helicopter Service Inc · Le Sueur, MNBuilt 1971 · S/N 6822N2985WWildhorse Helicopter Company Inc · Pendleton, ORBuilt 1972 · S/N 6840N2988WScibelli Christopher S · Southwick, MABuilt 1972 · S/N 25069N2993WGribben James E · Bakersfield, CABuilt 1972 · S/N 25074N29GRMagnum Aviation LLC · Goff, KSS/N 7409N300JGBamford Virginia J · Woodside, CAS/N 2026
Back to AD 86-06-08 R1