# Registry models it may concern: SAIB NE-12-29

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

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

- [CFM International CFM56 series](https://openairdocs.org/engine/cfm-international-cfm56-series.md): 708 registered aircraft · Engine model
- [CFM International CFM56-5B3/3 series](https://openairdocs.org/engine/cfm-international-cfm56-5b3-3-series.md): 104 registered aircraft · Engine model
- [CFM International CFM56-5B4/3 series](https://openairdocs.org/engine/cfm-international-cfm56-5b4-3-series.md): 82 registered aircraft · Engine model
- [CFM International CFM56-5B4 series](https://openairdocs.org/engine/cfm-international-cfm56-5b4-series.md): 41 registered aircraft · Engine model
- [CFM International CFM56-5B2 series](https://openairdocs.org/engine/cfm-international-cfm56-5b2-series.md): 38 registered aircraft · Engine model
- [CFM International CFM56-5B4/P series](https://openairdocs.org/engine/cfm-international-cfm56-5b4-p-series.md): 22 registered aircraft · Engine model
- [CFM International CFM56-5B7 series](https://openairdocs.org/engine/cfm-international-cfm56-5b7-series.md): 18 registered aircraft · Engine model
- [CFM International CFM56-5B6 series](https://openairdocs.org/engine/cfm-international-cfm56-5b6-series.md): 16 registered aircraft · Engine model
- [CFM International CFM56-5B5/P series](https://openairdocs.org/engine/cfm-international-cfm56-5b5-p-series.md): 14 registered aircraft · Engine model
- [CFM International CFM56-5B3/P series](https://openairdocs.org/engine/cfm-international-cfm56-5b3-p-series.md): 11 registered aircraft · Engine model
- [CFM International CFM56-5B6/P series](https://openairdocs.org/engine/cfm-international-cfm56-5b6-p-series.md): 10 registered aircraft · Engine model
- [CFM International CFM56-5B7/3 series](https://openairdocs.org/engine/cfm-international-cfm56-5b7-3-series.md): 7 registered aircraft · Engine model
- [CFM International CFM56-5B6/3 series](https://openairdocs.org/engine/cfm-international-cfm56-5b6-3-series.md): 3 registered aircraft · Engine model
- [CFM International CFM56-5B5 series](https://openairdocs.org/engine/cfm-international-cfm56-5b5-series.md): 2 registered aircraft · Engine model
- [CFM International CFM56-5B7/P series](https://openairdocs.org/engine/cfm-international-cfm56-5b7-p-series.md): 1 registered aircraft · Engine model
- [CFM International CFM56-5 series](https://openairdocs.org/engine/cfm-international-cfm56-5-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B1 series](https://openairdocs.org/engine/cfm-international-cfm56-5b1-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B1/2P series](https://openairdocs.org/engine/cfm-international-cfm56-5b1-2p-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B1/P series](https://openairdocs.org/engine/cfm-international-cfm56-5b1-p-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B2/2P series](https://openairdocs.org/engine/cfm-international-cfm56-5b2-2p-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B2/P series](https://openairdocs.org/engine/cfm-international-cfm56-5b2-p-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B3/2P series](https://openairdocs.org/engine/cfm-international-cfm56-5b3-2p-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B3/2P1 series](https://openairdocs.org/engine/cfm-international-cfm56-5b3-2p1-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B3/P1 series](https://openairdocs.org/engine/cfm-international-cfm56-5b3-p1-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B4/2P series](https://openairdocs.org/engine/cfm-international-cfm56-5b4-2p-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B4/2P1 series](https://openairdocs.org/engine/cfm-international-cfm56-5b4-2p1-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B4/P1 series](https://openairdocs.org/engine/cfm-international-cfm56-5b4-p1-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B6/2P series](https://openairdocs.org/engine/cfm-international-cfm56-5b6-2p-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B8/P series](https://openairdocs.org/engine/cfm-international-cfm56-5b8-p-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B9/2P series](https://openairdocs.org/engine/cfm-international-cfm56-5b9-2p-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B9/3 series](https://openairdocs.org/engine/cfm-international-cfm56-5b9-3-series.md): 0 registered aircraft · Engine model
- [CFM International CFM56-5B9/P series](https://openairdocs.org/engine/cfm-international-cfm56-5b9-p-series.md): 0 registered aircraft · Engine 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 = '1DF21533F0D1C24A862579ED0060DBB8')
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 = '1DF21533F0D1C24A862579ED0060DBB8')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

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