# Registered aircraft: TCDS E-252

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

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

- [Continental 0-200 series](https://openairdocs.org/engine/continental-0-200-series.md): 8,790 registered aircraft · Registry code 17020
- [Continental C90 series](https://openairdocs.org/engine/continental-c90-series.md): 2,149 registered aircraft · Registry code 17009
- [Continental O-200](https://openairdocs.org/engine/continental-o-200-series.md): 329 registered aircraft · Registry code 17402
- [Continental O-200A](https://openairdocs.org/engine/continental-o-200a.md): 295 registered aircraft · Registry code 17404
- [Continental O-200-D](https://openairdocs.org/engine/continental-o-200-d.md): 210 registered aircraft · Registry code 17409
- [Continental 0-200-A](https://openairdocs.org/engine/continental-0-200-a.md): 96 registered aircraft · Registry code 17191
- [Continental C90-12F](https://openairdocs.org/engine/continental-c90-12f.md): 54 registered aircraft · Registry code 17183
- [Continental C90-8F](https://openairdocs.org/engine/continental-c90-8f.md): 30 registered aircraft · Registry code 17181
- [Rolls-Royce O-200-A](https://openairdocs.org/engine/rolls-royce-o-200-a.md): 15 registered aircraft · Registry code 54590
- [Continental C90-14F](https://openairdocs.org/engine/continental-c90-14f.md): 11 registered aircraft · Registry code 17187
- [Rolls-Royce 0-200-A](https://openairdocs.org/engine/rolls-royce-0-200-a.md): 11 registered aircraft · Registry code 54532
- [Continental C90-16F](https://openairdocs.org/engine/continental-c90-16f.md): 4 registered aircraft · Registry code 17190
- [Continental O-200-B](https://openairdocs.org/engine/continental-o-200-b.md): 3 registered aircraft · Registry code 17192
- [Rolls Royc C90-14](https://openairdocs.org/engine/rolls-royc-c90-14-series.md): 1 registered aircraft · Registry code 16187
- [Sabrina 0-200-A](https://openairdocs.org/engine/sabrina-0-200-a.md): 1 registered aircraft · Registry code 64532
- [Continental 0-200-C](https://openairdocs.org/engine/continental-0-200-c.md): 0 registered aircraft · Registry code 17193
- [Continental C90-12FH](https://openairdocs.org/engine/continental-c90-12fh.md): 0 registered aircraft · Registry code 17184
- [Continental C90-12FJ](https://openairdocs.org/engine/continental-c90-12fj.md): 0 registered aircraft · Registry code 17185
- [Continental C90-12FP](https://openairdocs.org/engine/continental-c90-12fp.md): 0 registered aircraft · Registry code 17186
- [Continental C90-14FH](https://openairdocs.org/engine/continental-c90-14fh.md): 0 registered aircraft · Registry code 17188
- [Continental C90-14FJ](https://openairdocs.org/engine/continental-c90-14fj.md): 0 registered aircraft · Registry code 17189
- [Continental C90-8FJ](https://openairdocs.org/engine/continental-c90-8fj.md): 0 registered aircraft · Registry code 17182

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

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