# Registered aircraft: TCDS E3SO

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

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

- [Continental IO-550 series](https://openairdocs.org/engine/continental-io-550-series.md): 3,077 registered aircraft · Registry code 17042
- [Continental IO-550-N](https://openairdocs.org/engine/continental-io-550-n.md): 2,773 registered aircraft · Registry code 17215
- [Continental IO-550-B](https://openairdocs.org/engine/continental-io-550-b.md): 373 registered aircraft · Registry code 17208
- [Continental IO-550-C](https://openairdocs.org/engine/continental-io-550-c.md): 199 registered aircraft · Registry code 17209
- [Continental IO-550-G](https://openairdocs.org/engine/continental-io-550-g.md): 115 registered aircraft · Registry code 17213
- [Continental IO-550-D](https://openairdocs.org/engine/continental-io-550-d.md): 36 registered aircraft · Registry code 17210
- [Continental IO-550-F](https://openairdocs.org/engine/continental-io-550-f.md): 26 registered aircraft · Registry code 17211
- [TCM IO-550-N](https://openairdocs.org/engine/tcm-io-550-n.md): 10 registered aircraft · Registry code 42990
- [Continental IO-550-R](https://openairdocs.org/engine/continental-io-550-r.md): 7 registered aircraft · Registry code 17217
- [Continental IO-550-E](https://openairdocs.org/engine/continental-io-550-e.md): 6 registered aircraft · Registry code 17214
- [Continental IO-550-P](https://openairdocs.org/engine/continental-io-550-p.md): 6 registered aircraft · Registry code 17216
- [Continental IO-550-A](https://openairdocs.org/engine/continental-io-550-a.md): 3 registered aircraft · Registry code 17207
- [Continental IO-550-L](https://openairdocs.org/engine/continental-io-550-l.md): 1 registered aircraft · Registry code 17212
- [Continental IOF-550-N](https://openairdocs.org/engine/continental-iof-550-n.md): 1 registered aircraft · Registry code 17224
- [Continental IOF-550-B](https://openairdocs.org/engine/continental-iof-550-b.md): 0 registered aircraft · Registry code 17218
- [Continental IOF-550-C](https://openairdocs.org/engine/continental-iof-550-c.md): 0 registered aircraft · Registry code 17219
- [Continental IOF-550-D](https://openairdocs.org/engine/continental-iof-550-d.md): 0 registered aircraft · Registry code 17220
- [Continental IOF-550-E](https://openairdocs.org/engine/continental-iof-550-e.md): 0 registered aircraft · Registry code 17223
- [Continental IOF-550-F](https://openairdocs.org/engine/continental-iof-550-f.md): 0 registered aircraft · Registry code 17221
- [Continental IOF-550-L](https://openairdocs.org/engine/continental-iof-550-l.md): 0 registered aircraft · Registry code 17222
- [Continental IOF-550-P](https://openairdocs.org/engine/continental-iof-550-p.md): 0 registered aircraft · Registry code 17225
- [Continental IOF-550-R](https://openairdocs.org/engine/continental-iof-550-r.md): 0 registered aircraft · Registry code 17226

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

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