# Registry models it may concern: SAIB NE-09-08

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

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

Page 1 of 3 · 146 models

- [Continental O-470 series](https://openairdocs.org/engine/continental-o-470-series.md): 12,779 registered aircraft · Engine model
- [Continental IO-520 series](https://openairdocs.org/engine/continental-io-520-series.md): 9,486 registered aircraft · Engine model
- [Continental I0-470 series](https://openairdocs.org/engine/continental-i0-470-series.md): 4,499 registered aircraft · Engine model
- [Continental TSIO-520 series](https://openairdocs.org/engine/continental-tsio-520-series.md): 4,064 registered aircraft · Engine model
- [Continental IO-550 series](https://openairdocs.org/engine/continental-io-550-series.md): 3,077 registered aircraft · Engine model
- [Continental IO-550-N](https://openairdocs.org/engine/continental-io-550-n.md): 2,772 registered aircraft · Engine model
- [Continental TSIO-550-C](https://openairdocs.org/engine/continental-tsio-550-c.md): 480 registered aircraft · Engine model
- [Continental GTSIO-520-C](https://openairdocs.org/engine/continental-gtsio-520-c.md): 387 registered aircraft · Engine model
- [Continental TSIO-550 series](https://openairdocs.org/engine/continental-tsio-550-series.md): 382 registered aircraft · Engine model
- [Continental IO-550-B](https://openairdocs.org/engine/continental-io-550-b.md): 373 registered aircraft · Engine model
- [Continental IO-470 series](https://openairdocs.org/engine/continental-io-470-series.md): 225 registered aircraft · Engine model
- [Continental IO-550-C](https://openairdocs.org/engine/continental-io-550-c.md): 199 registered aircraft · Engine model
- [Continental GTSIO-520 series](https://openairdocs.org/engine/continental-gtsio-520-series.md): 178 registered aircraft · Engine model
- [Continental TSIO-550-G](https://openairdocs.org/engine/continental-tsio-550-g.md): 129 registered aircraft · Engine model
- [Continental IO-550-G](https://openairdocs.org/engine/continental-io-550-g.md): 115 registered aircraft · Engine model
- [Continental O-470R](https://openairdocs.org/engine/continental-o-470r.md): 107 registered aircraft · Engine model
- [Continental IO-520-D](https://openairdocs.org/engine/continental-io-520-d.md): 95 registered aircraft · Engine model
- [Continental IO-520-F](https://openairdocs.org/engine/continental-io-520-f.md): 80 registered aircraft · Engine model
- [Continental TSI0-470-B](https://openairdocs.org/engine/continental-tsi0-470-b.md): 75 registered aircraft · Engine model
- [Continental TSIO-520-M](https://openairdocs.org/engine/continental-tsio-520-m.md): 60 registered aircraft · Engine model
- [Continental O-470-U](https://openairdocs.org/engine/continental-o-470-u.md): 56 registered aircraft · Engine model
- [Continental TSIO-520-NB](https://openairdocs.org/engine/continental-tsio-520-nb.md): 52 registered aircraft · Engine model
- [Lycoming IO-520 series](https://openairdocs.org/engine/lycoming-io-520-series.md): 49 registered aircraft · Engine model
- [TCM Cont TSIO-520 series](https://openairdocs.org/engine/tcm-cont-tsio-520-series.md): 49 registered aircraft · Engine model
- [Continental TSIO-550-E](https://openairdocs.org/engine/continental-tsio-550-e.md): 46 registered aircraft · Engine model
- [Continental IO-520-BB](https://openairdocs.org/engine/continental-io-520-bb.md): 44 registered aircraft · Engine model
- [Continental IO-550-D](https://openairdocs.org/engine/continental-io-550-d.md): 36 registered aircraft · Engine model
- [Continental TSIO-520-UB](https://openairdocs.org/engine/continental-tsio-520-ub.md): 27 registered aircraft · Engine model
- [Continental IO-550-F](https://openairdocs.org/engine/continental-io-550-f.md): 26 registered aircraft · Engine model
- [Continental IO-520-BA](https://openairdocs.org/engine/continental-io-520-ba.md): 25 registered aircraft · Engine model
- [Continental IO-470-L](https://openairdocs.org/engine/continental-io-470-l.md): 22 registered aircraft · Engine model
- [Continental O-470-S](https://openairdocs.org/engine/continental-o-470-s.md): 22 registered aircraft · Engine model
- [Continental TSIO-520-R](https://openairdocs.org/engine/continental-tsio-520-r.md): 22 registered aircraft · Engine model
- [Continental O-470-L](https://openairdocs.org/engine/continental-o-470-l.md): 19 registered aircraft · Engine model
- [Continental TSIO-520-WB](https://openairdocs.org/engine/continental-tsio-520-wb.md): 19 registered aircraft · Engine model
- [Continental TSIO-520-C](https://openairdocs.org/engine/continental-tsio-520-c.md): 17 registered aircraft · Engine model
- [Continental IO-520-B](https://openairdocs.org/engine/continental-io-520-b.md): 16 registered aircraft · Engine model
- [Continental O-470-K](https://openairdocs.org/engine/continental-o-470-k.md): 13 registered aircraft · Engine model
- [Continental IO-470-N](https://openairdocs.org/engine/continental-io-470-n.md): 12 registered aircraft · Engine model
- [Continental TSIO-520-P](https://openairdocs.org/engine/continental-tsio-520-p.md): 12 registered aircraft · Engine model
- [Continental IO-520-L](https://openairdocs.org/engine/continental-io-520-l.md): 11 registered aircraft · Engine model
- [Continental TSIO-520-H](https://openairdocs.org/engine/continental-tsio-520-h.md): 11 registered aircraft · Engine model
- [Continental TSIO-520-N](https://openairdocs.org/engine/continental-tsio-520-n.md): 11 registered aircraft · Engine model
- [Continental TSIO-520-VB](https://openairdocs.org/engine/continental-tsio-520-vb.md): 11 registered aircraft · Engine model
- [Continental GTSIO-520-N](https://openairdocs.org/engine/continental-gtsio-520-n.md): 10 registered aircraft · Engine model
- [TCM IO-550-N](https://openairdocs.org/engine/tcm-io-550-n.md): 10 registered aircraft · Engine model
- [Continental GTSIO-520-H](https://openairdocs.org/engine/continental-gtsio-520-h.md): 9 registered aircraft · Engine model
- [Continental IO-470-F](https://openairdocs.org/engine/continental-io-470-f.md): 9 registered aircraft · Engine model
- [Continental TSIO-520-B](https://openairdocs.org/engine/continental-tsio-520-b.md): 9 registered aircraft · Engine model
- [Continental TSIO-520-BE](https://openairdocs.org/engine/continental-tsio-520-be.md): 9 registered aircraft · Engine model

Next page: https://openairdocs.org/saib/NE-09-08/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 = '475E4E1C2B3F785C8625754E0071C27B')
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 = '475E4E1C2B3F785C8625754E0071C27B')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

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