# Registered aircraft: TCDS 3A20

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

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

- [Beech C90](https://openairdocs.org/model/beech-c90.md): 216 registered aircraft · Registry codes 1152913, 1153928
- [Raytheon C90A](https://openairdocs.org/model/raytheon-c90a.md): 155 registered aircraft · Registry code 7150004
- [Beech E-90](https://openairdocs.org/model/beech-e-90.md): 145 registered aircraft · Registry code 1152914
- [Beech C90A](https://openairdocs.org/model/beech-c90a.md): 125 registered aircraft · Registry codes 1152911, 115291A
- [Beech 65-A90-1](https://openairdocs.org/model/beech-65-a90-1.md): 90 registered aircraft · Registry code 1152901
- [Hawker Beechcraft C90GTI](https://openairdocs.org/model/hawker-beechcraft-c90gti.md): 57 registered aircraft · Registry code 4220017
- [Beech 65-A90](https://openairdocs.org/model/beech-65-a90.md): 34 registered aircraft · Registry code 1152908
- [Beech B90](https://openairdocs.org/model/beech-b90.md): 29 registered aircraft · Registry code 1152912
- [Raytheon C90GT](https://openairdocs.org/model/raytheon-c90gt.md): 25 registered aircraft · Registry code 7150062
- [Beech 65](https://openairdocs.org/model/beech-65.md): 22 registered aircraft · Registry code 1152802
- [Beechcraft C90GTI](https://openairdocs.org/model/beechcraft-c90gti.md): 17 registered aircraft · Registry code 4220030
- [Beech 65-B80](https://openairdocs.org/model/beech-65-b80.md): 15 registered aircraft · Registry code 1152812
- [Beech 65-A90-4](https://openairdocs.org/model/beech-65-a90-4.md): 13 registered aircraft · Registry code 1152811
- [Beech 65-90](https://openairdocs.org/model/beech-65-90.md): 7 registered aircraft · Registry code 1152904
- [Beech 65 (LF-23F)](https://openairdocs.org/model/beech-65-lf-23f.md): 6 registered aircraft · Registry code 1152804
- [Beech A65](https://openairdocs.org/model/beech-a65.md): 6 registered aircraft · Registry code 1152803
- [Hawker Beechcraft C90GT](https://openairdocs.org/model/hawker-beechcraft-c90gt.md): 6 registered aircraft · Registry code 4220002
- [Textron C90GTI](https://openairdocs.org/model/textron-c90gti.md): 6 registered aircraft · Registry code 4226568
- [Beech 70](https://openairdocs.org/model/beech-70.md): 4 registered aircraft · Registry code 1152807
- [Beech 65-88](https://openairdocs.org/model/beech-65-88.md): 3 registered aircraft · Registry code 1152809
- [Beech 65-A80](https://openairdocs.org/model/beech-65-a80.md): 3 registered aircraft · Registry code 1152808
- [Beech 65-A80-8800](https://openairdocs.org/model/beech-65-a80-8800.md): 3 registered aircraft · Registry code 1152810
- [Beech 65-80](https://openairdocs.org/model/beech-65-80.md): 2 registered aircraft · Registry code 1152806
- [Beech 65 (L23F)](https://openairdocs.org/model/beech-65-l23f.md): 1 registered aircraft · Registry code 1152798
- [Beech 65-A90-1 (U-21A)](https://openairdocs.org/model/beech-65-a90-1-u-21a.md): 1 registered aircraft · Registry code 1152895
- [Beech A65-8200](https://openairdocs.org/model/beech-a65-8200.md): 1 registered aircraft · Registry code 1152805
- [Monocoupe 70](https://openairdocs.org/model/monocoupe-70.md): 1 registered aircraft · Registry code 9250212
- [Raytheon E90](https://openairdocs.org/model/raytheon-e90.md): 1 registered aircraft · Registry code 7150051
- [Rockwell International 65](https://openairdocs.org/model/rockwell-international-65.md): 1 registered aircraft · Registry code 7630704
- [Beech H90 (T-44A)](https://openairdocs.org/model/beech-h90-t-44a.md): 0 registered aircraft · Registry code 1152939

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

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