# Registry models it may concern: SAIB NE-16-18

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

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

Page 1 of 7 · 336 models

- [AiResearch TPE331 series](https://openairdocs.org/engine/airesearch-tpe331-series.md): 492 registered aircraft · Engine model
- [Honeywell TPE331-SER series](https://openairdocs.org/engine/honeywell-tpe331-ser-series.md): 28 registered aircraft · Engine model
- [Garrett TPE331-12B](https://openairdocs.org/engine/garrett-tpe331-12b.md): 19 registered aircraft · Engine model
- [Honeywell TPE331-10 series](https://openairdocs.org/engine/honeywell-tpe331-10-series.md): 17 registered aircraft · Engine model
- [Honeywell TPE331-12JR](https://openairdocs.org/engine/honeywell-tpe331-12jr.md): 15 registered aircraft · Engine model
- [Honeywell TPE331-10](https://openairdocs.org/engine/honeywell-tpe331-10.md): 13 registered aircraft · Engine model
- [Honeywell TPE331-10R](https://openairdocs.org/engine/honeywell-tpe331-10r.md): 13 registered aircraft · Engine model
- [Garrett TPE331-11U](https://openairdocs.org/engine/garrett-tpe331-11u.md): 12 registered aircraft · Engine model
- [Honeywell TPE331-14GR](https://openairdocs.org/engine/honeywell-tpe331-14gr.md): 12 registered aircraft · Engine model
- [Honeywell TPE331-10N](https://openairdocs.org/engine/honeywell-tpe331-10n.md): 11 registered aircraft · Engine model
- [Alliedsign TPE331-12UHR](https://openairdocs.org/engine/alliedsign-tpe331-12uhr.md): 10 registered aircraft · Engine model
- [Garrett TPE331-10N](https://openairdocs.org/engine/garrett-tpe331-10n.md): 8 registered aircraft · Engine model
- [Honeywell TPE331-10T](https://openairdocs.org/engine/honeywell-tpe331-10t.md): 8 registered aircraft · Engine model
- [Honeywell TPE331-11U](https://openairdocs.org/engine/honeywell-tpe331-11u.md): 8 registered aircraft · Engine model
- [Garrett TPE331-10](https://openairdocs.org/engine/garrett-tpe331-10.md): 7 registered aircraft · Engine model
- [Garrett TPE331-10 series](https://openairdocs.org/engine/garrett-tpe331-10-series.md): 7 registered aircraft · Engine model
- [Garrett TPE331-5](https://openairdocs.org/engine/garrett-tpe331-5.md): 7 registered aircraft · Engine model
- [Garrett TPE331-6](https://openairdocs.org/engine/garrett-tpe331-6.md): 6 registered aircraft · Engine model
- [Garrett TPE331-1](https://openairdocs.org/engine/garrett-tpe331-1.md): 5 registered aircraft · Engine model
- [Garrett TPE331-10R](https://openairdocs.org/engine/garrett-tpe331-10r.md): 5 registered aircraft · Engine model
- [Garrett TPE331-12UHR](https://openairdocs.org/engine/garrett-tpe331-12uhr.md): 5 registered aircraft · Engine model
- [AiResearch TPE331-8 series](https://openairdocs.org/engine/airesearch-tpe331-8-series.md): 4 registered aircraft · Engine model
- [Honeywell TPE331-10U](https://openairdocs.org/engine/honeywell-tpe331-10u.md): 4 registered aircraft · Engine model
- [AiResearch TPE331-1](https://openairdocs.org/engine/airesearch-tpe331-1.md): 3 registered aircraft · Engine model
- [Alliedsign TPE331-10T](https://openairdocs.org/engine/alliedsign-tpe331-10t.md): 3 registered aircraft · Engine model
- [Garrett TPE331-10T](https://openairdocs.org/engine/garrett-tpe331-10t.md): 3 registered aircraft · Engine model
- [Garrett TPE331-2](https://openairdocs.org/engine/garrett-tpe331-2.md): 3 registered aircraft · Engine model
- [Garrett TPE331-8](https://openairdocs.org/engine/garrett-tpe331-8.md): 3 registered aircraft · Engine model
- [Honeywell TPE331-10AV](https://openairdocs.org/engine/honeywell-tpe331-10av.md): 3 registered aircraft · Engine model
- [Honeywell TPE331-12UHR](https://openairdocs.org/engine/honeywell-tpe331-12uhr.md): 3 registered aircraft · Engine model
- [Honeywell TPE331-2](https://openairdocs.org/engine/honeywell-tpe331-2.md): 3 registered aircraft · Engine model
- [Honeywell TPE331-6](https://openairdocs.org/engine/honeywell-tpe331-6.md): 3 registered aircraft · Engine model
- [AiResearch TPE331-10](https://openairdocs.org/engine/airesearch-tpe331-10.md): 2 registered aircraft · Engine model
- [AiResearch TPE331-10T](https://openairdocs.org/engine/airesearch-tpe331-10t.md): 2 registered aircraft · Engine model
- [AiResearch TPE331-2](https://openairdocs.org/engine/airesearch-tpe331-2.md): 2 registered aircraft · Engine model
- [AiResearch TPE331-6](https://openairdocs.org/engine/airesearch-tpe331-6.md): 2 registered aircraft · Engine model
- [Alliedsign TPE331-10R](https://openairdocs.org/engine/alliedsign-tpe331-10r.md): 2 registered aircraft · Engine model
- [Alliedsign TPE331-6](https://openairdocs.org/engine/alliedsign-tpe331-6.md): 2 registered aircraft · Engine model
- [Garrett TPE331-10U](https://openairdocs.org/engine/garrett-tpe331-10u.md): 2 registered aircraft · Engine model
- [Garrett TPE331-10UGR](https://openairdocs.org/engine/garrett-tpe331-10ugr.md): 2 registered aircraft · Engine model
- [Garrett TPE331-14F](https://openairdocs.org/engine/garrett-tpe331-14f.md): 2 registered aircraft · Engine model
- [Honeywell TPE331-5](https://openairdocs.org/engine/honeywell-tpe331-5.md): 2 registered aircraft · Engine model
- [AiResearch TPE331-10R](https://openairdocs.org/engine/airesearch-tpe331-10r.md): 1 registered aircraft · Engine model
- [AiResearch TPE331-10U](https://openairdocs.org/engine/airesearch-tpe331-10u.md): 1 registered aircraft · Engine model
- [AiResearch TPE331-10UA](https://openairdocs.org/engine/airesearch-tpe331-10ua.md): 1 registered aircraft · Engine model
- [AiResearch TPE331-11U](https://openairdocs.org/engine/airesearch-tpe331-11u.md): 1 registered aircraft · Engine model
- [AiResearch TPE331-12UHR](https://openairdocs.org/engine/airesearch-tpe331-12uhr.md): 1 registered aircraft · Engine model
- [AiResearch TPE331-3U](https://openairdocs.org/engine/airesearch-tpe331-3u.md): 1 registered aircraft · Engine model
- [AiResearch TPE331-5](https://openairdocs.org/engine/airesearch-tpe331-5.md): 1 registered aircraft · Engine model
- [AiResearch TPE331-8](https://openairdocs.org/engine/airesearch-tpe331-8.md): 1 registered aircraft · Engine model

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

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