OpenAirDocs.org
AD 89-08-06

Registered aircraft · 58

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:89-08-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-08-06')
  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.

N1022QAmerican Huey 369 Inc · Peru, INBuilt 1964 · S/N 64-14049N102FWSierra Aeronautics LLC · Franklin, KYS/N 62-1905N11NENorthern X Treme Helicopters Inc · Gridley, CABuilt 2001 · S/N 63-13086N137USThomas Aviation LLC · Orleans, CABuilt 1965 · S/N 151874N154TLJtbam Inc · Lakeside, AZBuilt 1988 · S/N 154770N155TLTwo Roan Ranch LLC · Salem, ORBuilt 1967 · S/N 154779N1MXWsh LLC · Palmer, AKS/N 62-01995N204BSIntermountain Helicopters Inc · Cottage Grove, ORBuilt 1963 · S/N 63-8699N204DSGreenwood Helicopters Inc · Washington, NCBuilt 1960 · S/N 60-3594N204DXFarwest Aviation LLC · Billings, MTS/N 61-787N204GPJones Aviation Inc · Biggs, CABuilt 1964 · S/N 64-14073N204HTJones Flying Service · Biggs, CABuilt 1962 · S/N 62-2078N204JBPremier Aircraft Services LLC · Bakersfield, CABuilt 1963 · S/N 63-13088N204UHR&R Conner Aviation LLC · Conner, MTBuilt 1962 · S/N 62-2034N206NJPope James D · Clarkston, WABuilt 1962 · S/N 62-1934N2252APremier Aircraft Services LLC · Bakersfield, CABuilt 1961 · S/N 61-0798N22753Martins Dusters Inc · Colusa, CABuilt 1964 · S/N 64-13985N234SJPorter Flying Services Inc · Chico, CABuilt 1962 · S/N 388N271GHAmerican Huey 369 Inc · Peru, INS/N 151271N2956FAvag Inc · Richvale, CAS/N 63-12950N3181FSalmon River Helicopters Inc · Riggins, IDBuilt 1964 · S/N 64-15486N333XLCj Air LLC · Nezperce, IDBuilt 1967 · S/N 154951N334WNPope Jim D DBA · Lewiston, IDBuilt 1962 · S/N 62-2097N370ASJtbam Inc · Lakeside, AZS/N 63-12923N4040PR & R Conner Aviation LLC · Conner, MTBuilt 1965 · S/N 65-7911N405PDPowell Kim S · Highlands, TXS/N 64-13930N4237VRatledge Thomas D · Bethel, AKS/N 261N424NAJones Flying Service Inc · Biggs, CAS/N 6414021N444SJJones Flying Service · Biggs, CABuilt 1962 · S/N 391N4480Twin Cities Aviation Inc · Yuba City, CAS/N 64-13906N453CCHelo 1 LLC · Anchorage, AKBuilt 1968 · S/N 155352N45731Magnum Aviation LLC · Goff, KSS/N 61-0750N45855Scotts Helicopter Service Inc · Le Sueur, MNS/N 62-1991N46928Scotts Helicopter Services Inc · Le Sueur, MNS/N 61-0712N46969R & R Conner Aviation LLC · Conner, MTS/N 63-8548N5073XMartins Dusters Inc · Colusa, CABuilt 1963 · S/N 63-8622N59HPHansen Albert C · Mojave, CABuilt 1962 · S/N 62-1933N600MARegenald Michaud Aviation LLC · Willows, CABuilt 1964 · S/N 64-13970N606HFAgriforrestal Applications Inc · Cape Coral, FLS/N 638606N6180AJones Aviation Inc · Biggs, CABuilt 1962 · S/N 62-1994N62767Aquila Helicopters LLC · Elliston, MTS/N 62-1915N64770Premier Aircraft Services LLC · Bakersfield, CABuilt 1964 · S/N 63-8721N8043ZMagnum Aviation LLC · Goff, KSS/N 60-3552N806SBScotts Helicopter Service · Le Sueur, MNBuilt 1964 · S/N 64-14023N832MStarks Daniel · Dubois, WYBuilt 1963 · S/N 62-2084N841FCsw LLC · Anacoco, LABuilt 1965 · S/N 65-7922N841MRock Creek Leasing LLC · Sapulpa, OKBuilt 1962 · S/N 62-1956N88976R Consulting & Sales Inc · Carson City, NVS/N 64-14009N88992Premier Aircraft Services LLC · Bakersfield, CABuilt 1961 · S/N 61-0718N893PMPorter Flying Service · Durham, CABuilt 1962 · S/N 62-1923
Back to AD 89-08-06