# Registered aircraft: TCDS 6H2

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

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

- [Hiller UH-12B](https://openairdocs.org/model/hiller-uh-12b.md): 35 registered aircraft · Registry code 4360110
- [Hiller UH-12C](https://openairdocs.org/model/hiller-uh-12c.md): 31 registered aircraft · Registry code 4360116
- [Hiller OH-23B](https://openairdocs.org/model/hiller-oh-23b.md): 6 registered aircraft · Registry code 4360109
- [Hiller OH-23C](https://openairdocs.org/model/hiller-oh-23c.md): 3 registered aircraft · Registry code 4360119
- [Hiller - World Helicopters UH-12C](https://openairdocs.org/model/hiller-world-helicopters-uh-12c.md): 2 registered aircraft · Registry code 4360117
- [Hiller H-23B](https://openairdocs.org/model/hiller-h-23b.md): 1 registered aircraft · Registry code 4360114
- [Hiller-Felt UH-12C](https://openairdocs.org/model/hiller-felt-uh-12c.md): 1 registered aircraft · Registry code 4360115
- [Hiller-Heli-Cab UH-12B](https://openairdocs.org/model/hiller-heli-cab-uh-12b.md): 1 registered aircraft · Registry code 4361001
- [Hiller-Helicopter Rep SVC UH-12B](https://openairdocs.org/model/hiller-helicopter-rep-svc-uh-12b.md): 1 registered aircraft · Registry code 4360704
- [Hiller-Stanley UH-12C](https://openairdocs.org/model/hiller-stanley-uh-12c.md): 1 registered aircraft · Registry code 4360105
- [Hiller-Tri-Plex Ind.Inc. UH-12B](https://openairdocs.org/model/hiller-tri-plex-ind-inc-uh-12b.md): 1 registered aircraft · Registry code 4360801
- [Hiller-Trident Helicopters UH-12C](https://openairdocs.org/model/hiller-trident-helicopters-uh-12c.md): 1 registered aircraft · Registry code 4360809
- [Hiller HTE-2](https://openairdocs.org/model/hiller-hte-2.md): 0 registered aircraft · Registry code 4360112
- [Hiller UH-23-C](https://openairdocs.org/model/hiller-uh-23-c.md): 0 registered aircraft · Registry code 4360125
- [Hiller-Clarcq UH-12B](https://openairdocs.org/model/hiller-clarcq-uh-12b.md): 0 registered aircraft · Registry code 4360701
- [Hiller-Frye UH-12C](https://openairdocs.org/model/hiller-frye-uh-12c.md): 0 registered aircraft · Registry code 4360101
- [Hiller-Mitchell UH-12B](https://openairdocs.org/model/hiller-mitchell-uh-12b.md): 0 registered aircraft · Registry code 4360702
- [Hiller-Nunes UH-12C](https://openairdocs.org/model/hiller-nunes-uh-12c.md): 0 registered aircraft · Registry code 4360113
- [Hiller-Palmer UH-12C](https://openairdocs.org/model/hiller-palmer-uh-12c.md): 0 registered aircraft · Registry code 4360810
- [Hiller-Wilco UH-12C](https://openairdocs.org/model/hiller-wilco-uh-12c.md): 0 registered aircraft · Registry code 4360107
- [Hiller/Hansen UH-12B](https://openairdocs.org/model/hiller-hansen-uh-12b.md): 0 registered aircraft · Registry code 4360133
- [Hiller/United Helicopter UH 12C](https://openairdocs.org/model/hiller-united-helicopter-uh-12c.md): 0 registered aircraft · Registry code 4360134
- [Rogerson Hiller H-23B](https://openairdocs.org/model/rogerson-hiller-h-23b.md): 0 registered aircraft · Registry code 4364005
- [Rogerson Hiller H-23C](https://openairdocs.org/model/rogerson-hiller-h-23c.md): 0 registered aircraft · Registry code 4364009
- [Rogerson Hiller HTE-2](https://openairdocs.org/model/rogerson-hiller-hte-2.md): 0 registered aircraft · Registry code 4364003
- [Rogerson Hiller UH-12B](https://openairdocs.org/model/rogerson-hiller-uh-12b.md): 0 registered aircraft · Registry code 4364001
- [Rogerson Hiller UH-12C](https://openairdocs.org/model/rogerson-hiller-uh-12c.md): 0 registered aircraft · Registry code 4364007

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

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