OpenAirDocs.org
Arrow Aviation Company LLC

Registered aircraft · 19

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 = 'ARROW AVIATION COMPANY LLC' OR list_contains(g.other_registrant_names, 'ARROW AVIATION COMPANY 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.

N12MQLeonardo S P A AB139 · S/N 31041Broussard, LAN13MQSikorsky S-76C · S/N 760624Broussard, LAN16MQSikorsky S-76C · S/N 760626Broussard, LAN217FEurocopter Deutschland EC 135 P2 · S/N 0438Built 2005 · Broussard, LAN217TEurocopter Deutschland EC 135 P2 · S/N 0441Built 2005 · Broussard, LAN25740Sikorsky S-76C · S/N 760732Broussard, LAN282SSikorsky S-76A · S/N 760282Built 1985 · Broussard, LAN311MQAgustawestland AW139 · S/N 31532Broussard, LAN432MRAgusta AW139 · S/N 31042Broussard, LAN4514RSikorsky S-76C · S/N 760669Broussard, LAN4989Sikorsky S-76C · S/N 760377Broussard, LAN6989XBell 407 · S/N 53113Broussard, LAN725MFSikorsky S-76C · S/N 760532Built 2002 · Broussard, LAN82AHAirbus Helicopters EC 130 T2 · S/N 9361Built 2023 · Broussard, LAN8455Sikorsky S-76C · S/N 760407Broussard, LAN861ALSikorsky S-76C · S/N 760529Built 2002 · Broussard, LAN865ALSikorsky S-76C · S/N 760564Built 2004 · Broussard, LAN868ALSikorsky S-76C · S/N 760580Built 2004 · Broussard, LAN9483Sikorsky S-76C · S/N 760510Broussard, LA
Back to Arrow Aviation Company LLC