# Registered aircraft: TCDS E19EU

A list on [TCDS E19EU](https://openairdocs.org/tcds/E19EU.md).

Registry models that point at this data sheet: 330 registered aircraft in all. Each model’s page lists its aircraft.

- [Turbomeca ARRIEL-1D1](https://openairdocs.org/engine/turbomeca-arriel-1d1.md): 150 registered aircraft · Registry code 60053
- [Turbomeca ARRIEL-1E2](https://openairdocs.org/engine/turbomeca-arriel-1e2.md): 101 registered aircraft · Registry code 60035
- [Safran ARRIEL-1E2](https://openairdocs.org/engine/safran-arriel-1e2.md): 44 registered aircraft · Registry code 59999
- [Turbomeca ARRIEL-1B](https://openairdocs.org/engine/turbomeca-arriel-1b.md): 18 registered aircraft · Registry code 60042
- [Turbomeca ARRIEL-1C2](https://openairdocs.org/engine/turbomeca-arriel-1c2.md): 6 registered aircraft · Registry code 60051
- [Turbomeca ARRIEL-1S1](https://openairdocs.org/engine/turbomeca-arriel-1s1.md): 4 registered aircraft · Registry code 60032
- [Safran ARRIEL-1D1](https://openairdocs.org/engine/safran-arriel-1d1.md): 3 registered aircraft · Registry code 59990
- [Turbomeca ARRIEL-1C1](https://openairdocs.org/engine/turbomeca-arriel-1c1.md): 2 registered aircraft · Registry code 60050
- [Turbomeca ARRIEL-1K1](https://openairdocs.org/engine/turbomeca-arriel-1k1.md): 1 registered aircraft · Registry code 60033
- [Turbomeca ARRIEL-1S](https://openairdocs.org/engine/turbomeca-arriel-1s.md): 1 registered aircraft · Registry code 60052
- [Safran ARRIEL-1E](https://openairdocs.org/engine/safran-arriel-1e.md): 0 registered aircraft · Registry code 59996
- [Turbomeca ARRIEL-1](https://openairdocs.org/engine/turbomeca-arriel-1.md): 0 registered aircraft · Registry code 60043
- [Turbomeca ARRIEL-1A](https://openairdocs.org/engine/turbomeca-arriel-1a.md): 0 registered aircraft · Registry code 60044
- [Turbomeca ARRIEL-1A1](https://openairdocs.org/engine/turbomeca-arriel-1a1.md): 0 registered aircraft · Registry code 60045
- [Turbomeca ARRIEL-1A2](https://openairdocs.org/engine/turbomeca-arriel-1a2.md): 0 registered aircraft · Registry code 60046
- [Turbomeca ARRIEL-1B2](https://openairdocs.org/engine/turbomeca-arriel-1b2.md): 0 registered aircraft · Registry code 60047
- [Turbomeca ARRIEL-1C](https://openairdocs.org/engine/turbomeca-arriel-1c.md): 0 registered aircraft · Registry code 60049
- [Turbomeca ARRIEL-1D](https://openairdocs.org/engine/turbomeca-arriel-1d.md): 0 registered aircraft · Registry code 60048
- [Turbomeca ARRIEL-1E](https://openairdocs.org/engine/turbomeca-arriel-1e.md): 0 registered aircraft · Registry code 60034

## The whole list in SQL

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

```sql
-- One row per registry model code; the page joins codes that share a name
SELECT 'engine' AS kind, m.code, m.manufacturer, m.model, count(g.n_number) AS aircraft
FROM 'https://openairdocs.org/data/latest/faa_engine_model.parquet' m LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g ON g.engine_model_code = m.code
WHERE m.code IN (SELECT code FROM 'https://openairdocs.org/data/latest/faa_engine_model.parquet' WHERE tcds_number = 'E19EU')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

This list as a web page: https://openairdocs.org/tcds/E19EU/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.