# Registered aircraft: TCDS H1CE

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

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

- [Enstrom F-28F](https://openairdocs.org/model/enstrom-f-28f.md): 62 registered aircraft · Registry code 3300412
- [Enstrom Helicopter 480B](https://openairdocs.org/model/enstrom-helicopter-480b.md): 59 registered aircraft · Registry code 3300561
- [Enstrom 280FX](https://openairdocs.org/model/enstrom-280fx.md): 58 registered aircraft · Registry codes 3300506, 330050A
- [Enstrom Helicopter 280C](https://openairdocs.org/model/enstrom-helicopter-280c.md): 48 registered aircraft · Registry code 3300505
- [Enstrom F-28C](https://openairdocs.org/model/enstrom-f-28c.md): 46 registered aircraft · Registry code 3300407
- [Enstrom F-28A](https://openairdocs.org/model/enstrom-f-28a.md): 38 registered aircraft · Registry code 3300406
- [Enstrom Helicopter 480](https://openairdocs.org/model/enstrom-helicopter-480.md): 14 registered aircraft · Registry code 3300560
- [Enstrom Helicopter 280FX](https://openairdocs.org/model/enstrom-helicopter-280fx.md): 7 registered aircraft · Registry code 3300551
- [Enstrom Helicopter 280F](https://openairdocs.org/model/enstrom-helicopter-280f.md): 6 registered aircraft · Registry code 3300550
- [Enstrom 280](https://openairdocs.org/model/enstrom-280.md): 5 registered aircraft · Registry code 3300502
- [Enstrom Helicopter F28F](https://openairdocs.org/model/enstrom-helicopter-f28f.md): 2 registered aircraft · Registry code 3300413
- [Enstrom F-28](https://openairdocs.org/model/enstrom-f-28.md): 1 registered aircraft · Registry code 3300404
- [Enstrom Helicopter F-28A](https://openairdocs.org/model/enstrom-helicopter-f-28a.md): 1 registered aircraft · Registry code 3300401
- [Enstrom Helicopter TH-28](https://openairdocs.org/model/enstrom-helicopter-th-28.md): 1 registered aircraft · Registry code 3300435
- [Enstrom F-28B](https://openairdocs.org/model/enstrom-f-28b.md): 0 registered aircraft · Registry code 3300405
- [Enstrom T-28](https://openairdocs.org/model/enstrom-t-28.md): 0 registered aircraft · Registry code 3300430

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

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