OpenAirDocs.org
AD 76-02-08

Registered aircraft · 78

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

N1026YKuwait International Aircraft Leasing Inc · Wilmington, DEBuilt 2005 · S/N 36391N1079UTurbines Ltd · West Point, NEBuilt 1980 · S/N 31122N1168UHeli-Flite Inc · Corona, CABuilt 1958 · S/N 58-1070N119WGHigh Performance Helicopters Corp · Crestline, CABuilt 2005 · S/N 14502N121CMSpace Coast Aircraft Co · Merritt Island, FLBuilt 1993 · S/N 208B0336N126GWAircrane Inc · Winder, GABuilt 1959 · S/N 581124N129NHSh1p Holdings LLC · Wichita, KSBuilt 1958 · S/N 58-855N141MHCinema Aircraft Executive Transportation LLC · Las Vegas, NVBuilt 1997 · S/N 760465N143PHWestern USA Solutions Inc · Kodiak, AKS/N 33134N159CMMomentum Foundation Inc · Tullahoma, TNBuilt 1987 · S/N 760333N16920Temsco Helicopters Inc · Ketchikan, AKBuilt 1977 · S/N 30865N16930Temsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 30920N17LASan Juan Aviation LLC · Wilmington, DEBuilt 1992 · S/N 36044N18LACounty Of Los Angeles Fire Department · Pacoima, CABuilt 1992 · S/N 36043N212AHAspen Helicopters Inc · Oxnard, CABuilt 1979 · S/N 30959N212HBBritt Christopher Charles · Bryan, TXBuilt 1982 · S/N 31214N212HLRogers Helicopters Inc · Fresno, CABuilt 1974 · S/N 30621N212HPCorpat Inc · Missoula, MTBuilt 1979 · S/N 30951N212THCougar Aviation LLC · Fresno, CABuilt 1980 · S/N 31109N212YS76b LLC · New York, NYBuilt 1989 · S/N 760357N21844Los Angeles Police Dept Air Support Division · Los Angeles, CABuilt 1999 · S/N 36229N219MGAir Methods LLC · Greenwood Village, COBuilt 1998 · S/N 36218N233LCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 36269N249HVertol Systems Co Inc · Destin, FLBuilt 1993 · S/N 35061N280TRAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 1988 · S/N 760344N281SDCity Of San Diego · San Diego, CABuilt 1980 · S/N 31147N307SBSan Bernardino County Sheriffs Aviation Division · San Bernardino, CABuilt 1975 · S/N 30781N316PDLonghorn Air LLC · Wilmington, DEBuilt 2003 · S/N 14038N319PDAerotrust Services Corp Trustee · Wilmington, DEBuilt 2004 · S/N 14040N359EHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1972 · S/N 30546N376PAPathfinder Leasing LLC · Anchorage, AKBuilt 1978 · S/N 30886N386AFBank Of Utah Trustee · Portsmouth, NHBuilt 2024 · S/N 2386N397ALVertol Systems Co LLC · Wilmington, DEBuilt 1990 · S/N 36012N411DEU S Department Of Energy · Las Vegas, NVBuilt 1991 · S/N 36030N413AFBerry Genetics Inc · Portsmouth, NHBuilt 2024 · S/N 2413N4247VSh1p Holdings LLC · Wichita, KSS/N 58-1547N432WAWoodley Aerial Leasing LLC · Walnut, ILS/N 400-0435N468ZBBrown Helicopter Inc · Pensacola, FLBuilt 1988 · S/N 760345N470QLVertol Systems Co Inc · Destin, FLBuilt 1989 · S/N 33200N473QHBrown Helicopter Inc · Pensacola, FLBuilt 1986 · S/N 760331N4XY5-State Helicopters Inc · Royse City, TXBuilt 1957 · S/N 58700N508EHHilcorp Equipment LLC · Anchorage, AKBuilt 1979 · S/N 30908N58AHB&B Helos LLC · Perris, CABuilt 1956 · S/N 58-328N58CMCrystal Motorsports LLC · Crystal River, FLS/N 14030N58SAircrane Inc · Winder, GABuilt 1962 · S/N 58-1539N61DJBlack Badge Aviation LLC · Carson City, NVBuilt 1991 · S/N 760380N621FCFlorida Depart Of Agriculture And Consumer Svcs · Tallahassee, FLBuilt 1991 · S/N 35034N622FCRegistered aircraftN-number assigned, not yet registeredS/N 35048N624FCFlorida Forest Service - Fp/Ac · Tallahassee, FLBuilt 1993 · S/N 35060N626FCFlorida Department Of Agriculture And Consumer · Tallahassee, FLBuilt 1995 · S/N 35088
Back to AD 76-02-08