# Registered aircraft: TCDS 7H1

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

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

- [S N I A S SE 3130 ALOUETTE II](https://openairdocs.org/model/s-n-i-a-s-se-3130-alouette-ii.md): 7 registered aircraft · Registry code 8680502
- [S N I A S SA 318C ALOUETTE AST](https://openairdocs.org/model/s-n-i-a-s-sa-318c-alouette-ast.md): 4 registered aircraft · Registry code 8680511
- [Sud SA 318C](https://openairdocs.org/model/sud-sa-318c.md): 4 registered aircraft · Registry code 8680501
- [Sud Aviation/Eurocopter ALOUETTE II SE313B](https://openairdocs.org/model/sud-aviation-eurocopter-alouette-ii-se313b.md): 2 registered aircraft · Registry code 8680507
- [Aerospatiale SA 318C ALOUETTE AST](https://openairdocs.org/model/aerospatiale-sa-318c-alouette-ast.md): 1 registered aircraft · Registry code 8680514
- [Aerospatiale SA-318C ALOUETTE II](https://openairdocs.org/model/aerospatiale-sa-318c-alouette-ii.md): 1 registered aircraft · Registry code 8680520
- [Sud SA 313B II ALLOUETTE](https://openairdocs.org/model/sud-sa-313b-ii-allouette.md): 1 registered aircraft · Registry code 8680840
- [Sud SA 318C ALOUETTE AST](https://openairdocs.org/model/sud-sa-318c-alouette-ast.md): 1 registered aircraft · Registry code 8680508
- [Sud SE3130 ALOUETTE II](https://openairdocs.org/model/sud-se3130-alouette-ii.md): 1 registered aircraft · Registry code 8680210
- [Airbus Helicopters EC 225 LP](https://openairdocs.org/model/airbus-helicopters-ec-225-lp.md): 0 registered aircraft · Registry code 8682990
- [Airbus Helicopters SA 318C](https://openairdocs.org/model/airbus-helicopters-sa-318c.md): 0 registered aircraft · Registry code 8680779
- [Eurocopter France SA 318 C ALOUETTE](https://openairdocs.org/model/eurocopter-france-sa-318-c-alouette.md): 0 registered aircraft · Registry code 868097B
- [Eurocopter France SE 3130](https://openairdocs.org/model/eurocopter-france-se-3130.md): 0 registered aircraft · Registry code 8680968
- [Eurocopter/France SE313B](https://openairdocs.org/model/eurocopter-france-se313b.md): 0 registered aircraft · Registry code 8680972
- [S N I A S SA 3180 ALOUETTE-AST](https://openairdocs.org/model/s-n-i-a-s-sa-3180-alouette-ast.md): 0 registered aircraft · Registry code 8680506
- [Sud SE313B ALOUETTE II](https://openairdocs.org/model/sud-se313b-alouette-ii.md): 0 registered aircraft · Registry code 8680823

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

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