# Registry models it may concern: SAIB CE-02-19

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

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

- [Beech 58](https://openairdocs.org/model/beech-58.md): 726 registered aircraft · Airframe model
- [Beech 35](https://openairdocs.org/model/beech-35.md): 266 registered aircraft · Airframe model
- [Beech 200](https://openairdocs.org/model/beech-200.md): 234 registered aircraft · Airframe model
- [Raytheon 58](https://openairdocs.org/model/raytheon-58.md): 188 registered aircraft · Airframe model
- [Beech 76](https://openairdocs.org/model/beech-76.md): 151 registered aircraft · Airframe model
- [Beech 23](https://openairdocs.org/model/beech-23.md): 147 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 77](https://openairdocs.org/model/beech-77.md): 113 registered aircraft · Airframe model
- [Beech 36](https://openairdocs.org/model/beech-36.md): 111 registered aircraft · Airframe model
- [Beech 95](https://openairdocs.org/model/beech-95.md): 95 registered aircraft · Airframe model
- [Gates Learjet 55](https://openairdocs.org/model/gates-learjet-55.md): 54 registered aircraft · Airframe model
- [Beech 95-55](https://openairdocs.org/model/beech-95-55.md): 53 registered aircraft · Airframe model
- [Beech 60](https://openairdocs.org/model/beech-60.md): 32 registered aircraft · Airframe model
- [Travel Air Mfg 2000](https://openairdocs.org/model/travel-air-mfg-2000.md): 24 registered aircraft · Airframe model
- [Beech 99](https://openairdocs.org/model/beech-99.md): 23 registered aircraft · Airframe model
- [Beech 65](https://openairdocs.org/model/beech-65.md): 22 registered aircraft · Airframe model
- [Taylorcraft 19](https://openairdocs.org/model/taylorcraft-19.md): 18 registered aircraft · Airframe model
- [Beech 100](https://openairdocs.org/model/beech-100.md): 14 registered aircraft · Airframe model
- [Beech 1900](https://openairdocs.org/model/beech-1900.md): 7 registered aircraft · Airframe model
- [Beech 65-90](https://openairdocs.org/model/beech-65-90.md): 7 registered aircraft · Airframe model
- [Learjet 24](https://openairdocs.org/model/learjet-24.md): 7 registered aircraft · Airframe model
- [Beech 2000](https://openairdocs.org/model/beech-2000.md): 6 registered aircraft · Airframe model
- [Beech 65 (LF-23F)](https://openairdocs.org/model/beech-65-lf-23f.md): 6 registered aircraft · Airframe model
- [Beech 70](https://openairdocs.org/model/beech-70.md): 4 registered aircraft · Airframe model
- [Learjet 55](https://openairdocs.org/model/learjet-55.md): 4 registered aircraft · Airframe model
- [Beech 65-88](https://openairdocs.org/model/beech-65-88.md): 3 registered aircraft · Airframe model
- [Saab-Scania 2000](https://openairdocs.org/model/saab-scania-2000.md): 3 registered aircraft · Airframe model
- [Beech 33](https://openairdocs.org/model/beech-33.md): 2 registered aircraft · Airframe model
- [Beech 50](https://openairdocs.org/model/beech-50.md): 2 registered aircraft · Airframe model
- [Beech 65-80](https://openairdocs.org/model/beech-65-80.md): 2 registered aircraft · Airframe model
- [Saab 2000](https://openairdocs.org/model/saab-2000.md): 2 registered aircraft · Airframe model
- [Beech 65 (L23F)](https://openairdocs.org/model/beech-65-l23f.md): 1 registered aircraft · Airframe model
- [Bushmaster 2000](https://openairdocs.org/model/bushmaster-2000.md): 1 registered aircraft · Airframe model
- [CASA 300](https://openairdocs.org/model/casa-300.md): 1 registered aircraft · Airframe model
- [Monocoupe 70](https://openairdocs.org/model/monocoupe-70.md): 1 registered aircraft · Airframe model
- [Rockwell International 65](https://openairdocs.org/model/rockwell-international-65.md): 1 registered aircraft · Airframe model
- [Beechcraft 35 BONANZA](https://openairdocs.org/model/beechcraft-35-bonanza.md): 0 registered aircraft · Airframe model
- [Boeing 95](https://openairdocs.org/model/boeing-95.md): 0 registered aircraft · Airframe model
- [Gates Learjet 24](https://openairdocs.org/model/gates-learjet-24.md): 0 registered aircraft · Airframe model
- [Hawker Hunter MK 50](https://openairdocs.org/model/hawker-hunter-mk-50.md): 0 registered aircraft · Airframe model
- [Lark 95](https://openairdocs.org/model/lark-95.md): 0 registered aircraft · Airframe model
- [Raytheon 1900](https://openairdocs.org/model/raytheon-1900.md): 0 registered aircraft · Airframe model
- [Raytheon 200](https://openairdocs.org/model/raytheon-200.md): 0 registered aircraft · Airframe model
- [Travel Air 2000](https://openairdocs.org/model/travel-air-2000.md): 0 registered aircraft · Airframe model
- [Travel Air/Hoffman L 2000](https://openairdocs.org/model/travel-air-hoffman-l-2000.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 = '1987B458AA9E6AB08625721F0052ECFA')
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 = '1987B458AA9E6AB08625721F0052ECFA')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

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