OpenAirDocs.org
Helibro LLC

Registered aircraft · 26

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 = 'HELIBRO LLC' OR list_contains(g.other_registrant_names, 'HELIBRO LLC')
  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.

N126PJAmerican Eurocopter AS350B3 · S/N 7039Built 2010 · Red Bluff, CAN127PJEurocopter AS 350 B3 · S/N 7180Built 2011 · Red Bluff, CAN134PJCessna 172S · S/N 172S9187Built 2002 · Red Bluff, CAN140PJAirbus Helicopters AS350B3 · S/N 8646Red Bluff, CAN141PJAirbus Helicopters AS350B3 · S/N 9368Built 2023 · Red Bluff, CAN232PJBell Helicopter Textron 212 · S/N 30826Built 1977 · Red Bluff, CAN400PJBell 407 · S/N 53705Built 2006 · Red Bluff, CAN402PJBell 407 · S/N 53195Built 1997 · Red Bluff, CAN403PJBell 407 · S/N 53256Built 1998 · Red Bluff, CAN406PJBell 407 · S/N 53466Built 2000 · Red Bluff, CAN408PJBell 407 · S/N 53286Built 1998 · Red Bluff, CAN409PJBell Helicopter Textron Canada 407 · S/N 53301Built 1998 · Red Bluff, CAN411PJBell 407 · S/N 53045Built 1996 · Red Bluff, CAN414PJBell Helicopter Textron Canada 407 · S/N 53989Built 2010 · Red Bluff, CAN417PJBell 407 · S/N 53493Red Bluff, CAN418PJBell Helicopter Textron Canada 407 · S/N 54025Built 2010 · Red Bluff, CAN424PJBell Helicopter Textron Canada 429 · S/N 57113Built 2012 · Red Bluff, CAN426PJBell Helicopter Textron Canada 429 · S/N 57057Built 2011 · Red Bluff, CAN491PJBell Helicopter Textron Canada 407 · S/N 53944Built 2009 · Red Bluff, CAN492PJBell 407 · S/N 53756Built 2007 · Red Bluff, CAN493PJBell Helicopter Textron Canada 407 · S/N 53936Built 2009 · Red Bluff, CAN494PJBell 407 · S/N 53694Built 2006 · Red Bluff, CAN496PJBell Helicopter Textron Canada 407 · S/N 53934Built 2009 · Red Bluff, CAN794BTBell Helicopter Textron Canada 407 · S/N 53942Red Bluff, CAN903PJPilatus PC-12/45 · S/N 273Built 1999 · Red Bluff, CAN904PJPilatus PC-12/47 · S/N 784Built 2007 · Red Bluff, CA
Back to Helibro LLC