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

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

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

Page 1 of 2 · 60 models

- [Cessna 172S](https://openairdocs.org/model/cessna-172s.md): 1,915 registered aircraft · Airframe model
- [Textron 172S](https://openairdocs.org/model/textron-172s.md): 1,239 registered aircraft · Airframe model
- [Piper PA-32-300](https://openairdocs.org/model/piper-pa-32-300.md): 992 registered aircraft · Airframe model
- [Cessna 182T](https://openairdocs.org/model/cessna-182t.md): 969 registered aircraft · Airframe model
- [Cessna T182T](https://openairdocs.org/model/cessna-t182t.md): 781 registered aircraft · Airframe model
- [Cessna T206H](https://openairdocs.org/model/cessna-t206h.md): 691 registered aircraft · Airframe model
- [Diamond Aircraft Ind DA 40](https://openairdocs.org/model/diamond-aircraft-ind-da-40.md): 688 registered aircraft · Airframe model
- [Cessna 172R](https://openairdocs.org/model/cessna-172r.md): 683 registered aircraft · Airframe model
- [Piper PA-32-260](https://openairdocs.org/model/piper-pa-32-260.md): 650 registered aircraft · Airframe model
- [Piper PA-32R-301T](https://openairdocs.org/model/piper-pa-32r-301t.md): 536 registered aircraft · Airframe model
- [Piper PA-32R-300](https://openairdocs.org/model/piper-pa-32r-300.md): 510 registered aircraft · Airframe model
- [Piper PA-32R-301](https://openairdocs.org/model/piper-pa-32r-301.md): 456 registered aircraft · Airframe model
- [Mooney M20R](https://openairdocs.org/model/mooney-m20r.md): 399 registered aircraft · Airframe model
- [Textron T206H](https://openairdocs.org/model/textron-t206h.md): 367 registered aircraft · Airframe model
- [Textron 182T](https://openairdocs.org/model/textron-182t.md): 347 registered aircraft · Airframe model
- [Mooney M20M](https://openairdocs.org/model/mooney-m20m.md): 249 registered aircraft · Airframe model
- [Columbia Aircraft Mfg LC41-550FG](https://openairdocs.org/model/columbia-aircraft-mfg-lc41-550fg.md): 207 registered aircraft · Airframe model
- [Piper PA-32RT-300T](https://openairdocs.org/model/piper-pa-32rt-300t.md): 204 registered aircraft · Airframe model
- [Piper PA-32RT-300](https://openairdocs.org/model/piper-pa-32rt-300.md): 200 registered aircraft · Airframe model
- [Piper PA-32-301](https://openairdocs.org/model/piper-pa-32-301.md): 167 registered aircraft · Airframe model
- [Cessna 206H](https://openairdocs.org/model/cessna-206h.md): 158 registered aircraft · Airframe model
- [Hawker Beechcraft G36](https://openairdocs.org/model/hawker-beechcraft-g36.md): 146 registered aircraft · Airframe model
- [Cessna LC41-550FG](https://openairdocs.org/model/cessna-lc41-550fg.md): 144 registered aircraft · Airframe model
- [Quest KODIAK 100](https://openairdocs.org/model/quest-kodiak-100.md): 140 registered aircraft · Airframe model
- [Lancair LC41-550FG](https://openairdocs.org/model/lancair-lc41-550fg.md): 122 registered aircraft · Airframe model
- [American General Acft AG5B](https://openairdocs.org/model/american-general-acft-ag5b.md): 114 registered aircraft · Airframe model
- [Diamond Aircraft Ind DA 42](https://openairdocs.org/model/diamond-aircraft-ind-da-42.md): 114 registered aircraft · Airframe model
- [Mooney M20TN](https://openairdocs.org/model/mooney-m20tn.md): 107 registered aircraft · Airframe model
- [Raytheon G36](https://openairdocs.org/model/raytheon-g36.md): 97 registered aircraft · Airframe model
- [Textron T182T](https://openairdocs.org/model/textron-t182t.md): 96 registered aircraft · Airframe model
- [Textron G36](https://openairdocs.org/model/textron-g36.md): 84 registered aircraft · Airframe model
- [Piper PA-32-301T](https://openairdocs.org/model/piper-pa-32-301t.md): 81 registered aircraft · Airframe model
- [Kodiak KODIAK 100](https://openairdocs.org/model/kodiak-kodiak-100.md): 79 registered aircraft · Airframe model
- [Lancair LC42-550FG](https://openairdocs.org/model/lancair-lc42-550fg.md): 75 registered aircraft · Airframe model
- [Hawker Beechcraft G58](https://openairdocs.org/model/hawker-beechcraft-g58.md): 67 registered aircraft · Airframe model
- [Lancair LC-40-550FG](https://openairdocs.org/model/lancair-lc-40-550fg.md): 64 registered aircraft · Airframe model
- [Columbia Aircraft Mfg LC42-550FG](https://openairdocs.org/model/columbia-aircraft-mfg-lc42-550fg.md): 61 registered aircraft · Airframe model
- [Textron G58](https://openairdocs.org/model/textron-g58.md): 59 registered aircraft · Airframe model
- [Beechcraft G36](https://openairdocs.org/model/beechcraft-g36.md): 53 registered aircraft · Airframe model
- [Tiger AG-5B](https://openairdocs.org/model/tiger-ag-5b.md): 46 registered aircraft · Airframe model
- [Piper PA32-301FT](https://openairdocs.org/model/piper-pa32-301ft.md): 39 registered aircraft · Airframe model
- [Piper PA32-301XTC](https://openairdocs.org/model/piper-pa32-301xtc.md): 36 registered aircraft · Airframe model
- [Beechcraft G58](https://openairdocs.org/model/beechcraft-g58.md): 35 registered aircraft · Airframe model
- [Raytheon G58](https://openairdocs.org/model/raytheon-g58.md): 25 registered aircraft · Airframe model
- [New Piper PA-32R-301T](https://openairdocs.org/model/new-piper-pa-32r-301t.md): 19 registered aircraft · Airframe model
- [Cessna LC42-550FG](https://openairdocs.org/model/cessna-lc42-550fg.md): 16 registered aircraft · Airframe model
- [Diamond Aircraft Ind DA40 F](https://openairdocs.org/model/diamond-aircraft-ind-da40-f.md): 14 registered aircraft · Airframe model
- [Mooney International M20TN](https://openairdocs.org/model/mooney-international-m20tn.md): 12 registered aircraft · Airframe model
- [New Piper PA-32-301XTC](https://openairdocs.org/model/new-piper-pa-32-301xtc.md): 7 registered aircraft · Airframe model
- [New Piper PA-32R-301](https://openairdocs.org/model/new-piper-pa-32r-301.md): 6 registered aircraft · Airframe model

Next page: https://openairdocs.org/saib/CE-09-12/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 = '9C1B814D8573E1E08625755A004F9AF0')
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 = '9C1B814D8573E1E08625755A004F9AF0')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

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