# Registered aircraft: TCDS 7A15

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

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

- [Pilatus PC-6/B2-H4](https://openairdocs.org/model/pilatus-pc-6-b2-h4.md): 11 registered aircraft · Registry codes 7090215, 7090217
- [Pilatus PC-6/B2-H2](https://openairdocs.org/model/pilatus-pc-6-b2-h2.md): 8 registered aircraft · Registry code 7090213
- [Pilatus PC-6/B1-H2](https://openairdocs.org/model/pilatus-pc-6-b1-h2.md): 2 registered aircraft · Registry code 7090212
- [Pilatus PC-6](https://openairdocs.org/model/pilatus-pc-6.md): 1 registered aircraft · Registry code 7090102
- [Pilatus PC-6 PORTER](https://openairdocs.org/model/pilatus-pc-6-porter.md): 0 registered aircraft · Registry code 7090112
- [Pilatus PC-6-H1](https://openairdocs.org/model/pilatus-pc-6-h1.md): 0 registered aircraft · Registry code 7090106
- [Pilatus PC-6-H2](https://openairdocs.org/model/pilatus-pc-6-h2.md): 0 registered aircraft · Registry code 7090110
- [Pilatus PC-6/350](https://openairdocs.org/model/pilatus-pc-6-350.md): 0 registered aircraft · Registry code 7090114
- [Pilatus PC-6/350-H1](https://openairdocs.org/model/pilatus-pc-6-350-h1.md): 0 registered aircraft · Registry code 7090118
- [Pilatus PC-6/350-H2](https://openairdocs.org/model/pilatus-pc-6-350-h2.md): 0 registered aircraft · Registry code 7090122
- [Pilatus PC-6/A](https://openairdocs.org/model/pilatus-pc-6-a.md): 0 registered aircraft · Registry code 7090202
- [Pilatus PC-6/A-H1](https://openairdocs.org/model/pilatus-pc-6-a-h1.md): 0 registered aircraft · Registry code 7090204
- [Pilatus PC-6/A-H2](https://openairdocs.org/model/pilatus-pc-6-a-h2.md): 0 registered aircraft · Registry code 7090206
- [Pilatus PC-6/B-H2](https://openairdocs.org/model/pilatus-pc-6-b-h2.md): 0 registered aircraft · Registry code 7090210
- [Pilatus PC-6/C1-H2](https://openairdocs.org/model/pilatus-pc-6-c1-h2.md): 0 registered aircraft · Registry code 7090211
- [Pilatus Porter PC-6/C-H2](https://openairdocs.org/model/pilatus-porter-pc-6-c-h2.md): 0 registered aircraft · Registry code 7090214

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

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