# Registered aircraft: TCDS E-190

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

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

- [Continental A50 series](https://openairdocs.org/engine/continental-a50-series.md): 26 registered aircraft · Registry code 17002
- [Continental A-50-1](https://openairdocs.org/engine/continental-a-50-1.md): 0 registered aircraft · Registry code 17087
- [Continental A-50-2](https://openairdocs.org/engine/continental-a-50-2.md): 0 registered aircraft · Registry code 17088
- [Continental A-50-3](https://openairdocs.org/engine/continental-a-50-3.md): 0 registered aircraft · Registry code 17089
- [Continental A-50-4](https://openairdocs.org/engine/continental-a-50-4.md): 0 registered aircraft · Registry code 17090
- [Continental A-50-4J](https://openairdocs.org/engine/continental-a-50-4j.md): 0 registered aircraft · Registry code 17133
- [Continental A-50-5](https://openairdocs.org/engine/continental-a-50-5.md): 0 registered aircraft · Registry code 17091
- [Continental A-50-5J](https://openairdocs.org/engine/continental-a-50-5j.md): 0 registered aircraft · Registry code 17134
- [Continental A-50-6](https://openairdocs.org/engine/continental-a-50-6.md): 0 registered aircraft · Registry code 17092
- [Continental A-50-6J](https://openairdocs.org/engine/continental-a-50-6j.md): 0 registered aircraft · Registry code 17135
- [Continental A-50-7](https://openairdocs.org/engine/continental-a-50-7.md): 0 registered aircraft · Registry code 17093
- [Continental A-50-7J](https://openairdocs.org/engine/continental-a-50-7j.md): 0 registered aircraft · Registry code 17136
- [Continental A-50-8](https://openairdocs.org/engine/continental-a-50-8.md): 0 registered aircraft · Registry code 17094
- [Continental A-50-8J](https://openairdocs.org/engine/continental-a-50-8j.md): 0 registered aircraft · Registry code 17137
- [Continental A-50-9](https://openairdocs.org/engine/continental-a-50-9.md): 0 registered aircraft · Registry code 17095
- [Continental A-50-9J](https://openairdocs.org/engine/continental-a-50-9j.md): 0 registered aircraft · Registry code 17138

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

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