# Registered aircraft: TCDS E3WE

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

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

- [Garrett TPE331-1](https://openairdocs.org/engine/garrett-tpe331-1.md): 5 registered aircraft · Registry code 29030
- [AiResearch TPE331-1](https://openairdocs.org/engine/airesearch-tpe331-1.md): 3 registered aircraft · Registry code 01545
- [Garrett TPE331-2](https://openairdocs.org/engine/garrett-tpe331-2.md): 3 registered aircraft · Registry code 29033
- [Honeywell TPE331-2](https://openairdocs.org/engine/honeywell-tpe331-2.md): 3 registered aircraft · Registry code 33956
- [AiResearch TPE331-2](https://openairdocs.org/engine/airesearch-tpe331-2.md): 2 registered aircraft · Registry code 01498
- [Honeywell TPE331-1](https://openairdocs.org/engine/honeywell-tpe331-1.md): 1 registered aircraft · Registry code 33953
- [AiResearch TPE331-1U](https://openairdocs.org/engine/airesearch-tpe331-1u.md): 0 registered aircraft · Registry code 01546
- [AiResearch TPE331-2U](https://openairdocs.org/engine/airesearch-tpe331-2u.md): 0 registered aircraft · Registry code 01649
- [AiResearch TPE331-2UA](https://openairdocs.org/engine/airesearch-tpe331-2ua.md): 0 registered aircraft · Registry code 01650
- [Alliance TPE331-1UA](https://openairdocs.org/engine/alliance-tpe331-1ua.md): 0 registered aircraft · Registry code 01647
- [Alliance TPE331-2](https://openairdocs.org/engine/alliance-tpe331-2.md): 0 registered aircraft · Registry code 01648
- [Alliedsign TPE331-1](https://openairdocs.org/engine/alliedsign-tpe331-1.md): 0 registered aircraft · Registry code 02550
- [Alliedsign TPE331-1U](https://openairdocs.org/engine/alliedsign-tpe331-1u.md): 0 registered aircraft · Registry code 02551
- [Alliedsign TPE331-1UA](https://openairdocs.org/engine/alliedsign-tpe331-1ua.md): 0 registered aircraft · Registry code 02552
- [Alliedsign TPE331-2](https://openairdocs.org/engine/alliedsign-tpe331-2.md): 0 registered aircraft · Registry code 02553
- [Alliedsign TPE331-2U](https://openairdocs.org/engine/alliedsign-tpe331-2u.md): 0 registered aircraft · Registry code 02554
- [Alliedsign TPE331-2UA](https://openairdocs.org/engine/alliedsign-tpe331-2ua.md): 0 registered aircraft · Registry code 02555
- [Garrett TPE331-1U](https://openairdocs.org/engine/garrett-tpe331-1u.md): 0 registered aircraft · Registry code 29031
- [Garrett TPE331-1UA](https://openairdocs.org/engine/garrett-tpe331-1ua.md): 0 registered aircraft · Registry code 29032
- [Garrett TPE331-2U](https://openairdocs.org/engine/garrett-tpe331-2u.md): 0 registered aircraft · Registry code 29034
- [Garrett TPE331-2UA](https://openairdocs.org/engine/garrett-tpe331-2ua.md): 0 registered aircraft · Registry code 29035
- [Honeywell TPE331-1U](https://openairdocs.org/engine/honeywell-tpe331-1u.md): 0 registered aircraft · Registry code 33954
- [Honeywell TPE331-1UA](https://openairdocs.org/engine/honeywell-tpe331-1ua.md): 0 registered aircraft · Registry code 33955
- [Honeywell TPE331-2U](https://openairdocs.org/engine/honeywell-tpe331-2u.md): 0 registered aircraft · Registry code 33957
- [Honeywell TPE331-2UA](https://openairdocs.org/engine/honeywell-tpe331-2ua.md): 0 registered aircraft · Registry code 33958

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

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