# Registered aircraft: TCDS E1NM

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

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

- [Honeywell TFE731-50R](https://openairdocs.org/engine/honeywell-tfe731-50r.md): 123 registered aircraft · Registry code 33940
- [Honeywell TFE731-20BR](https://openairdocs.org/engine/honeywell-tfe731-20br.md): 105 registered aircraft · Registry code 33919
- [Honeywell TFE731-20AR](https://openairdocs.org/engine/honeywell-tfe731-20ar.md): 51 registered aircraft · Registry code 33918
- [Honeywell TFE731-40AR](https://openairdocs.org/engine/honeywell-tfe731-40ar.md): 50 registered aircraft · Registry code 33923
- [Alliedsign TFE731-60](https://openairdocs.org/engine/alliedsign-tfe731-60.md): 45 registered aircraft · Registry code 02504
- [Honeywell TFE731-60](https://openairdocs.org/engine/honeywell-tfe731-60.md): 39 registered aircraft · Registry code 33924
- [Honeywell TFE731-40R](https://openairdocs.org/engine/honeywell-tfe731-40r.md): 18 registered aircraft · Registry code 33922
- [Honeywell TFE731-40](https://openairdocs.org/engine/honeywell-tfe731-40.md): 17 registered aircraft · Registry code 33921
- [Alliedsign TFE731-40](https://openairdocs.org/engine/alliedsign-tfe731-40.md): 6 registered aircraft · Registry code 02519
- [Alliedsign TFE731-20AR](https://openairdocs.org/engine/alliedsign-tfe731-20ar.md): 3 registered aircraft · Registry code 02516
- [Alliedsign TFE731-20BR](https://openairdocs.org/engine/alliedsign-tfe731-20br.md): 3 registered aircraft · Registry code 02517
- [Alliedsign TFE731-40R](https://openairdocs.org/engine/alliedsign-tfe731-40r.md): 2 registered aircraft · Registry code 02520
- [Alliedsign TFE731-20](https://openairdocs.org/engine/alliedsign-tfe731-20.md): 1 registered aircraft · Registry code 02515
- [Alliedsign TFE731-40AR](https://openairdocs.org/engine/alliedsign-tfe731-40ar.md): 1 registered aircraft · Registry code 02521
- [Honeywell TFE731-20](https://openairdocs.org/engine/honeywell-tfe731-20.md): 1 registered aircraft · Registry code 33917
- [Alliedsign TFE731-20R](https://openairdocs.org/engine/alliedsign-tfe731-20r.md): 0 registered aircraft · Registry code 02518
- [Honeywell TFE731-20R](https://openairdocs.org/engine/honeywell-tfe731-20r.md): 0 registered aircraft · Registry code 33920

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

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