# Registered aircraft: TCDS A1CE

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

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

- [Beech C23](https://openairdocs.org/model/beech-c23.md): 455 registered aircraft · Registry code 1151242
- [Beech C24R](https://openairdocs.org/model/beech-c24r.md): 176 registered aircraft · Registry code 1151254
- [Beech 23](https://openairdocs.org/model/beech-23.md): 147 registered aircraft · Registry code 1151202
- [Beech B19](https://openairdocs.org/model/beech-b19.md): 145 registered aircraft · Registry code 1151215
- [Beech A23-24](https://openairdocs.org/model/beech-a23-24.md): 121 registered aircraft · Registry code 1151226
- [Beech B24R](https://openairdocs.org/model/beech-b24r.md): 117 registered aircraft · Registry code 1151253
- [Beech A23](https://openairdocs.org/model/beech-a23.md): 85 registered aircraft · Registry code 1151204
- [Beech A23-19](https://openairdocs.org/model/beech-a23-19.md): 72 registered aircraft · Registry code 1151212
- [Beech B23](https://openairdocs.org/model/beech-b23.md): 62 registered aircraft · Registry code 1151240
- [Beech A23A](https://openairdocs.org/model/beech-a23a.md): 51 registered aircraft · Registry code 1151208
- [Beech A24R](https://openairdocs.org/model/beech-a24r.md): 49 registered aircraft · Registry code 1151252
- [Beech 19A](https://openairdocs.org/model/beech-19a.md): 41 registered aircraft · Registry code 1151214
- [Beech B-19 SPORT](https://openairdocs.org/model/beech-b-19-sport.md): 2 registered aircraft · Registry code 1151216
- [Beech C 23](https://openairdocs.org/model/beech-c-23.md): 1 registered aircraft · Registry code 1152975
- [Beech A24](https://openairdocs.org/model/beech-a24.md): 0 registered aircraft · Registry code 1151250
- [Beech M19A](https://openairdocs.org/model/beech-m19a.md): 0 registered aircraft · Registry code 1152900

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

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