# Registered aircraft: TCDS E8NE

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

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

- [GE CT7-8A](https://openairdocs.org/engine/ge-ct7-8a.md): 43 registered aircraft · Registry code 30136
- [GE CT7-9B](https://openairdocs.org/engine/ge-ct7-9b.md): 23 registered aircraft · Registry code 30148
- [GE CT7-5A2](https://openairdocs.org/engine/ge-ct7-5a2.md): 7 registered aircraft · Registry code 30144
- [GE CT7-9C3](https://openairdocs.org/engine/ge-ct7-9c3.md): 6 registered aircraft · Registry code 30150
- [GE CT7-2A](https://openairdocs.org/engine/ge-ct7-2a.md): 3 registered aircraft · Registry code 30184
- [GE CT7-8A7](https://openairdocs.org/engine/ge-ct7-8a7.md): 2 registered aircraft · Registry code 30183
- [GE CT7-2D](https://openairdocs.org/engine/ge-ct7-2d.md): 0 registered aircraft · Registry code 30131
- [GE CT7-2D1](https://openairdocs.org/engine/ge-ct7-2d1.md): 0 registered aircraft · Registry code 30132
- [GE CT7-5A3](https://openairdocs.org/engine/ge-ct7-5a3.md): 0 registered aircraft · Registry code 30145
- [GE CT7-6](https://openairdocs.org/engine/ge-ct7-6.md): 0 registered aircraft · Registry code 30133
- [GE CT7-6A](https://openairdocs.org/engine/ge-ct7-6a.md): 0 registered aircraft · Registry code 30134
- [GE CT7-7A](https://openairdocs.org/engine/ge-ct7-7a.md): 0 registered aircraft · Registry code 30146
- [GE CT7-7A1](https://openairdocs.org/engine/ge-ct7-7a1.md): 0 registered aircraft · Registry code 30147
- [GE CT7-8](https://openairdocs.org/engine/ge-ct7-8.md): 0 registered aircraft · Registry code 30135
- [GE CT7-8A5](https://openairdocs.org/engine/ge-ct7-8a5.md): 0 registered aircraft · Registry code 30137
- [GE CT7-8B](https://openairdocs.org/engine/ge-ct7-8b.md): 0 registered aircraft · Registry code 30138
- [GE CT7-8B5](https://openairdocs.org/engine/ge-ct7-8b5.md): 0 registered aircraft · Registry code 30139
- [GE CT7-8E](https://openairdocs.org/engine/ge-ct7-8e.md): 0 registered aircraft · Registry code 30140
- [GE CT7-8E5](https://openairdocs.org/engine/ge-ct7-8e5.md): 0 registered aircraft · Registry code 30141
- [GE CT7-8F](https://openairdocs.org/engine/ge-ct7-8f.md): 0 registered aircraft · Registry code 30142
- [GE CT7-8F5](https://openairdocs.org/engine/ge-ct7-8f5.md): 0 registered aircraft · Registry code 30143
- [GE CT7-9B1](https://openairdocs.org/engine/ge-ct7-9b1.md): 0 registered aircraft · Registry code 30151
- [GE CT7-9B2](https://openairdocs.org/engine/ge-ct7-9b2.md): 0 registered aircraft · Registry code 30152
- [GE CT7-9C](https://openairdocs.org/engine/ge-ct7-9c.md): 0 registered aircraft · Registry code 30149
- [GE CT7-9D](https://openairdocs.org/engine/ge-ct7-9d.md): 0 registered aircraft · Registry code 30153
- [GE CT7-9D2](https://openairdocs.org/engine/ge-ct7-9d2.md): 0 registered aircraft · Registry code 30154

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

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