# Registered aircraft: TCDS E4CE

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

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

- [Allison 250-C20 series](https://openairdocs.org/engine/allison-250-c20-series.md): 530 registered aircraft · Registry code 03020
- [Rolls-Royce 250-C300/A1](https://openairdocs.org/engine/rolls-royce-250-c300-a1.md): 355 registered aircraft · Registry code 54232
- [Rolls-Royce 250-C20B](https://openairdocs.org/engine/rolls-royce-250-c20b.md): 215 registered aircraft · Registry code 54385
- [Allison 250-C20B](https://openairdocs.org/engine/allison-250-c20b.md): 113 registered aircraft · Registry code 03081
- [Rolls-Royce 250-C20J](https://openairdocs.org/engine/rolls-royce-250-c20j.md): 82 registered aircraft · Registry code 54181
- [Allison 250-C20](https://openairdocs.org/engine/allison-250-c20.md): 54 registered aircraft · Registry code 03080
- [Rolls-Royce 250-C20W](https://openairdocs.org/engine/rolls-royce-250-c20w.md): 51 registered aircraft · Registry code 54189
- [Rolls-Royce 250-C20](https://openairdocs.org/engine/rolls-royce-250-c20.md): 42 registered aircraft · Registry code 54178
- [Rolls-Royce 250-C300](https://openairdocs.org/engine/rolls-royce-250-c300-series.md): 40 registered aircraft · Registry code 54225
- [Rolls-Royce 250-C20R/2](https://openairdocs.org/engine/rolls-royce-250-c20r-2.md): 24 registered aircraft · Registry code 54185
- [Allison 250-C20J](https://openairdocs.org/engine/allison-250-c20j.md): 16 registered aircraft · Registry code 03088
- [Allison 250-C10D](https://openairdocs.org/engine/allison-250-c10d.md): 13 registered aircraft · Registry code 03035
- [Allison 250-C20C](https://openairdocs.org/engine/allison-250-c20c.md): 9 registered aircraft · Registry code 03082
- [Allison 250-C20R/2](https://openairdocs.org/engine/allison-250-c20r-2.md): 8 registered aircraft · Registry code 03092
- [Rolls-Royce 250-C10D](https://openairdocs.org/engine/rolls-royce-250-c10d.md): 8 registered aircraft · Registry code 54172
- [Rolls-Royce 250-C20C](https://openairdocs.org/engine/rolls-royce-250-c20c.md): 6 registered aircraft · Registry code 54179
- [Rolls-Royce 250-C20R/1](https://openairdocs.org/engine/rolls-royce-250-c20r-1.md): 5 registered aircraft · Registry code 54184
- [Rolls-Royce 250-C20R](https://openairdocs.org/engine/rolls-royce-250-c20r.md): 4 registered aircraft · Registry code 54183
- [Allison 250-C20R](https://openairdocs.org/engine/allison-250-c20r.md): 3 registered aircraft · Registry code 03090
- [Allison 250-C20R/1](https://openairdocs.org/engine/allison-250-c20r-1.md): 3 registered aircraft · Registry code 03091
- [Allison 250-C20W](https://openairdocs.org/engine/allison-250-c20w.md): 3 registered aircraft · Registry code 03096
- [Allison 250-C18](https://openairdocs.org/engine/allison-250-c18.md): 2 registered aircraft · Registry code 03075
- [Allison 250-C18B](https://openairdocs.org/engine/allison-250-c18b.md): 2 registered aircraft · Registry code 03078
- [Rolls-Royce 250-C20F](https://openairdocs.org/engine/rolls-royce-250-c20f.md): 2 registered aircraft · Registry code 54180
- [Rolls-Royce 250-C20S](https://openairdocs.org/engine/rolls-royce-250-c20s.md): 2 registered aircraft · Registry code 54182
- [Allison 250-C20F](https://openairdocs.org/engine/allison-250-c20f.md): 1 registered aircraft · Registry code 03087
- [Rolls-Royce 250-C18](https://openairdocs.org/engine/rolls-royce-250-c18.md): 1 registered aircraft · Registry code 54173
- [Rolls-Royce 250-C20R/4](https://openairdocs.org/engine/rolls-royce-250-c20r-4.md): 1 registered aircraft · Registry code 54186
- [Allison 225-C10](https://openairdocs.org/engine/allison-225-c10.md): 0 registered aircraft · Registry code 03094
- [Allison 225-C10A](https://openairdocs.org/engine/allison-225-c10a.md): 0 registered aircraft · Registry code 03095
- [Allison 250-C10](https://openairdocs.org/engine/allison-250-c10.md): 0 registered aircraft · Registry code 03073
- [Allison 250-C10B](https://openairdocs.org/engine/allison-250-c10b.md): 0 registered aircraft · Registry code 03074
- [Allison 250-C18A](https://openairdocs.org/engine/allison-250-c18a.md): 0 registered aircraft · Registry code 03076
- [Allison 250-C18C](https://openairdocs.org/engine/allison-250-c18c.md): 0 registered aircraft · Registry code 03079
- [Allison 250-C19](https://openairdocs.org/engine/allison-250-c19.md): 0 registered aircraft · Registry code 03077
- [Allison 250-C20R/4](https://openairdocs.org/engine/allison-250-c20r-4.md): 0 registered aircraft · Registry code 03093
- [Allison 250-C20S](https://openairdocs.org/engine/allison-250-c20s.md): 0 registered aircraft · Registry code 03089
- [Rolls-Royce 225-C10](https://openairdocs.org/engine/rolls-royce-225-c10.md): 0 registered aircraft · Registry code 54187
- [Rolls-Royce 225-C10-A](https://openairdocs.org/engine/rolls-royce-225-c10-a.md): 0 registered aircraft · Registry code 54188
- [Rolls-Royce 250-C10](https://openairdocs.org/engine/rolls-royce-250-c10.md): 0 registered aircraft · Registry code 54170
- [Rolls-Royce 250-C10B](https://openairdocs.org/engine/rolls-royce-250-c10b.md): 0 registered aircraft · Registry code 54171
- [Rolls-Royce 250-C18A](https://openairdocs.org/engine/rolls-royce-250-c18a.md): 0 registered aircraft · Registry code 54174
- [Rolls-Royce 250-C18B](https://openairdocs.org/engine/rolls-royce-250-c18b.md): 0 registered aircraft · Registry code 54176
- [Rolls-Royce 250-C18C](https://openairdocs.org/engine/rolls-royce-250-c18c.md): 0 registered aircraft · Registry code 54177
- [Rolls-Royce 250-C19](https://openairdocs.org/engine/rolls-royce-250-c19.md): 0 registered aircraft · Registry code 54175

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

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