# Registered aircraft: TCDS 1A16

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

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

- [Grumman Acft ENG Cor-Schweizer G-164B](https://openairdocs.org/model/grumman-acft-eng-cor-schweizer-g-164b.md): 157 registered aircraft · Registry code 3952802
- [Grumman Acft ENG Cor-Schweizer G-164A](https://openairdocs.org/model/grumman-acft-eng-cor-schweizer-g-164a.md): 150 registered aircraft · Registry code 3952801
- [Grumman G-164A](https://openairdocs.org/model/grumman-g-164a.md): 63 registered aircraft · Registry code 3952704
- [Schweizer G-164B](https://openairdocs.org/model/schweizer-g-164b.md): 56 registered aircraft · Registry code 8059055
- [Grumman G-164](https://openairdocs.org/model/grumman-g-164.md): 52 registered aircraft · Registry code 3952702
- [Gulfstream-Schweizer A/C GULFSTREAM AM G-164B](https://openairdocs.org/model/gulfstream-schweizer-a-c-gulfstream-am-g-164b.md): 33 registered aircraft · Registry code 3979904
- [Grumman Acft ENG Cor-Schweizer G-164C](https://openairdocs.org/model/grumman-acft-eng-cor-schweizer-g-164c.md): 18 registered aircraft · Registry code 3952803
- [Grumman American Avn. G-164B](https://openairdocs.org/model/grumman-american-avn-g-164b.md): 6 registered aircraft · Registry codes 3960203, 3960204
- [Ag-Cat G-164B](https://openairdocs.org/model/ag-cat-g-164b.md): 5 registered aircraft · Registry code 1260000
- [Grumman American Avn. G-164](https://openairdocs.org/model/grumman-american-avn-g-164.md): 3 registered aircraft · Registry code 3960201
- [Grumman American Avn. G-164A](https://openairdocs.org/model/grumman-american-avn-g-164a.md): 3 registered aircraft · Registry code 3960202
- [Gulfstream-Schweizer A/C GULFSTREAM AM G-164D](https://openairdocs.org/model/gulfstream-schweizer-a-c-gulfstream-am-g-164d.md): 3 registered aircraft · Registry code 3979908
- [Schweizer G-164B-20T](https://openairdocs.org/model/schweizer-g-164b-20t.md): 3 registered aircraft · Registry code 8059056
- [Grumman G-164B](https://openairdocs.org/model/grumman-g-164b.md): 2 registered aircraft · Registry code 3952703
- [Grumman G164C](https://openairdocs.org/model/grumman-g164c.md): 2 registered aircraft · Registry code 3950409
- [Grumman/Schweizer G-164D](https://openairdocs.org/model/grumman-schweizer-g-164d.md): 2 registered aircraft · Registry code 3952804
- [Schweizer G164B-34T](https://openairdocs.org/model/schweizer-g164b-34t.md): 2 registered aircraft · Registry code 8058057
- [Gulfstream Schweizer A/C GULFSTREAM AM G-164C](https://openairdocs.org/model/gulfstream-schweizer-a-c-gulfstream-am-g-164c.md): 1 registered aircraft · Registry code 3979906
- [Schweizer G-164C](https://openairdocs.org/model/schweizer-g-164c.md): 1 registered aircraft · Registry code 8059057
- [Schweizer G-164D](https://openairdocs.org/model/schweizer-g-164d.md): 1 registered aircraft · Registry code 8059059
- [Schweizer G164A](https://openairdocs.org/model/schweizer-g164a.md): 1 registered aircraft · Registry code 8059053
- [Grumman G-164B-15T](https://openairdocs.org/model/grumman-g-164b-15t.md): 0 registered aircraft · Registry code 3952701
- [Grumman G-164D](https://openairdocs.org/model/grumman-g-164d.md): 0 registered aircraft · Registry code 3952700
- [Schweizer G-164](https://openairdocs.org/model/schweizer-g-164.md): 0 registered aircraft · Registry code 8059050

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

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