# Registered aircraft: TCDS H-1

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

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

- [Bell 47G-2](https://openairdocs.org/model/bell-47g-2.md): 87 registered aircraft · Registry code 1181008
- [Bell 47G](https://openairdocs.org/model/bell-47g.md): 55 registered aircraft · Registry code 1181002
- [Bell 47D1](https://openairdocs.org/model/bell-47d1.md): 47 registered aircraft · Registry code 1180802
- [Bell 47H-1](https://openairdocs.org/model/bell-47h-1.md): 6 registered aircraft · Registry code 1181011
- [Bell 47D](https://openairdocs.org/model/bell-47d.md): 4 registered aircraft · Registry code 1180702
- [Bell-K-Copter 47G](https://openairdocs.org/model/bell-k-copter-47g.md): 2 registered aircraft · Registry code 1181065
- [Bell 47B](https://openairdocs.org/model/bell-47b.md): 1 registered aircraft · Registry code 1180604
- [Bell Kitz Kopters 47D1](https://openairdocs.org/model/bell-kitz-kopters-47d1.md): 1 registered aircraft · Registry code 1180844
- [Bell-Allied Helicopter 47D1](https://openairdocs.org/model/bell-allied-helicopter-47d1.md): 1 registered aircraft · Registry code 118084C
- [Bell-Carson 47G](https://openairdocs.org/model/bell-carson-47g.md): 1 registered aircraft · Registry code 1181001
- [Bell-K-Copter 47G-2](https://openairdocs.org/model/bell-k-copter-47g-2.md): 1 registered aircraft · Registry code 1181066
- [Bell-Olympic Helicopters 47G2](https://openairdocs.org/model/bell-olympic-helicopters-47g2.md): 1 registered aircraft · Registry code 1181306
- [Bell-Shippey BELL 47G](https://openairdocs.org/model/bell-shippey-bell-47g.md): 1 registered aircraft · Registry code 118084G
- [Bell-Tellijohn 47G-2](https://openairdocs.org/model/bell-tellijohn-47g-2.md): 1 registered aircraft · Registry code 1181013
- [Bell-Transworld Helicopter Cor 47G-2](https://openairdocs.org/model/bell-transworld-helicopter-cor-47g-2.md): 1 registered aircraft · Registry code 1181071
- [Bell-Yehnert 47G-2](https://openairdocs.org/model/bell-yehnert-47g-2.md): 1 registered aircraft · Registry code 1181310
- [Continental Copters 47G](https://openairdocs.org/model/continental-copters-47g.md): 1 registered aircraft · Registry code 2390105
- [Agusta Bell 47D-1](https://openairdocs.org/model/agusta-bell-47d-1.md): 0 registered aircraft · Registry code 0264716
- [Bell - K Copter 47D1](https://openairdocs.org/model/bell-k-copter-47d1.md): 0 registered aircraft · Registry code 1180843
- [Bell 47](https://openairdocs.org/model/bell-47.md): 0 registered aircraft · Registry code 1180602
- [Bell 47B3](https://openairdocs.org/model/bell-47b3.md): 0 registered aircraft · Registry code 1180606
- [Bell 47E](https://openairdocs.org/model/bell-47e.md): 0 registered aircraft · Registry code 1180902
- [Bell Helicopter Charter BELL 47G2](https://openairdocs.org/model/bell-helicopter-charter-bell-47g2.md): 0 registered aircraft · Registry code 1181072
- [Bell World Helicopters 47D1](https://openairdocs.org/model/bell-world-helicopters-47d1.md): 0 registered aircraft · Registry code 118084V
- [Bell-Action 47G](https://openairdocs.org/model/bell-action-47g.md): 0 registered aircraft · Registry code 118084P
- [Bell-Action 47G-2](https://openairdocs.org/model/bell-action-47g-2.md): 0 registered aircraft · Registry code 1181003
- [Bell-Agri Helicopter 47G-2](https://openairdocs.org/model/bell-agri-helicopter-47g-2.md): 0 registered aircraft · Registry code 1180822
- [Bell-Aviation Service 47G- CD-1](https://openairdocs.org/model/bell-aviation-service-47g-cd-1.md): 0 registered aircraft · Registry code 1181078
- [Bell-Barnes 47D1](https://openairdocs.org/model/bell-barnes-47d1.md): 0 registered aircraft · Registry code 118084E
- [Bell-Daytona Beach 47-G](https://openairdocs.org/model/bell-daytona-beach-47-g.md): 0 registered aircraft · Registry code 1181017
- [Bell-Faulkenberry 47-G](https://openairdocs.org/model/bell-faulkenberry-47-g.md): 0 registered aircraft · Registry code 1181067
- [Bell-Florida Helicopters 47D1](https://openairdocs.org/model/bell-florida-helicopters-47d1.md): 0 registered aircraft · Registry code 118084H
- [Bell-Florida Helicopters 47G](https://openairdocs.org/model/bell-florida-helicopters-47g.md): 0 registered aircraft · Registry code 1181063
- [Bell-Gilbert 47D1](https://openairdocs.org/model/bell-gilbert-47d1.md): 0 registered aircraft · Registry code 118084D
- [Bell-Great Valley Aviation Cor 47-G-2](https://openairdocs.org/model/bell-great-valley-aviation-cor-47-g-2.md): 0 registered aircraft · Registry code 1181009
- [Bell-Gulf Coast 47D1](https://openairdocs.org/model/bell-gulf-coast-47d1.md): 0 registered aircraft · Registry code 118084K
- [Bell-Houston 47D1](https://openairdocs.org/model/bell-houston-47d1.md): 0 registered aircraft · Registry code 118084M
- [Bell-Huddleston 47G2](https://openairdocs.org/model/bell-huddleston-47g2.md): 0 registered aircraft · Registry code 1181074
- [Bell-Huddleston-Wilson 47G2](https://openairdocs.org/model/bell-huddleston-wilson-47g2.md): 0 registered aircraft · Registry code 1181076
- [Bell-Moore 47D1](https://openairdocs.org/model/bell-moore-47d1.md): 0 registered aircraft · Registry code 1180847
- [Bell-Morales 47G-2](https://openairdocs.org/model/bell-morales-47g-2.md): 0 registered aircraft · Registry code 1181064
- [Bell-Odom 47G-2](https://openairdocs.org/model/bell-odom-47g-2.md): 0 registered aircraft · Registry code 1181021
- [Bell-Pinellas 47G-2](https://openairdocs.org/model/bell-pinellas-47g-2.md): 0 registered aircraft · Registry code 1181301
- [Bell-Redi-Copters 47G2](https://openairdocs.org/model/bell-redi-copters-47g2.md): 0 registered aircraft · Registry code 1181073
- [Bell-Regan 47D1](https://openairdocs.org/model/bell-regan-47d1.md): 0 registered aircraft · Registry code 118084R
- [Bell-Shelby Aero 47G2](https://openairdocs.org/model/bell-shelby-aero-47g2.md): 0 registered aircraft · Registry code 1181068
- [Bell-Transworld Helicopters 47D1](https://openairdocs.org/model/bell-transworld-helicopters-47d1.md): 0 registered aircraft · Registry code 1180845
- [Bell-Versatile 47G](https://openairdocs.org/model/bell-versatile-47g.md): 0 registered aircraft · Registry code 118100V
- [Bell-Watson 47-G](https://openairdocs.org/model/bell-watson-47-g.md): 0 registered aircraft · Registry code 1181077
- [Bell-Wilson 47G](https://openairdocs.org/model/bell-wilson-47g.md): 0 registered aircraft · Registry code 1181075
- [Bell/Alcopters 47G2 MODIFIED](https://openairdocs.org/model/bell-alcopters-47g2-modified.md): 0 registered aircraft · Registry code 1181315
- [Continental Copters 47-G2](https://openairdocs.org/model/continental-copters-47-g2.md): 0 registered aircraft · Registry code 2390106
- [Houston Helicopters 47-G](https://openairdocs.org/model/houston-helicopters-47-g.md): 0 registered aircraft · Registry code 05636J3
- [K Copters 47G-2](https://openairdocs.org/model/k-copters-47g-2.md): 0 registered aircraft · Registry code 056337C

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

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