# Registered aircraft: TCDS E20NE

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

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

- [Pratt & Whitney Canada PW118](https://openairdocs.org/engine/pratt-whitney-canada-pw118.md): 37 registered aircraft · Registry code 52116
- [Pratt & Whitney Canada PW119C](https://openairdocs.org/engine/pratt-whitney-canada-pw119c.md): 20 registered aircraft · Registry code 52163
- [Pratt & Whitney Canada PW127M](https://openairdocs.org/engine/pratt-whitney-canada-pw127m.md): 18 registered aircraft · Registry code 51498
- [Pratt & Whitney Canada PW120](https://openairdocs.org/engine/pratt-whitney-canada-pw120.md): 17 registered aircraft · Registry code 52114
- [Pratt & Whitney Canada PW123D](https://openairdocs.org/engine/pratt-whitney-canada-pw123d.md): 15 registered aircraft · Registry code 52199
- [Pratt & Whitney Canada PW121](https://openairdocs.org/engine/pratt-whitney-canada-pw121.md): 14 registered aircraft · Registry code 52124
- [Pratt & Whitney Canada PW123](https://openairdocs.org/engine/pratt-whitney-canada-pw123.md): 14 registered aircraft · Registry code 52129
- [Pratt & Whitney Canada PW123AF](https://openairdocs.org/engine/pratt-whitney-canada-pw123af.md): 10 registered aircraft · Registry code 52224
- [Pratt & Whitney Canada PW119B](https://openairdocs.org/engine/pratt-whitney-canada-pw119b.md): 7 registered aircraft · Registry code 52133
- [Pratt & Whitney Canada PW123E](https://openairdocs.org/engine/pratt-whitney-canada-pw123e.md): 5 registered aircraft · Registry code 52222
- [Pratt & Whitney Canada PW118B](https://openairdocs.org/engine/pratt-whitney-canada-pw118b.md): 3 registered aircraft · Registry code 52131
- [Pratt & Whitney Canada PW123C](https://openairdocs.org/engine/pratt-whitney-canada-pw123c.md): 3 registered aircraft · Registry code 52152
- [Pratt & Whitney Canada PW120A](https://openairdocs.org/engine/pratt-whitney-canada-pw120a.md): 2 registered aircraft · Registry code 52215
- [Pratt & Whitney Canada PW124](https://openairdocs.org/engine/pratt-whitney-canada-pw124-series.md): 2 registered aircraft · Registry code 52130
- [Pratt & Whitney Canada PW127F](https://openairdocs.org/engine/pratt-whitney-canada-pw127f.md): 2 registered aircraft · Registry code 52223
- [Pratt & Whitney Canada PW127G](https://openairdocs.org/engine/pratt-whitney-canada-pw127g.md): 2 registered aircraft · Registry code 52225
- [Pratt & Whitney Canada PW118A](https://openairdocs.org/engine/pratt-whitney-canada-pw118a.md): 1 registered aircraft · Registry code 52214
- [Pratt & Whitney Canada PW127E](https://openairdocs.org/engine/pratt-whitney-canada-pw127e.md): 1 registered aircraft · Registry code 52220
- [Pratt & Whitney Canada PW121A](https://openairdocs.org/engine/pratt-whitney-canada-pw121a.md): 0 registered aircraft · Registry code 52216
- [Pratt & Whitney Canada PW123B](https://openairdocs.org/engine/pratt-whitney-canada-pw123b.md): 0 registered aircraft · Registry code 52221
- [Pratt & Whitney Canada PW124B](https://openairdocs.org/engine/pratt-whitney-canada-pw124b.md): 0 registered aircraft · Registry code 52217
- [Pratt & Whitney Canada PW125B](https://openairdocs.org/engine/pratt-whitney-canada-pw125b.md): 0 registered aircraft · Registry code 52218
- [Pratt & Whitney Canada PW126A](https://openairdocs.org/engine/pratt-whitney-canada-pw126a.md): 0 registered aircraft · Registry code 52125
- [Pratt & Whitney Canada PW127](https://openairdocs.org/engine/pratt-whitney-canada-pw127.md): 0 registered aircraft · Registry code 52219

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

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