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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N4035WEurocopter AS 350 B2 · S/N 2912N703JPSikorsky HH-60L · S/N 03-26987N704JPSikorsky HH-60L · S/N 04-27021N803MRBombardier DHC-8-202 · S/N 626N813KBSikorsky HH-60L · S/N 06-27111N814KBSikorsky HH-60L · S/N 06-27112N815KBSikorsky HH-60L · S/N 06-27113N816KBSikorsky HH-60L · S/N 85-24388N817KBSikorsky HH-60L · S/N 03-26997N818KBSikorsky HH-60L · S/N 03-26989First renewal noticeN819KBSikorsky HH-60L · S/N 05-27038N820KBSikorsky HH-60L · S/N 97-26769N823KBSikorsky HH-60L · S/N 00-26874N829KBSikorsky HH-60L · S/N 00-26873N830KBSikorsky HH-60L · S/N 02-26965N833KBSikorsky HH-60L · S/N 01-26895N838KBSikorsky HH-60L · S/N 97-26768
Back to Air And Marine Operations