# Registered aircraft: TCDS 2H3

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

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

- [Bell 47G-3B-1](https://openairdocs.org/model/bell-47g-3b-1.md): 86 registered aircraft · Registry codes 1181028, 118103A
- [Bell 47G-5](https://openairdocs.org/model/bell-47g-5.md): 40 registered aircraft · Registry code 1181032
- [Bell 47G-3B-2](https://openairdocs.org/model/bell-47g-3b-2.md): 26 registered aircraft · Registry codes 1181029, 1181036
- [Bell 47G-4A](https://openairdocs.org/model/bell-47g-4a.md): 20 registered aircraft · Registry code 1181031
- [Bell 47G-2A](https://openairdocs.org/model/bell-47g-2a.md): 19 registered aircraft · Registry code 1181012
- [Bell 47G-5A](https://openairdocs.org/model/bell-47g-5a.md): 19 registered aircraft · Registry code 1181034
- [Bell 47G-3B](https://openairdocs.org/model/bell-47g-3b.md): 15 registered aircraft · Registry code 1181026
- [Bell 47G-2A-1](https://openairdocs.org/model/bell-47g-2a-1.md): 13 registered aircraft · Registry code 1181014
- [Bell 47G-4](https://openairdocs.org/model/bell-47g-4.md): 13 registered aircraft · Registry code 1181030
- [Bell 47G3B2A](https://openairdocs.org/model/bell-47g3b2a.md): 7 registered aircraft · Registry code 1181025
- [Bell-Huddleston And Wilson 47G-3B1](https://openairdocs.org/model/bell-huddleston-and-wilson-47g-3b1.md): 1 registered aircraft · Registry code 118103H
- [Bell-Intermountain 47G-3B-1](https://openairdocs.org/model/bell-intermountain-47g-3b-1.md): 1 registered aircraft · Registry code 1181027
- [Bell 47G-3](https://openairdocs.org/model/bell-47g-3.md): 0 registered aircraft · Registry code 1181024
- [Bell-K-Copter 47G2A](https://openairdocs.org/model/bell-k-copter-47g2a.md): 0 registered aircraft · Registry code 1181070
- [Bell-K-Copter 47G4](https://openairdocs.org/model/bell-k-copter-47g4.md): 0 registered aircraft · Registry code 118103Z
- [Bell-Moore 47G-2A](https://openairdocs.org/model/bell-moore-47g-2a.md): 0 registered aircraft · Registry code 1181019
- [Bell-Moore 47G-3B](https://openairdocs.org/model/bell-moore-47g-3b.md): 0 registered aircraft · Registry code 118103M
- [Bell-Ranger 47G-5](https://openairdocs.org/model/bell-ranger-47g-5.md): 0 registered aircraft · Registry code 1181033
- [Bell-Snohomish Co Sheriffs OFF 47G-3B](https://openairdocs.org/model/bell-snohomish-co-sheriffs-off-47g-3b.md): 0 registered aircraft · Registry code 1181023
- [Bell-Wessex Helicopters BELL 47G-2A-1](https://openairdocs.org/model/bell-wessex-helicopters-bell-47g-2a-1.md): 0 registered aircraft · Registry code 1181015
- [Bell-Yellow Bird 47G-3B-1](https://openairdocs.org/model/bell-yellow-bird-47g-3b-1.md): 0 registered aircraft · Registry code 118103J
- [Westland Bell 47G3 B1 SOLOY](https://openairdocs.org/model/westland-bell-47g3-b1-soloy.md): 0 registered aircraft · Registry code 9650165

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

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