# Registry models it may concern: SAIB CE-12-36

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

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

Page 1 of 4 · 159 models

- [Beech A36](https://openairdocs.org/model/beech-a36.md): 1,907 registered aircraft · Airframe model
- [Beech F33A](https://openairdocs.org/model/beech-f33a.md): 978 registered aircraft · Airframe model
- [Beech V35B](https://openairdocs.org/model/beech-v35b.md): 913 registered aircraft · Airframe model
- [Beech 95-B55 (T42A)](https://openairdocs.org/model/beech-95-b55-t42a.md): 774 registered aircraft · Airframe model
- [Beech 58](https://openairdocs.org/model/beech-58.md): 726 registered aircraft · Airframe model
- [Beech S35](https://openairdocs.org/model/beech-s35.md): 459 registered aircraft · Airframe model
- [Raytheon A36](https://openairdocs.org/model/raytheon-a36.md): 448 registered aircraft · Airframe model
- [Beech V35](https://openairdocs.org/model/beech-v35.md): 425 registered aircraft · Airframe model
- [Beech V35A](https://openairdocs.org/model/beech-v35a.md): 321 registered aircraft · Airframe model
- [Beech P35](https://openairdocs.org/model/beech-p35.md): 319 registered aircraft · Airframe model
- [Beech 58P](https://openairdocs.org/model/beech-58p.md): 298 registered aircraft · Airframe model
- [Beech 35-B33](https://openairdocs.org/model/beech-35-b33.md): 291 registered aircraft · Airframe model
- [Beech B200](https://openairdocs.org/model/beech-b200.md): 281 registered aircraft · Airframe model
- [Beech C35](https://openairdocs.org/model/beech-c35.md): 258 registered aircraft · Airframe model
- [Beech K35](https://openairdocs.org/model/beech-k35.md): 237 registered aircraft · Airframe model
- [Beech 200](https://openairdocs.org/model/beech-200.md): 234 registered aircraft · Airframe model
- [Raytheon B300](https://openairdocs.org/model/raytheon-b300.md): 233 registered aircraft · Airframe model
- [Beech B36TC](https://openairdocs.org/model/beech-b36tc.md): 225 registered aircraft · Airframe model
- [Beech M35](https://openairdocs.org/model/beech-m35.md): 225 registered aircraft · Airframe model
- [Beech G35](https://openairdocs.org/model/beech-g35.md): 224 registered aircraft · Airframe model
- [Beech H35](https://openairdocs.org/model/beech-h35.md): 224 registered aircraft · Airframe model
- [Beech J35](https://openairdocs.org/model/beech-j35.md): 221 registered aircraft · Airframe model
- [Beech C90](https://openairdocs.org/model/beech-c90.md): 216 registered aircraft · Airframe model
- [Beech E-55](https://openairdocs.org/model/beech-e-55.md): 215 registered aircraft · Airframe model
- [Raytheon B200](https://openairdocs.org/model/raytheon-b200.md): 206 registered aircraft · Airframe model
- [Textron B300](https://openairdocs.org/model/textron-b300.md): 195 registered aircraft · Airframe model
- [Beech F35](https://openairdocs.org/model/beech-f35.md): 192 registered aircraft · Airframe model
- [Raytheon 58](https://openairdocs.org/model/raytheon-58.md): 188 registered aircraft · Airframe model
- [Beech 35-C33](https://openairdocs.org/model/beech-35-c33.md): 185 registered aircraft · Airframe model
- [Beech A36TC](https://openairdocs.org/model/beech-a36tc.md): 174 registered aircraft · Airframe model
- [Beech N35](https://openairdocs.org/model/beech-n35.md): 167 registered aircraft · Airframe model
- [Beech A35](https://openairdocs.org/model/beech-a35.md): 159 registered aircraft · Airframe model
- [Beech 95-C55](https://openairdocs.org/model/beech-95-c55.md): 158 registered aircraft · Airframe model
- [Raytheon C90A](https://openairdocs.org/model/raytheon-c90a.md): 155 registered aircraft · Airframe model
- [Beech B35](https://openairdocs.org/model/beech-b35.md): 148 registered aircraft · Airframe model
- [Hawker Beechcraft G36](https://openairdocs.org/model/hawker-beechcraft-g36.md): 146 registered aircraft · Airframe model
- [Beech E-90](https://openairdocs.org/model/beech-e-90.md): 145 registered aircraft · Airframe model
- [Hawker Beechcraft B300](https://openairdocs.org/model/hawker-beechcraft-b300.md): 144 registered aircraft · Airframe model
- [Beech D35](https://openairdocs.org/model/beech-d35.md): 142 registered aircraft · Airframe model
- [Beech E35](https://openairdocs.org/model/beech-e35.md): 141 registered aircraft · Airframe model
- [Beech 35-33](https://openairdocs.org/model/beech-35-33.md): 130 registered aircraft · Airframe model
- [Beech 300](https://openairdocs.org/model/beech-300.md): 125 registered aircraft · Airframe model
- [Beech C90A](https://openairdocs.org/model/beech-c90a.md): 125 registered aircraft · Airframe model
- [Beech D55](https://openairdocs.org/model/beech-d55.md): 119 registered aircraft · Airframe model
- [Beech 35-C33A](https://openairdocs.org/model/beech-35-c33a.md): 113 registered aircraft · Airframe model
- [Beech 36](https://openairdocs.org/model/beech-36.md): 111 registered aircraft · Airframe model
- [Raytheon G36](https://openairdocs.org/model/raytheon-g36.md): 97 registered aircraft · Airframe model
- [Beech 95](https://openairdocs.org/model/beech-95.md): 95 registered aircraft · Airframe model
- [Beech 65-A90-1](https://openairdocs.org/model/beech-65-a90-1.md): 90 registered aircraft · Airframe model
- [Beech 95-A55](https://openairdocs.org/model/beech-95-a55.md): 90 registered aircraft · Airframe model

Next page: https://openairdocs.org/saib/CE-12-36/models.md?page=2

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

This list as a web page: https://openairdocs.org/saib/CE-12-36/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.
