# Registered aircraft: TCDS E10CE

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

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

- [Allison 250-B17 series](https://openairdocs.org/engine/allison-250-b17-series.md): 14 registered aircraft · Registry codes 03017, 03018
- [Allison 250-B15G](https://openairdocs.org/engine/allison-250-b15g.md): 12 registered aircraft · Registry code 03064
- [Rolls-Royce 250-B17F](https://openairdocs.org/engine/rolls-royce-250-b17f.md): 10 registered aircraft · Registry code 54586
- [Rolls-Royce 250-B17F/2](https://openairdocs.org/engine/rolls-royce-250-b17f-2.md): 8 registered aircraft · Registry code 54033
- [Allison 250-B17C](https://openairdocs.org/engine/allison-250-b17c.md): 6 registered aircraft · Registry code 03067
- [Rolls-Royce 250-B17C](https://openairdocs.org/engine/rolls-royce-250-b17c.md): 6 registered aircraft · Registry code 54029
- [Allison 250-B17D](https://openairdocs.org/engine/allison-250-b17d.md): 4 registered aircraft · Registry code 03068
- [Allison 250-B17F/2](https://openairdocs.org/engine/allison-250-b17f-2.md): 3 registered aircraft · Registry code 03072
- [Rolls-Royce 250-B17D](https://openairdocs.org/engine/rolls-royce-250-b17d.md): 2 registered aircraft · Registry code 54030
- [Allison 250-B17E](https://openairdocs.org/engine/allison-250-b17e.md): 1 registered aircraft · Registry code 03069
- [Rolls-Royce 250-B15G](https://openairdocs.org/engine/rolls-royce-250-b15g.md): 1 registered aircraft · Registry code 54026
- [Allison 250-B15A](https://openairdocs.org/engine/allison-250-b15a.md): 0 registered aircraft · Registry code 03062
- [Allison 250-B15E](https://openairdocs.org/engine/allison-250-b15e.md): 0 registered aircraft · Registry code 03063
- [Allison 250-B17](https://openairdocs.org/engine/allison-250-b17.md): 0 registered aircraft · Registry code 03065
- [Allison 250-B17B](https://openairdocs.org/engine/allison-250-b17b.md): 0 registered aircraft · Registry code 03066
- [Allison 250-B17F](https://openairdocs.org/engine/allison-250-b17f.md): 0 registered aircraft · Registry code 03070
- [Allison 250-B17F/1](https://openairdocs.org/engine/allison-250-b17f-1.md): 0 registered aircraft · Registry code 03071
- [Rolls-Royce 250-B15A](https://openairdocs.org/engine/rolls-royce-250-b15a.md): 0 registered aircraft · Registry code 54024
- [Rolls-Royce 250-B15E](https://openairdocs.org/engine/rolls-royce-250-b15e.md): 0 registered aircraft · Registry code 54025
- [Rolls-Royce 250-B17](https://openairdocs.org/engine/rolls-royce-250-b17.md): 0 registered aircraft · Registry code 54027
- [Rolls-Royce 250-B17B](https://openairdocs.org/engine/rolls-royce-250-b17b.md): 0 registered aircraft · Registry code 54028
- [Rolls-Royce 250-B17E](https://openairdocs.org/engine/rolls-royce-250-b17e.md): 0 registered aircraft · Registry code 54031
- [Rolls-Royce 250-B17F/1](https://openairdocs.org/engine/rolls-royce-250-b17f-1.md): 0 registered aircraft · Registry code 54032

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

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