# Registered aircraft: TCDS E2EA

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

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

- [Pratt & Whitney JT8D-9 series](https://openairdocs.org/engine/pratt-whitney-jt8d-9-series.md): 9 registered aircraft · Registry code 52048
- [Pratt & Whitney JT8D-1](https://openairdocs.org/engine/pratt-whitney-jt8d-1.md): 8 registered aircraft · Registry code 52044
- [Pratt & Whitney JT8D-17 series](https://openairdocs.org/engine/pratt-whitney-jt8d-17-series.md): 7 registered aircraft · Registry code 52049
- [Pratt & Whitney JT8D-15](https://openairdocs.org/engine/pratt-whitney-jt8d-15.md): 6 registered aircraft · Registry code 52051
- [Pratt & Whitney JT8D-17](https://openairdocs.org/engine/pratt-whitney-jt8d-17.md): 6 registered aircraft · Registry code 51732
- [Pratt & Whitney JT8D-9A](https://openairdocs.org/engine/pratt-whitney-jt8d-9a.md): 5 registered aircraft · Registry code 51729
- [Pratt & Whitney JT8D-15A](https://openairdocs.org/engine/pratt-whitney-jt8d-15a.md): 1 registered aircraft · Registry code 51731
- [Pratt & Whitney JT8D-17A](https://openairdocs.org/engine/pratt-whitney-jt8d-17a.md): 1 registered aircraft · Registry code 51733
- [Pratt & Whitney JT8D-9](https://openairdocs.org/engine/pratt-whitney-jt8d-9.md): 1 registered aircraft · Registry code 51728
- [Pratt & Whitney JT8D-11](https://openairdocs.org/engine/pratt-whitney-jt8d-11.md): 0 registered aircraft · Registry code 51730
- [Pratt & Whitney JT8D-17AR](https://openairdocs.org/engine/pratt-whitney-jt8d-17ar.md): 0 registered aircraft · Registry code 51735
- [Pratt & Whitney JT8D-17R](https://openairdocs.org/engine/pratt-whitney-jt8d-17r.md): 0 registered aircraft · Registry code 51734
- [Pratt & Whitney JT8D-1A](https://openairdocs.org/engine/pratt-whitney-jt8d-1a.md): 0 registered aircraft · Registry code 51723
- [Pratt & Whitney JT8D-1B](https://openairdocs.org/engine/pratt-whitney-jt8d-1b.md): 0 registered aircraft · Registry code 51726
- [Pratt & Whitney JT8D-5](https://openairdocs.org/engine/pratt-whitney-jt8d-5.md): 0 registered aircraft · Registry code 52046
- [Pratt & Whitney JT8D-7](https://openairdocs.org/engine/pratt-whitney-jt8d-7.md): 0 registered aircraft · Registry code 51724
- [Pratt & Whitney JT8D-7A](https://openairdocs.org/engine/pratt-whitney-jt8d-7a.md): 0 registered aircraft · Registry code 51725
- [Pratt & Whitney JT8D-7B](https://openairdocs.org/engine/pratt-whitney-jt8d-7b.md): 0 registered aircraft · Registry code 51727

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

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