# Registered aircraft: TCDS E1GL

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

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

- [Rolls-Royce 250-C47B](https://openairdocs.org/engine/rolls-royce-250-c47b.md): 537 registered aircraft · Registry code 54585
- [Allison 250-C30 series](https://openairdocs.org/engine/allison-250-c30-series.md): 224 registered aircraft · Registry code 03015
- [Rolls-Royce 250-C47E/4](https://openairdocs.org/engine/rolls-royce-250-c47e-4.md): 182 registered aircraft · Registry code 54236
- [Rolls-Royce 250-C30P](https://openairdocs.org/engine/rolls-royce-250-c30p.md): 152 registered aircraft · Registry code 54013
- [Allison 250-C47](https://openairdocs.org/engine/allison-250-c47-series.md): 123 registered aircraft · Registry code 03029
- [Rolls-Royce 250-C30](https://openairdocs.org/engine/rolls-royce-250-c30.md): 76 registered aircraft · Registry code 54023
- [Allison 250-C28 series](https://openairdocs.org/engine/allison-250-c28-series.md): 43 registered aircraft · Registry codes 03022, 03021
- [Allison 250-C30P](https://openairdocs.org/engine/allison-250-c30p.md): 25 registered aircraft · Registry code 03099
- [Rolls-Royce 250-C40B](https://openairdocs.org/engine/rolls-royce-250-c40b.md): 19 registered aircraft · Registry code 54525
- [Rolls-Royce 250-C47 series](https://openairdocs.org/engine/rolls-royce-250-c47-series.md): 16 registered aircraft · Registry code 54235
- [Allison 250-C47B](https://openairdocs.org/engine/allison-250-c47b.md): 15 registered aircraft · Registry code 03109
- [Rolls-Royce 250-C47M](https://openairdocs.org/engine/rolls-royce-250-c47m.md): 13 registered aircraft · Registry code 54020
- [Allison 250-C28B](https://openairdocs.org/engine/allison-250-c28b.md): 5 registered aircraft · Registry code 03114
- [Allison 250-C30](https://openairdocs.org/engine/allison-250-c30.md): 5 registered aircraft · Registry code 03097
- [Allison 250-C47M](https://openairdocs.org/engine/allison-250-c47m.md): 3 registered aircraft · Registry code 03110
- [Rolls-Royce 250-C28B](https://openairdocs.org/engine/rolls-royce-250-c28b.md): 3 registered aircraft · Registry code 54010
- [Rolls-Royce 250-C30G](https://openairdocs.org/engine/rolls-royce-250-c30g.md): 3 registered aircraft · Registry code 54016
- [Rolls-Royce 250-C30G/2](https://openairdocs.org/engine/rolls-royce-250-c30g-2.md): 3 registered aircraft · Registry code 54018
- [Rolls-Royce 250-C30S](https://openairdocs.org/engine/rolls-royce-250-c30s.md): 2 registered aircraft · Registry code 54012
- [Allison 250-C30G/2](https://openairdocs.org/engine/allison-250-c30g-2.md): 1 registered aircraft · Registry code 03105
- [Allison 250-C40B](https://openairdocs.org/engine/allison-250-c40b.md): 1 registered aircraft · Registry code 03108
- [Rolls-Royce 250-C28](https://openairdocs.org/engine/rolls-royce-250-c28.md): 1 registered aircraft · Registry code 54009
- [Rolls-Royce 250-C30M](https://openairdocs.org/engine/rolls-royce-250-c30m.md): 1 registered aircraft · Registry code 54014
- [Rolls-Royce 250-C30R](https://openairdocs.org/engine/rolls-royce-250-c30r.md): 1 registered aircraft · Registry code 54015
- [Rolls-Royce 250-C30R/3](https://openairdocs.org/engine/rolls-royce-250-c30r-3.md): 1 registered aircraft · Registry code 54021
- [Rolls-Royce 250-C30R/3M](https://openairdocs.org/engine/rolls-royce-250-c30r-3m.md): 1 registered aircraft · Registry code 54022
- [Allison 250-C28](https://openairdocs.org/engine/allison-250-c28.md): 0 registered aircraft · Registry code 03113
- [Allison 250-C28C](https://openairdocs.org/engine/allison-250-c28c.md): 0 registered aircraft · Registry code 03115
- [Allison 250-C30G](https://openairdocs.org/engine/allison-250-c30g.md): 0 registered aircraft · Registry code 03103
- [Allison 250-C30M](https://openairdocs.org/engine/allison-250-c30m.md): 0 registered aircraft · Registry code 03100
- [Allison 250-C30R](https://openairdocs.org/engine/allison-250-c30r.md): 0 registered aircraft · Registry code 03101
- [Allison 250-C30R/1](https://openairdocs.org/engine/allison-250-c30r-1.md): 0 registered aircraft · Registry code 03106
- [Allison 250-C30R/3](https://openairdocs.org/engine/allison-250-c30r-3.md): 0 registered aircraft · Registry code 03111
- [Allison 250-C30R/3M](https://openairdocs.org/engine/allison-250-c30r-3m.md): 0 registered aircraft · Registry code 03112
- [Allison 250-C30S](https://openairdocs.org/engine/allison-250-c30s.md): 0 registered aircraft · Registry code 03098
- [Allison 250-C30U](https://openairdocs.org/engine/allison-250-c30u.md): 0 registered aircraft · Registry code 03104
- [Rolls-Royce 250-C28C](https://openairdocs.org/engine/rolls-royce-250-c28c.md): 0 registered aircraft · Registry code 54011
- [Rolls-Royce 250-C30R/1](https://openairdocs.org/engine/rolls-royce-250-c30r-1.md): 0 registered aircraft · Registry code 54019
- [Rolls-Royce 250-C30U](https://openairdocs.org/engine/rolls-royce-250-c30u.md): 0 registered aircraft · Registry code 54017

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

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