# Registered aircraft: TCDS 5A4

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

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

- [Beech D-50](https://openairdocs.org/model/beech-d-50.md): 21 registered aircraft · Registry code 1152512
- [Beech C-50](https://openairdocs.org/model/beech-c-50.md): 20 registered aircraft · Registry code 1152510
- [Beech D50E](https://openairdocs.org/model/beech-d50e.md): 18 registered aircraft · Registry code 1152522
- [Beech D50C](https://openairdocs.org/model/beech-d50c.md): 16 registered aircraft · Registry code 1152520
- [Beech B50](https://openairdocs.org/model/beech-b50.md): 13 registered aircraft · Registry code 1152506
- [Beech E50](https://openairdocs.org/model/beech-e50.md): 11 registered aircraft · Registry code 1152524
- [Beech D50A](https://openairdocs.org/model/beech-d50a.md): 5 registered aircraft · Registry code 1152516
- [Beech D50B](https://openairdocs.org/model/beech-d50b.md): 5 registered aircraft · Registry code 1152518
- [Beech H50](https://openairdocs.org/model/beech-h50.md): 5 registered aircraft · Registry code 1152534
- [Beech J50](https://openairdocs.org/model/beech-j50.md): 4 registered aircraft · Registry code 1152536
- [Beech 50](https://openairdocs.org/model/beech-50.md): 2 registered aircraft · Registry code 1152502
- [Beech/Bond E50](https://openairdocs.org/model/beech-bond-e50.md): 2 registered aircraft · Registry code 1152523
- [Beech F50](https://openairdocs.org/model/beech-f50.md): 1 registered aircraft · Registry code 1152530
- [Beech G50](https://openairdocs.org/model/beech-g50.md): 1 registered aircraft · Registry code 1152532
- [Beech D50E-5990](https://openairdocs.org/model/beech-d50e-5990.md): 0 registered aircraft · Registry code 1152894
- [Douglas C-50](https://openairdocs.org/model/douglas-c-50.md): 0 registered aircraft · Registry code 3021410
- [Hawker Hunter MK 50](https://openairdocs.org/model/hawker-hunter-mk-50.md): 0 registered aircraft · Registry code 4230303

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

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