# Registered aircraft: TCDS 3E1

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

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

- [Continental IO-470-L](https://openairdocs.org/engine/continental-io-470-l.md): 22 registered aircraft · Registry code 17348
- [Continental IO-470-N](https://openairdocs.org/engine/continental-io-470-n.md): 12 registered aircraft · Registry code 17358
- [Continental IO-470-F](https://openairdocs.org/engine/continental-io-470-f.md): 9 registered aircraft · Registry code 17347
- [Continental IO-470-VO](https://openairdocs.org/engine/continental-io-470-vo.md): 8 registered aircraft · Registry code 17354
- [Continental IO-470-D](https://openairdocs.org/engine/continental-io-470-d.md): 7 registered aircraft · Registry code 17345
- [Continental IO-470-S](https://openairdocs.org/engine/continental-io-470-s.md): 7 registered aircraft · Registry code 17351
- [Continental IO-470-K](https://openairdocs.org/engine/continental-io-470-k.md): 5 registered aircraft · Registry code 17360
- [Continental IO-470-R](https://openairdocs.org/engine/continental-io-470-r.md): 5 registered aircraft · Registry code 17356
- [Continental IO-470-J](https://openairdocs.org/engine/continental-io-470-j.md): 2 registered aircraft · Registry code 17359
- [Continental IO-470-U](https://openairdocs.org/engine/continental-io-470-u.md): 2 registered aircraft · Registry code 17352
- [Continental IO-470-H](https://openairdocs.org/engine/continental-io-470-h.md): 1 registered aircraft · Registry code 17357
- [Continental IO-470-V](https://openairdocs.org/engine/continental-io-470-v.md): 1 registered aircraft · Registry code 17353
- [Continental IO-470-E](https://openairdocs.org/engine/continental-io-470-e.md): 0 registered aircraft · Registry code 17346
- [Continental IO-470-G](https://openairdocs.org/engine/continental-io-470-g.md): 0 registered aircraft · Registry code 17355
- [Continental IO-470-LO](https://openairdocs.org/engine/continental-io-470-lo.md): 0 registered aircraft · Registry code 17349
- [Continental IO-470-M](https://openairdocs.org/engine/continental-io-470-m.md): 0 registered aircraft · Registry code 17350
- [Continental IO-470-P](https://openairdocs.org/engine/continental-io-470-p.md): 0 registered aircraft · Registry code 17361
- [Continental IO-470-T](https://openairdocs.org/engine/continental-io-470-t.md): 0 registered aircraft · Registry code 17362
- [Continental L/IO-470-A](https://openairdocs.org/engine/continental-l-io-470-a.md): 0 registered aircraft · Registry code 17363

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

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