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

A list on [SAIB NE-16-19](https://openairdocs.org/saib/NE-16-19.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 · 97 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
- [Honeywell TPE331-10 series](https://openairdocs.org/engine/honeywell-tpe331-10-series.md): 17 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-10N](https://openairdocs.org/engine/honeywell-tpe331-10n.md): 11 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-10R](https://openairdocs.org/engine/garrett-tpe331-10r.md): 5 registered aircraft · Engine model
- [Honeywell TPE331-10U](https://openairdocs.org/engine/honeywell-tpe331-10u.md): 4 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
- [Honeywell TPE331-10AV](https://openairdocs.org/engine/honeywell-tpe331-10av.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
- [Alliedsign TPE331-10R](https://openairdocs.org/engine/alliedsign-tpe331-10r.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
- [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
- [Alliedsign TPE331-10AV](https://openairdocs.org/engine/alliedsign-tpe331-10av.md): 1 registered aircraft · Engine model
- [Alliedsign TPE331-10N](https://openairdocs.org/engine/alliedsign-tpe331-10n.md): 1 registered aircraft · Engine model
- [Garrett TPE331-10AV](https://openairdocs.org/engine/garrett-tpe331-10av.md): 1 registered aircraft · Engine model
- [Garrett TPE331-11UA](https://openairdocs.org/engine/garrett-tpe331-11ua.md): 1 registered aircraft · Engine model
- [Honeywell TPE331-10UA](https://openairdocs.org/engine/honeywell-tpe331-10ua.md): 1 registered aircraft · Engine model
- [AiResearch TPE-331-10UG](https://openairdocs.org/engine/airesearch-tpe-331-10ug.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10A](https://openairdocs.org/engine/airesearch-tpe331-10a.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10AV](https://openairdocs.org/engine/airesearch-tpe331-10av.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10B](https://openairdocs.org/engine/airesearch-tpe331-10b.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10G](https://openairdocs.org/engine/airesearch-tpe331-10g.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10GP](https://openairdocs.org/engine/airesearch-tpe331-10gp.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10GR](https://openairdocs.org/engine/airesearch-tpe331-10gr.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10GT](https://openairdocs.org/engine/airesearch-tpe331-10gt.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10J](https://openairdocs.org/engine/airesearch-tpe331-10j.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10N](https://openairdocs.org/engine/airesearch-tpe331-10n.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10P](https://openairdocs.org/engine/airesearch-tpe331-10p.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10UF](https://openairdocs.org/engine/airesearch-tpe331-10uf.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10UGR](https://openairdocs.org/engine/airesearch-tpe331-10ugr.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10UJ](https://openairdocs.org/engine/airesearch-tpe331-10uj.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10UK](https://openairdocs.org/engine/airesearch-tpe331-10uk.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-10UR](https://openairdocs.org/engine/airesearch-tpe331-10ur.md): 0 registered aircraft · Engine model
- [AiResearch TPE331-11UA](https://openairdocs.org/engine/airesearch-tpe331-11ua.md): 0 registered aircraft · Engine model
- [Alliedsign TPE-331 series](https://openairdocs.org/engine/alliedsign-tpe-331-series.md): 0 registered aircraft · Engine model
- [Alliedsign TPE-331-10UG](https://openairdocs.org/engine/alliedsign-tpe-331-10ug.md): 0 registered aircraft · Engine model

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

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