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.

N44SGStaten Island Helicopters Inc · Staten Island, NYBuilt 1965 · S/N 2945N4550WNewton Property Leasing LLC · Greene, IABuilt 1960 · S/N 2460N468HASkotz Helicopter Services LLC · Bertram, TXBuilt 1967 · S/N 7870N4702SAd-Air And Ag LLC · Dothan, ALS/N B-101RN47038Harker Rulon · Enterprise, UTBuilt 1968 · S/N 3827N4705RRitel Copter Service Inc · Hudson, IAS/N 7911N470BHBell Textron Inc · Fort Worth, TXS/N 7706N470SBMidwest Choppers LLC · Colman, SDS/N 2254N470WWWorld Trade Enterprises LLC · Lucas, TXS/N 3719N471BHRocky Mount LLC · Kalispell, MTBuilt 1960 · S/N 2558N472DMMcdowell David M · El Cajon, CABuilt 1963 · S/N WH5007N472GDDunn Gary M · Galesburg, MIBuilt 1953 · S/N 988N4731RTiny Dog Aviation Ltd · Gambier, OHBuilt 1967 · S/N 6719N4733RBackwoods Construction Inc · Montrose, COS/N 6722N473TTJj Aviation LLC · Missoula, MTBuilt 1968 · S/N 3730N4741RWilbur-Ellis Co · Salinas, CAS/N 7917N474JPLake Norman Air Tours LLC · Mooresville, NCBuilt 1970 · S/N 7725N474RPEcho Matrix LLC · Bentonville, ARBuilt 1965 · S/N 3344N4757RScotts Helicopter Service · Le Sueur, MNBuilt 1969 · S/N 6726N4759RPeak Performance Helicopters LLC · Dover, DES/N 6728N475ALScotts Helicopter Service Inc · Le Sueur, MNBuilt 1968 · S/N 6675N47713Cornerstone Financial Enterprises LLC · Mesquite, NVBuilt 1965 · S/N 2954N4771ZScotts Helicopter Service Inc · Le Sueur, MNS/N 2236N4774CScotts Helicopter Service Inc · Le Sueur, MNS/N 2237N4798RTriple F Flying Inc · Benton, PABuilt 1968 · S/N 7925N47AHScotts Helicopter Services Inc · Le Sueur, MNBuilt 1961 · S/N 2645N47CSTropicalproperties LLC · Lewes, DEBuilt 1958 · S/N 2255N47EDCornerstone Financial Enterprises LLC · Mesquite, NVBuilt 1972 · S/N 1227N47GQMccoy Robert M · Barksdale, TXS/N 2196N47GRMurphy Airport Inc · Amsterdam, NYBuilt 1974 · S/N 3423N47HSJames David R · Wayne, MIBuilt 1956 · S/N 883N47JAGws Holdings LLC · Mount Vernon, IABuilt 1966 · S/N 3580N47LBMagnum Aviation LLC · Goff, KSBuilt 1974 · S/N 3837N47MHWheatley Lester E Jr · Priest River, IDS/N 2025N47PDGuardian Helicopters Inc · Fillmore, CAS/N 6610N47VVWorthett LLC · Englewood, COBuilt 1967 · S/N 6604N47WFCantarini Cody M · Fallbrook, CABuilt 1966 · S/N T-610N47ZAGanuza Diego · North Miami Beach, FLBuilt 1956 · S/N 1533N48020Ugalde Chester M · Fallon, NVBuilt 1967 · S/N 2812N48131Zimpel Kurt S · Hinckley, MNBuilt 1967 · S/N 3641N481RDSchwam Julie R · Hayden, IDS/N 6716N48217Scotts Helicopter Services Inc · Le Sueur, MNS/N 2760N48316Hammock Flying Service Inc · Smithville, ARBuilt 1966 · S/N 3628N4990HScotts Helicopter Services · Le Sueur, MNBuilt 1964 · S/N 2942N500ENNockair Helicopters Inc · Longboat Key, FLBuilt 1965 · S/N 2955N50HBDyer Randall J · Frazier Park, CAS/N 3063N50SDLouisville Aviation LLC · Louisville, KYBuilt 1965 · S/N 3458N514HEJohnson Flying Service LLC · Exira, IABuilt 1968 · S/N 7654N5162BK D Helicopters Inc · Shingleton, MIBuilt 1957 · S/N 1980N5167BStills Inc · Ashville, ALBuilt 1957 · S/N 1996
Back to AD 86-06-08 R1