# Registered aircraft: TCDS TE6CH

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

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

- [Allison AE3007C series](https://openairdocs.org/engine/allison-ae3007c-series.md): 204 registered aircraft · Registry code 03028
- [Rolls-Royce AE3007 series](https://openairdocs.org/engine/rolls-royce-ae3007-series.md): 185 registered aircraft · Registry code 54582
- [Allison AE-3007A](https://openairdocs.org/engine/allison-ae-3007a.md): 83 registered aircraft · Registry code 03030
- [Rolls-Royce AE-3007A1P](https://openairdocs.org/engine/rolls-royce-ae-3007a1p.md): 59 registered aircraft · Registry code 54571
- [Allison AE-3007C1](https://openairdocs.org/engine/allison-ae-3007c1.md): 37 registered aircraft · Registry code 03053
- [Rolls-Royce AE-3007A1E](https://openairdocs.org/engine/rolls-royce-ae-3007a1e.md): 37 registered aircraft · Registry code 54169
- [Rolls-Royce AE-3007C2](https://openairdocs.org/engine/rolls-royce-ae-3007c2.md): 31 registered aircraft · Registry code 54234
- [Rolls-Royce AE-3007C1](https://openairdocs.org/engine/rolls-royce-ae-3007c1.md): 20 registered aircraft · Registry code 54168
- [Rolls-Royce AE-3007C](https://openairdocs.org/engine/rolls-royce-ae-3007c.md): 16 registered aircraft · Registry code 54572
- [Allison AE-3007A1/3](https://openairdocs.org/engine/allison-ae-3007a1-3.md): 9 registered aircraft · Registry code 03036
- [Rolls-Royce AE-3007A1/3](https://openairdocs.org/engine/rolls-royce-ae-3007a1-3.md): 7 registered aircraft · Registry code 54166
- [Rolls-Royce AE-3007A2](https://openairdocs.org/engine/rolls-royce-ae-3007a2.md): 6 registered aircraft · Registry code 54594
- [Rolls-Royce AE-3007A1](https://openairdocs.org/engine/rolls-royce-ae-3007a1.md): 4 registered aircraft · Registry code 54165
- [Allison AE-3007C](https://openairdocs.org/engine/allison-ae-3007c.md): 2 registered aircraft · Registry code 03047
- [Allison AE-3007A1/1](https://openairdocs.org/engine/allison-ae-3007a1-1.md): 1 registered aircraft · Registry code 03048
- [Rolls-Royce AE-3007A](https://openairdocs.org/engine/rolls-royce-ae-3007a.md): 1 registered aircraft · Registry code 54162
- [Allison AE-3007A1](https://openairdocs.org/engine/allison-ae-3007a1.md): 0 registered aircraft · Registry code 03050
- [Allison AE-3007A1/2](https://openairdocs.org/engine/allison-ae-3007a1-2.md): 0 registered aircraft · Registry code 03049
- [Allison AE-3007A1E](https://openairdocs.org/engine/allison-ae-3007a1e.md): 0 registered aircraft · Registry code 03054
- [Allison AE-3007A1P](https://openairdocs.org/engine/allison-ae-3007a1p.md): 0 registered aircraft · Registry code 03051
- [Allison AE-3007A3](https://openairdocs.org/engine/allison-ae-3007a3.md): 0 registered aircraft · Registry code 03052
- [Rolls-Royce AE-3007A1/1](https://openairdocs.org/engine/rolls-royce-ae-3007a1-1.md): 0 registered aircraft · Registry code 54163
- [Rolls-Royce AE-3007A1/2](https://openairdocs.org/engine/rolls-royce-ae-3007a1-2.md): 0 registered aircraft · Registry code 54164
- [Rolls-Royce AE-3007A3](https://openairdocs.org/engine/rolls-royce-ae-3007a3.md): 0 registered aircraft · Registry code 54167

## 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 = 'TE6CH')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

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