# Registered aircraft: Artemis Aviation Group LLC

A list on [Artemis Aviation Group LLC](https://openairdocs.org/faa-owner/ARTEMIS%20AVIATION%20GROUP%20LLC.md).

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

- [N290ST](https://openairdocs.org/aircraft/N290ST.md): Short Brothers S312 TUCANO T MK1 · S/N T061 · Kalispell, MT
- [N29TW](https://openairdocs.org/aircraft/N29TW.md): Waco CTO · S/N A-100 · Kalispell, MT
- [N3557W](https://openairdocs.org/aircraft/N3557W.md): Waco PCF · S/N 3557 · Built 1931 · Kalispell, MT
- [N379ST](https://openairdocs.org/aircraft/N379ST.md): Short Brothers S312 TUCANO T MK1 · S/N T093 · Kalispell, MT
- [N415SA](https://openairdocs.org/aircraft/N415SA.md): Dehavilland DH 114 HERON 2X · S/N 14064 · Built 1954 · Kalispell, MT
- [N499SZ](https://openairdocs.org/aircraft/N499SZ.md): North American AT-6G · S/N 51-14314 · Kalispell, MT
- [N50149](https://openairdocs.org/aircraft/N50149.md): Boeing A75N1(PT17) · S/N 75-1055 · Built 1941 · Kalispell, MT
- [N629N](https://openairdocs.org/aircraft/N629N.md): Waco DSO · S/N D-3124 · Kalispell, MT
- [N655N](https://openairdocs.org/aircraft/N655N.md): Waco CTO · S/N 3137 · Built 1930 · Kalispell, MT
- [N666N](https://openairdocs.org/aircraft/N666N.md): Waco CTO · S/N 3117 · Built 1930 · Kalispell, MT
- [N68935](https://openairdocs.org/aircraft/N68935.md): Piper J3C-65 · S/N 13695 · Kalispell, MT
- [N75JT](https://openairdocs.org/aircraft/N75JT.md): Boeing D75N1 · S/N 75-3822 · Kalispell, MT
- [N823LJ](https://openairdocs.org/aircraft/N823LJ.md): Learjet 23 · S/N 23-082A · Kalispell, MT
- [N9133H](https://openairdocs.org/aircraft/N9133H.md): Grumman Aircraft Engrg F6F-5 · S/N 79133 · Kalispell, MT
- [N9246U](https://openairdocs.org/aircraft/N9246U.md): Cessna 150M · S/N 15078196 · Built 1976 · Kalispell, MT
- [N94038](https://openairdocs.org/aircraft/N94038.md): Grumman Aircraft Engrg F6F-5 · S/N 94038 · Kalispell, MT
- [N959FT](https://openairdocs.org/aircraft/N959FT.md): Curtiss Wright P-40N-5 · S/N 42-104959 · Kalispell, MT

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/faa-owner/ARTEMIS%20AVIATION%20GROUP%20LLC/aircraft

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.