# Registered aircraft: TCDS E00078NE

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

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

- [GE GENX-1B74/75/](https://openairdocs.org/engine/ge-genx-1b74-75-series.md): 60 registered aircraft · Registry code 30222
- [GE GENX-1B70/P2](https://openairdocs.org/engine/ge-genx-1b70-p2.md): 44 registered aircraft · Registry code 30228
- [GE GENX-2B67/P](https://openairdocs.org/engine/ge-genx-2b67-p.md): 35 registered aircraft · Registry code 30235
- [GE GENX-1B76A/P2](https://openairdocs.org/engine/ge-genx-1b76a-p2.md): 29 registered aircraft · Registry code 30231
- [GE GENX-1B76/P2](https://openairdocs.org/engine/ge-genx-1b76-p2.md): 18 registered aircraft · Registry code 30238
- [GE GENX series](https://openairdocs.org/engine/ge-genx-series.md): 17 registered aircraft · Registry code 30163
- [GE GENX-2B67B](https://openairdocs.org/engine/ge-genx-2b67b.md): 10 registered aircraft · Registry code 30165
- [GE GENX-2B67](https://openairdocs.org/engine/ge-genx-2b67.md): 6 registered aircraft · Registry code 30234
- [GE GENX-1B75/P2](https://openairdocs.org/engine/ge-genx-1b75-p2.md): 5 registered aircraft · Registry code 30232
- [GE GENX-1B70/P1](https://openairdocs.org/engine/ge-genx-1b70-p1.md): 3 registered aircraft · Registry code 30219
- [GE GENX-1B70](https://openairdocs.org/engine/ge-genx-1b70.md): 2 registered aircraft · Registry code 30214
- [GE GENX-1B70/75/](https://openairdocs.org/engine/ge-genx-1b70-75-series.md): 2 registered aircraft · Registry code 30221
- [GE GENX-1B67/P2](https://openairdocs.org/engine/ge-genx-1b67-p2.md): 1 registered aircraft · Registry code 30227
- [GE GENX-1B54](https://openairdocs.org/engine/ge-genx-1b54.md): 0 registered aircraft · Registry code 30210
- [GE GENX-1B54/P1](https://openairdocs.org/engine/ge-genx-1b54-p1.md): 0 registered aircraft · Registry code 30215
- [GE GENX-1B54/P2](https://openairdocs.org/engine/ge-genx-1b54-p2.md): 0 registered aircraft · Registry code 30224
- [GE GENX-1B58](https://openairdocs.org/engine/ge-genx-1b58.md): 0 registered aircraft · Registry code 30211
- [GE GENX-1B58/P1](https://openairdocs.org/engine/ge-genx-1b58-p1.md): 0 registered aircraft · Registry code 30216
- [GE GENX-1B58/P2](https://openairdocs.org/engine/ge-genx-1b58-p2.md): 0 registered aircraft · Registry code 30225
- [GE GENX-1B64](https://openairdocs.org/engine/ge-genx-1b64.md): 0 registered aircraft · Registry code 30212
- [GE GENX-1B64/P1](https://openairdocs.org/engine/ge-genx-1b64-p1.md): 0 registered aircraft · Registry code 30217
- [GE GENX-1B64/P2](https://openairdocs.org/engine/ge-genx-1b64-p2.md): 0 registered aircraft · Registry code 30226
- [GE GENX-1B67](https://openairdocs.org/engine/ge-genx-1b67.md): 0 registered aircraft · Registry code 30213
- [GE GENX-1B67/P1](https://openairdocs.org/engine/ge-genx-1b67-p1.md): 0 registered aircraft · Registry code 30218
- [GE GENX-1B70/72/](https://openairdocs.org/engine/ge-genx-1b70-72-series.md): 0 registered aircraft · Registry code 30220
- [GE GENX-1B75/P1](https://openairdocs.org/engine/ge-genx-1b75-p1.md): 0 registered aircraft · Registry code 30223
- [GE GENX-1B78/P2](https://openairdocs.org/engine/ge-genx-1b78-p2.md): 0 registered aircraft · Registry code 30233

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

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