Helicopters Inc

Registered aircraft · 57

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'HELICOPTERS INC' OR list_contains(g.other_registrant_names, 'HELICOPTERS INC')
  ORDER BY g.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.

N10TVBell 206L-3 · S/N 51399Built 1990 · Cahokia, ILN10XVBell 206-L4 · S/N 52293Built 2004 · Wilmington, DEN11TVBell 206-L4 · S/N 52289Built 2004 · Cahokia, ILN12BQBell 206-L4 · S/N 52012Built 1993 · Cahokia, ILN12YABell Helicopter Textron Canada 505 · S/N 65103Built 2018 · Wilmington, DEN13HDBell 206-L4 · S/N 52152Built 1995 · Wilmington, DEN13NNBell Helicopter Textron Canada 206L-4 · S/N 52380Built 2008 · Wilmington, DEN20TVBell 206-L4 · S/N 52084Built 1994 · Linden, NJN21CLBell 407 · S/N 53536Built 2002 · Linden, NJN27MBell 206-L4 · S/N 52045Built 1993 · Wilmington, DEN28LLBell Helicopter Textron Canada 407 · S/N 53581Built 2003 · Wilmington, DEN29SBell 206B · S/N 4378Built 1995 · Cahokia, ILN38BLBell 407 · S/N 53368Built 1999 · Wilmington, DEN38BZBell 206-L4 · S/N 52128Built 1995 · Wilmington, DEN39CLBell 407 · S/N 53612Built 2004 · Wilmington, DEN3QYBell 206-L4 · S/N 52224Built 1999 · Wilmington, DEN3YJBell 206B · S/N 4322Built 1994 · Linden, NJN42SLBell Helicopter Textron Canada 206L-4 · S/N 52377Built 2008 · Wilmington, DEN43EEBell 206-L4 · S/N 52219Built 1999 · Wilmington, DEN46CLBell 206B-III · S/N 4518Built 1999 · Wilmington, DEN4CQBell 206-L4 · S/N 52088Built 1994 · Cahokia, ILN50GVBell Helicopter Textron Canada 407 · S/N 54864Built 2019 · Wilmington, DEN50QBell 407 · S/N 53565First renewal noticeBuilt 2003 · Linden, NJN553HDBell 407 · S/N 53304Built 1998 · Wilmington, DEN55SLBell Helicopter Textron Canada 206L-4 · S/N 52347Built 2007 · Cahokia, ILN569TBell 206-L4 · S/N 52290Built 2004 · Wilmington, DEN56BLBell 206B · S/N 3502Built 1982 · Cahokia, ILN5NYBell 407 · S/N 53474Built 2001 · Wilmington, DEN5QPBell 206B · S/N 3457Built 1981 · Cahokia, ILN5QVBell 206B · S/N 3098Cahokia, ILN5TVBell 206B · S/N 4036Built 1988 · Linden, NJN61CLBell 206B · S/N 4190Wilmington, DEN62FBell 206B · S/N 4341Built 1995 · Linden, NJN62TVBell Helicopter Textron Canada 206L-4 · S/N 52369Built 2008 · Cahokia, ILN67CLBell 206B · S/N 4530Built 2000 · Linden, NJN69FBell 407 · S/N 53025Built 1996 · Cahokia, ILN6QPBell 206-L4 · S/N 52191Cahokia, ILN6ULBell 206-L4 · S/N 52015Built 1993 · Wilmington, DEN6UXEurocopter AS 350 B3 · S/N 3749Built 2003 · Cahokia, ILN6YJBell 407 · S/N 53066Built 1996 · Linden, NJN77NYBell Helicopter Textron Canada 407 · S/N 54148Built 2013 · Linden, NJN7QDBell 206-L4 · S/N 52108Wilmington, DEN7QNBell 206-L4 · S/N 52199Built 1997 · Wilmington, DEN7YJBell 206-L4 · S/N 52026Linden, NJN82FBell 206B-III · S/N 4240Built 1992 · Cahokia, ILN83UBell 206-L4 · S/N 52124Built 1995 · Wilmington, DEN84BLBell 407 · S/N 53291Built 1998 · Wilmington, DEN8QDBell 206B · S/N 4189Built 1991 · Wilmington, DEN8YJBell 206B · S/N 4485Built 1998 · Cahokia, ILN90CLBell 206B · S/N 4066Built 1989 · Wilmington, DE
Back to Helicopters Inc