OpenAirDocs.org
Artemis Aviation Group LLC

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

N290STShort Brothers S312 TUCANO T MK1 · S/N T061Kalispell, MTN29TWWaco CTO · S/N A-100Kalispell, MTN3557WWaco PCF · S/N 3557Built 1931 · Kalispell, MTN379STShort Brothers S312 TUCANO T MK1 · S/N T093Kalispell, MTN415SADehavilland DH 114 HERON 2X · S/N 14064Built 1954 · Kalispell, MTN499SZNorth American AT-6G · S/N 51-14314Kalispell, MTN50149Boeing A75N1(PT17) · S/N 75-1055Built 1941 · Kalispell, MTN629NWaco DSO · S/N D-3124Kalispell, MTN655NWaco CTO · S/N 3137Built 1930 · Kalispell, MTN666NWaco CTO · S/N 3117Built 1930 · Kalispell, MTN68935Piper J3C-65 · S/N 13695Kalispell, MTN75JTBoeing D75N1 · S/N 75-3822Kalispell, MTN823LJLearjet 23 · S/N 23-082AKalispell, MTN9133HGrumman Aircraft Engrg F6F-5 · S/N 79133Kalispell, MTN9246UCessna 150M · S/N 15078196Built 1976 · Kalispell, MTN94038Grumman Aircraft Engrg F6F-5 · S/N 94038Kalispell, MTN959FTCurtiss Wright P-40N-5 · S/N 42-104959Kalispell, MT
Back to Artemis Aviation Group LLC