AD 2011-01-52

Registered aircraft · 416

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

N340DCItb Sokolowski LLC · Lewes, DEBuilt 1977 · S/N 970634N3417HGc Monitoring Inc · Bellevue, WABuilt 2003 · S/N S1842N345MHKinzie Industries Inc · Erie, COExpired dealerBuilt 2004 · S/N 0173N34LBVenture Helicopters LLC · West Lafayette, INBuilt 1978 · S/N 780714N355SDBofus Aviation LLC · Helena, MTBuilt 2007 · S/N S1907N361BHDixon Thomas R · Lance Creek, WYS/N 180663N3624TMaxess Inc · Thonotosassa, FLBuilt 1984 · S/N S1173N3625TBlade Runners Chopper LLC · Sunbury, OHBuilt 1989 · S/N S1396N3626BBarney Thomas E · Cresco, PABuilt 1985 · S/N S1196N366GCHavens Aviation LLC · Blacklick, OHBuilt 2000 · S/N S1809N367RWSpies Robert Charles Sr · Kingman, AZS/N 870627N37750Bacon Gregory · Prairie Home, MOBuilt 1968 · S/N 680883(6716776)N380MCVeturis David L · Lake Forest, CAS/N 128-1054N385TATomlinson Aviation Inc · Ormond Beach, FLBuilt 2002 · S/N 142N388HFEchelon Right LLC · Springfield, TNBuilt 2005 · S/N 0209N38ABJerry Lay Aviation LLC · Minonk, ILS/N 46-0503N3947CHelocraft Holding Co Inc · Pembroke Pines, FLBuilt 2008 · S/N 0343N396CPAir 1 LLC · Newark, DEBuilt 1994 · S/N S1683N3TFHelicopter Accessory Service East · Pensacola, FLS/N 34-0042N411JCFlying Z Ranch LLC · Douglas, WYBuilt 1986 · S/N S1201N413LHRatcliff Dustin Matthew · Saltville, VABuilt 2008 · S/N S1925N41THLammers Ross L · Cumming, GABuilt 1997 · S/N S1747N426GGulf Coast Helicopters Inc · Pearland, TXBuilt 2009 · S/N 0354N4276REchols Mark R · Diana, TXBuilt 1967 · S/N 1181032N444EDunker Quinn E · Morse Bluff, NEBuilt 1963 · S/N 0217N451JRFathom Aviation LLC · Burley, WAS/N 65-0212N451MCAero-Tech Helicopters LLC · Kingstree, SCS/N 340287N47SDWampler William C · Canton, TXS/N 108-0989N48155Classic Rotors Museum · Ramona, CABuilt 1964 · S/N 160433N4853STurley Gregory D · Pell City, ALBuilt 1977 · S/N 870625N49WGGarlock Walter G · Oconomowoc, WIS/N 760616N5001FReynolds Darryl G · Wills Point, TXBuilt 1965 · S/N 95-0385N50045Drive A Tank Inc · Kasota, MNBuilt 1966 · S/N 76-0610N500HSDaniels Richard L · Bow, WAS/N 170554N5015VFoos LLC · Vancouver, WAS/N 611058N503JNTailwind Investments LLC · Zeeland, MIBuilt 2000 · S/N 0104N503QDSchroth Charles D · Gustavus, AKBuilt 1977 · S/N 1170643N504JNPolarblast LLC · Bellefonte, PABuilt 2000 · S/N 0112N511BHParis Air Inc · Vero Beach, FLBuilt 2007 · S/N 0291N511MKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 0336N511RJCarman Scott C · Port Orange, FLBuilt 2010 · S/N S1946N515PHGulf Coast Helicopters Inc · Pearland, TXBuilt 1998 · S/N S1771N5160NFox Judy S · Ridgefield, WAS/N 1076N521RSJj Airlift Inc · Broomfield, COBuilt 2006 · S/N S1891N522TTHarris Kenneth L · Greeley, COBuilt 1990 · S/N S1471N525GHLauff Samuel Jr · Ocala, FLBuilt 1964 · S/N 87N526LWN526lw LLC · Salem, ORBuilt 1981 · S/N 511051N528WTRegistration Pending · New Smyrna Beach, FLRegistration pendingBuilt 2001 · S/N S1822N531TCJj Aviation LLC · Allentown, PAS/N 0285N536XDel Rio Aviation Inc · Paso Robles, CABuilt 1977 · S/N 170574
Back to AD 2011-01-52