# Registered aircraft: TCDS A4CE

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

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

- [Cessna T206H](https://openairdocs.org/model/cessna-t206h.md): 691 registered aircraft · Registry code 2073303
- [Textron T206H](https://openairdocs.org/model/textron-t206h.md): 367 registered aircraft · Registry code 2073343
- [Cessna U206G](https://openairdocs.org/model/cessna-u206g.md): 347 registered aircraft · Registry codes 2073356, 2073315, 2073314
- [Cessna U206F](https://openairdocs.org/model/cessna-u206f.md): 230 registered aircraft · Registry codes 2073333, 207333A
- [Cessna TU206G](https://openairdocs.org/model/cessna-tu206g.md): 207 registered aircraft · Registry code 2073357
- [Cessna 206H](https://openairdocs.org/model/cessna-206h.md): 158 registered aircraft · Registry codes 2073301, 2073307
- [Cessna TU206F](https://openairdocs.org/model/cessna-tu206f.md): 87 registered aircraft · Registry code 2073353
- [Cessna 206](https://openairdocs.org/model/cessna-206.md): 55 registered aircraft · Registry code 2073302
- [Cessna P206](https://openairdocs.org/model/cessna-p206.md): 53 registered aircraft · Registry code 2073304
- [Cessna U206](https://openairdocs.org/model/cessna-u206.md): 52 registered aircraft · Registry code 2073306
- [Cessna U206C](https://openairdocs.org/model/cessna-u206c.md): 47 registered aircraft · Registry code 2073332
- [Cessna U206B](https://openairdocs.org/model/cessna-u206b.md): 43 registered aircraft · Registry code 2073322
- [Cessna P206A](https://openairdocs.org/model/cessna-p206a.md): 31 registered aircraft · Registry code 2073308
- [Cessna U206E](https://openairdocs.org/model/cessna-u206e.md): 31 registered aircraft · Registry code 2073350
- [Cessna P206D](https://openairdocs.org/model/cessna-p206d.md): 28 registered aircraft · Registry code 2073338
- [Cessna U206D](https://openairdocs.org/model/cessna-u206d.md): 26 registered aircraft · Registry code 2073342
- [Cessna P206B](https://openairdocs.org/model/cessna-p206b.md): 24 registered aircraft · Registry code 2073309
- [Cessna U206A](https://openairdocs.org/model/cessna-u206a.md): 22 registered aircraft · Registry code 2073316
- [Cessna P206C](https://openairdocs.org/model/cessna-p206c.md): 18 registered aircraft · Registry code 2073312
- [Cessna TU206B](https://openairdocs.org/model/cessna-tu206b.md): 18 registered aircraft · Registry code 2073324
- [Cessna TU206C](https://openairdocs.org/model/cessna-tu206c.md): 13 registered aircraft · Registry code 2073334
- [Cessna TU206A](https://openairdocs.org/model/cessna-tu206a.md): 12 registered aircraft · Registry code 2073318
- [Cessna P206E](https://openairdocs.org/model/cessna-p206e.md): 9 registered aircraft · Registry code 2073346
- [Cessna TP206C](https://openairdocs.org/model/cessna-tp206c.md): 7 registered aircraft · Registry code 2073313
- [Cessna TP206A](https://openairdocs.org/model/cessna-tp206a.md): 6 registered aircraft · Registry code 2073310
- [Cessna TP206B](https://openairdocs.org/model/cessna-tp206b.md): 6 registered aircraft · Registry code 2073311
- [Cessna TU206D](https://openairdocs.org/model/cessna-tu206d.md): 5 registered aircraft · Registry code 2073344
- [Cessna TP206D](https://openairdocs.org/model/cessna-tp206d.md): 4 registered aircraft · Registry code 2073340
- [Cessna TP206E](https://openairdocs.org/model/cessna-tp206e.md): 2 registered aircraft · Registry code 2073348
- [Cessna TU206E](https://openairdocs.org/model/cessna-tu206e.md): 1 registered aircraft · Registry code 2073352

## 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 'aircraft' AS kind, m.code, m.manufacturer, m.model, count(g.n_number) AS aircraft
FROM 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g ON g.aircraft_model_code = m.code
WHERE m.code IN (SELECT code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' WHERE tcds_number = 'A4CE')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

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