# Registered aircraft: TCDS 4H12

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

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

- [Schweizer 269C](https://openairdocs.org/model/schweizer-269c.md): 115 registered aircraft · Registry code 8059502
- [Hughes 269A](https://openairdocs.org/model/hughes-269a.md): 97 registered aircraft · Registry code 4470402
- [Schweizer 269C-1](https://openairdocs.org/model/schweizer-269c-1.md): 84 registered aircraft · Registry code 8059504
- [Hughes 269C](https://openairdocs.org/model/hughes-269c.md): 74 registered aircraft · Registry code 4470504
- [Hughes 269B](https://openairdocs.org/model/hughes-269b.md): 31 registered aircraft · Registry code 4470502
- [Hughes TH-55](https://openairdocs.org/model/hughes-th-55.md): 13 registered aircraft · Registry code 4471002
- [Schweizer 269D](https://openairdocs.org/model/schweizer-269d.md): 12 registered aircraft · Registry code 8059501
- [Hughes TH-55A](https://openairdocs.org/model/hughes-th-55a.md): 7 registered aircraft · Registry code 4471004
- [Schweizer TH55A/269A](https://openairdocs.org/model/schweizer-th55a-269a.md): 6 registered aircraft · Registry code 8059503
- [Hughes 269A-1](https://openairdocs.org/model/hughes-269a-1.md): 5 registered aircraft · Registry code 4470404
- [Schweizer HUGHES 269C](https://openairdocs.org/model/schweizer-hughes-269c.md): 4 registered aircraft · Registry code 8059500
- [Schweizer RSG 269C](https://openairdocs.org/model/schweizer-rsg-269c.md): 3 registered aircraft · Registry code 8059498
- [Schweizer 300C](https://openairdocs.org/model/schweizer-300c.md): 2 registered aircraft · Registry code 8059320
- [Schweizer RSG 269C-1](https://openairdocs.org/model/schweizer-rsg-269c-1.md): 2 registered aircraft · Registry code 8059499
- [Schweizer 269A](https://openairdocs.org/model/schweizer-269a.md): 1 registered aircraft · Registry code 8059506
- [Schweizer Aircraft Co USA SCHWEIZER 300C/269C](https://openairdocs.org/model/schweizer-aircraft-co-usa-schweizer-300c-269c.md): 1 registered aircraft · Registry code 8059507
- [Hughes 269A (TH55)](https://openairdocs.org/model/hughes-269a-th55.md): 0 registered aircraft · Registry code 4470405
- [Hughes-Filipoff 269A](https://openairdocs.org/model/hughes-filipoff-269a.md): 0 registered aircraft · Registry code 4470403
- [Schweizer 300CB](https://openairdocs.org/model/schweizer-300cb.md): 0 registered aircraft · Registry code 8059321
- [Sikorsky 269C](https://openairdocs.org/model/sikorsky-269c.md): 0 registered aircraft · Registry code 8140301
- [Sikorsky 269D](https://openairdocs.org/model/sikorsky-269d.md): 0 registered aircraft · Registry code 8143022

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

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