Air And Marine Operations

Registered aircraft · 17

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 = 'AIR AND MARINE OPERATIONS' OR list_contains(g.other_registrant_names, 'AIR AND MARINE OPERATIONS')
  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.

N4035WEurocopter AS 350 B2 · S/N 2912Built 1996 · Washington, DC · Co-owner with Department Of Homeland SecurityN703JPSikorsky HH-60L · S/N 03-26987Washington, DC · Co-owner with Department Of Homeland SecurityN704JPSikorsky HH-60L · S/N 04-27021Washington, DC · Co-owner with Department Of Homeland SecurityN803MRBombardier DHC-8-202 · S/N 626Built 2006 · Washington, DC · Co-owner with Department Of Homeland SecurityN813KBSikorsky HH-60L · S/N 06-27111Washington, DC · Co-owner with Department Of Homeland SecurityN814KBSikorsky HH-60L · S/N 06-27112Washington, DC · Co-owner with Department Of Homeland SecurityN815KBSikorsky HH-60L · S/N 06-27113Washington, DC · Co-owner with Department Of Homeland SecurityN816KBSikorsky HH-60L · S/N 85-24388Washington, DC · Co-owner with Department Of Homeland SecurityN817KBSikorsky HH-60L · S/N 03-26997Washington, DC · Co-owner with Dept Of Homeland SecurityN818KBSikorsky HH-60L · S/N 03-26989First renewal noticeWashington, DC · Co-owner with Department Of Homeland SecurityN819KBSikorsky HH-60L · S/N 05-27038Washington, DC · Co-owner with Department Of Homeland SecurityN820KBSikorsky HH-60L · S/N 97-26769Washington, DC · Co-owner with Department Of Homeland SecurityN823KBSikorsky HH-60L · S/N 00-26874Washington, DC · Co-owner with Department Of Homeland SecurityN829KBSikorsky HH-60L · S/N 00-26873Washington, DC · Co-owner with Department Of Homeland SecurityN830KBSikorsky HH-60L · S/N 02-26965Washington, DC · Co-owner with Department Of Homeland SecurityN833KBSikorsky HH-60L · S/N 01-26895Washington, DC · Co-owner with Department Of Homeland SecurityN838KBSikorsky HH-60L · S/N 97-26768Washington, DC · Co-owner with Department Of Homeland Security
Back to Air And Marine Operations