# Registered aircraft: TCDS E26NE

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

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

- [Pratt & Whitney Canada PT6A-67P](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-67p.md): 509 registered aircraft · Registry code 52292
- [Pratt & Whitney Canada PT6A66D](https://openairdocs.org/engine/pratt-whitney-canada-pt6a66d.md): 322 registered aircraft · Registry code 52069
- [Pratt & Whitney Canada PT6E-67XP](https://openairdocs.org/engine/pratt-whitney-canada-pt6e-67xp.md): 294 registered aircraft · Registry code 52311
- [Pratt & Whitney Canada PT6A-67B](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-67b.md): 277 registered aircraft · Registry code 52158
- [Pratt & Whitney PT6A66D](https://openairdocs.org/engine/pratt-whitney-pt6a66d.md): 176 registered aircraft · Registry code 52281
- [P & WC PT6E-66XT](https://openairdocs.org/engine/p-wc-pt6e-66xt.md): 164 registered aircraft · Registry code 51761
- [Pratt & Whitney Canada PT6A-66 series](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-66-series.md): 160 registered aircraft · Registry code 52118
- [Pratt & Whitney Canada PT6A-67AG](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-67ag.md): 159 registered aircraft · Registry code 52211
- [Pratt & Whitney Canada PT6A-67A](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-67a.md): 151 registered aircraft · Registry code 52207
- [Pratt & Whitney Canada PT6A-64](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-64.md): 95 registered aircraft · Registry code 52070
- [Pratt & Whitney Canada PT6A-67F](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-67f.md): 91 registered aircraft · Registry code 52290
- [Pratt & Whitney Canada PT6A-66B](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-66b.md): 48 registered aircraft · Registry code 52287
- [Pratt & Whitney Canada PT6A-67](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-67.md): 48 registered aircraft · Registry code 52159
- [Pratt & Whitney Canada PT6A-66](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-66.md): 29 registered aircraft · Registry code 52206
- [Pratt & Whitney Canada PT6A-67D](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-67d.md): 10 registered aircraft · Registry code 52210
- [Pratt & Whitney Canada PT6A-67R](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-67r.md): 10 registered aircraft · Registry code 52208
- [Pratt & Whitney Canada PT6A-68](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-68.md): 2 registered aircraft · Registry code 52212
- [Pratt & Whitney Canada PT6A-66A](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-66a.md): 1 registered aircraft · Registry code 52213
- [Pratt & Whitney Canada PT6A-67T](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-67t.md): 0 registered aircraft · Registry code 52209

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

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