# Registry models it may concern: SAIB CE-11-40

A list on [SAIB CE-11-40](https://openairdocs.org/saib/CE-11-40.md).

Registry airframe and engine models matched to the bulletin’s products the same way as ADs, most registered aircraft first.

- [Grumman Acft ENG Cor-Schweizer G-164B](https://openairdocs.org/model/grumman-acft-eng-cor-schweizer-g-164b.md): 157 registered aircraft · Airframe model
- [Grumman Acft ENG Cor-Schweizer G-164A](https://openairdocs.org/model/grumman-acft-eng-cor-schweizer-g-164a.md): 150 registered aircraft · Airframe model
- [Grumman G-164A](https://openairdocs.org/model/grumman-g-164a.md): 63 registered aircraft · Airframe model
- [Schweizer G-164B](https://openairdocs.org/model/schweizer-g-164b.md): 56 registered aircraft · Airframe model
- [Grumman G-164](https://openairdocs.org/model/grumman-g-164.md): 52 registered aircraft · Airframe model
- [Gulfstream-Schweizer A/C GULFSTREAM AM G-164B](https://openairdocs.org/model/gulfstream-schweizer-a-c-gulfstream-am-g-164b.md): 33 registered aircraft · Airframe model
- [Grumman Acft ENG Cor-Schweizer G-164C](https://openairdocs.org/model/grumman-acft-eng-cor-schweizer-g-164c.md): 18 registered aircraft · Airframe model
- [Grumman American Avn. G-164B](https://openairdocs.org/model/grumman-american-avn-g-164b.md): 6 registered aircraft · Airframe model
- [Ag-Cat G-164B](https://openairdocs.org/model/ag-cat-g-164b.md): 5 registered aircraft · Airframe model
- [Grumman American Avn. G-164](https://openairdocs.org/model/grumman-american-avn-g-164.md): 3 registered aircraft · Airframe model
- [Grumman American Avn. G-164A](https://openairdocs.org/model/grumman-american-avn-g-164a.md): 3 registered aircraft · Airframe model
- [Gulfstream-Schweizer A/C GULFSTREAM AM G-164D](https://openairdocs.org/model/gulfstream-schweizer-a-c-gulfstream-am-g-164d.md): 3 registered aircraft · Airframe model
- [Schweizer G-164B-20T](https://openairdocs.org/model/schweizer-g-164b-20t.md): 3 registered aircraft · Airframe model
- [Grumman G-164B](https://openairdocs.org/model/grumman-g-164b.md): 2 registered aircraft · Airframe model
- [Grumman G164C](https://openairdocs.org/model/grumman-g164c.md): 2 registered aircraft · Airframe model
- [Grumman/Schweizer G-164D](https://openairdocs.org/model/grumman-schweizer-g-164d.md): 2 registered aircraft · Airframe model
- [Schweizer G164B-34T](https://openairdocs.org/model/schweizer-g164b-34t.md): 2 registered aircraft · Airframe model
- [Gulfstream Schweizer A/C GULFSTREAM AM G-164C](https://openairdocs.org/model/gulfstream-schweizer-a-c-gulfstream-am-g-164c.md): 1 registered aircraft · Airframe model
- [Schweizer G-164C](https://openairdocs.org/model/schweizer-g-164c.md): 1 registered aircraft · Airframe model
- [Schweizer G-164D](https://openairdocs.org/model/schweizer-g-164d.md): 1 registered aircraft · Airframe model
- [Schweizer G164A](https://openairdocs.org/model/schweizer-g164a.md): 1 registered aircraft · Airframe model
- [Grumman G-164B-15T](https://openairdocs.org/model/grumman-g-164b-15t.md): 0 registered aircraft · Airframe model
- [Grumman G-164D](https://openairdocs.org/model/grumman-g-164d.md): 0 registered aircraft · Airframe model
- [Schweizer G-164](https://openairdocs.org/model/schweizer-g-164.md): 0 registered aircraft · Airframe model

## 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 aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_saib.parquet' WHERE saib_id = 'EDBF1CD7D62229F7862578AB0066F9D2')
GROUP BY ALL
UNION ALL
SELECT 'engine' AS kind, m.code, m.manufacturer, m.model, count(g.n_number) AS aircraft
FROM 'https://openairdocs.org/data/latest/faa_engine_model.parquet' m LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g ON g.engine_model_code = m.code
WHERE m.code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_saib.parquet' WHERE saib_id = 'EDBF1CD7D62229F7862578AB0066F9D2')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

This list as a web page: https://openairdocs.org/saib/CE-11-40/models

---
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.