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.

N302JP123 Investments LLC · Clare, MIS/N 3582N3065GLombardo James · Olympia, WABuilt 1964 · S/N 2913N3068GWheatley Lester E Jr · Riverside, CAS/N 2856N3079GNockair Helicopters Inc · Longboat Key, FLBuilt 1964 · S/N 2921N307KCEgenolf Evan Patrick · Laramie, WYBuilt 1972 · S/N 25065N3080GBouchard Gerald K · Stacyville, MES/N 2923N3081GScotts Helicopter Service Inc · Le Sueur, MNBuilt 1964 · S/N 3153N3094GScotts Helicopter Services Inc · Le Sueur, MNBuilt 1965 · S/N 3361N3103GLancaster Helicopters Inc · Landisville, PABuilt 1959 · S/N 185N31052Scotts Helicopter Services Inc · Le Sueur, MNBuilt 1964 · S/N 2934N3105GClassic Rotors Museum · Ramona, CABuilt 1958 · S/N 1875N310AAnverse Inc · Cartersville, GABuilt 1947 · S/N 82N310SSOlathe Spray Service Inc · Olathe, COBuilt 1964 · S/N 3000N3116GAlvis Michael E · Parkton, NCS/N 284N31FGCoastal Helicopters Inc · Panama City, FLBuilt 1968 · S/N 3834N3285TWilbur-Ellis Co · Salinas, CABuilt 1969 · S/N 7964N32FGHd Helicopter LLC · Las Vegas, NVBuilt 1967 · S/N 3838N333TVChap Jerry L · Patagonia, AZBuilt 1965 · S/N 3305N33507Gooney Bird Group Inc Non Profit Corp · Templeton, CABuilt 1953 · S/N 1088N3358FPietron Chad D · Larimore, NDBuilt 1976 · S/N 2497N347BHGonzalez Richard · Seffner, FLBuilt 1962 · S/N 2771N347WMLancaster Helicopters Inc · Landisville, PAS/N 61N35134Scibelli Daniel A · Southwick, MAS/N 3591N360SSCounty Line Helicopter Inc · Nehawka, NES/N 3696N3657FDouglas Helicopter Inc · Douglas, GABuilt 1959 · S/N 900N368GRBetsi Bell Inc · Jacksonville, ARS/N 1258N3740GSkypro · Jacksonville, FLS/N 461N3755JSpinney Jeffrey James · Flushing, MIBuilt 1958 · S/N 1537N391HPDuval Ronald J · South Dartmouth, MAS/N 3649N3951UWheatley Lester E Jr · Priest River, IDS/N 1376N39WLMinnesota Military And Veterans Museum · Little Falls, MNS/N 514N4017GHjertager Harold D · Anderson, CABuilt 1968 · S/N 6677N4029GWildhorse Helicopters Inc · Pendleton, ORBuilt 1968 · S/N 6700N405HHGuardian Aviation LLC · Lakeland, FLS/N 2417N4070BWheatley Lester E Jr · Priest River, IDS/N 1812N4074GClassic Rotors Museum · Ramona, CAS/N 6704N4077Cavanaugh Flight Museum · Denison, TXBuilt 1965 · S/N 3473N4096GWilbur-Ellis Co · Salinas, CABuilt 1968 · S/N 7906N4097GTriple F Flying Inc · Benton, PABuilt 1968 · S/N 7907N4100GRegenald Michaud Aviation LLC · Willows, CABuilt 1968 · S/N 7910N4115ADobalian Vaughn E · Jacksonville Beach, FLBuilt 1957 · S/N 1084N415DPAntique Airlift LLC · Mokena, ILBuilt 1947 · S/N 20N4250AIxl Inc · Sulphur, LAS/N 421N4262YSwift Horse Wj LLC · Fredericksburg, TXBuilt 1965 · S/N 7674N4348PWilbur-Ellis Co · Salinas, CAS/N 25059N440TGScotts Helicopter Service Inc · Lesueur, MNBuilt 1959 · S/N 2245N4419ERatledge Thomas D · Bethel, AKS/N K651N4423Matthews Kenneth R · Santo, TXBuilt 1967 · S/N 295N4427PPike Mark D · Victorville, CABuilt 1958 · S/N 2227N444EHJohafe Aviation LLC · Wilmington, DEBuilt 1959 · S/N 2421
Back to AD 86-06-08 R1