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

A list on [SAIB NE-12-04](https://openairdocs.org/saib/NE-12-04.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

- [Pratt & Whitney PT6A series](https://openairdocs.org/engine/pratt-whitney-pt6a-series.md): 2,217 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-34AG](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-34ag.md): 269 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-114A](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-114a.md): 251 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-34 series](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-34-series.md): 230 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-6 series](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-6-series.md): 170 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-135A](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-135a.md): 160 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-21](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-21.md): 76 registered aircraft · Engine model
- [Pratt & Whitney PT6 series](https://openairdocs.org/engine/pratt-whitney-pt6-series.md): 43 registered aircraft · Engine model
- [Pratt & Whitney PT6A-34 series](https://openairdocs.org/engine/pratt-whitney-pt6a-34-series.md): 42 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-15AG](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-15ag.md): 40 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-27 series](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-27-series.md): 30 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-135](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-135.md): 28 registered aircraft · Engine model
- [Pratt & Whitney PT6A-27 series](https://openairdocs.org/engine/pratt-whitney-pt6a-27-series.md): 28 registered aircraft · Engine model
- [Pratt & Whitney PT6A-28 series](https://openairdocs.org/engine/pratt-whitney-pt6a-28-series.md): 25 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-20](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-20.md): 21 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-112](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-112.md): 20 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-28 series](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-28-series.md): 12 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-114](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-114.md): 10 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-25C](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-25c.md): 8 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-35](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-35.md): 7 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-11](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-11.md): 5 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-25A](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-25a.md): 5 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-36](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-36.md): 4 registered aircraft · Engine model
- [Pratt & Whitney PT6A-20A series](https://openairdocs.org/engine/pratt-whitney-pt6a-20a-series.md): 4 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6 series](https://openairdocs.org/engine/pratt-whitney-canada-pt6-series.md): 3 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-11AG](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-11ag.md): 3 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-25](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-25.md): 3 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-20A series](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-20a-series.md): 2 registered aircraft · Engine model
- [U/A Canada PT6A-20](https://openairdocs.org/engine/u-a-canada-pt6a-20.md): 2 registered aircraft · Engine model
- [U/A Canada PT6A-34AG](https://openairdocs.org/engine/u-a-canada-pt6a-34ag.md): 2 registered aircraft · Engine model
- [U/A Canada PT6A-135](https://openairdocs.org/engine/u-a-canada-pt6a-135.md): 1 registered aircraft · Engine model
- [U/A Canada PT6A-135A](https://openairdocs.org/engine/u-a-canada-pt6a-135a.md): 1 registered aircraft · Engine model
- [U/A Canada PT6A-25](https://openairdocs.org/engine/u-a-canada-pt6a-25.md): 1 registered aircraft · Engine model
- [U/A Canada PT6A-6](https://openairdocs.org/engine/u-a-canada-pt6a-6.md): 1 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-110](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-110.md): 0 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-121](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-121.md): 0 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-20B](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-20b.md): 0 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-34B](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-34b.md): 0 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-6](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-6.md): 0 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-6/C20](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-6-c20.md): 0 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-6A](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-6a.md): 0 registered aircraft · Engine model
- [Pratt & Whitney Canada PT6A-6B](https://openairdocs.org/engine/pratt-whitney-canada-pt6a-6b.md): 0 registered aircraft · Engine model
- [U/A Canada PT6A-11](https://openairdocs.org/engine/u-a-canada-pt6a-11.md): 0 registered aircraft · Engine model
- [U/A Canada PT6A-110](https://openairdocs.org/engine/u-a-canada-pt6a-110.md): 0 registered aircraft · Engine model
- [U/A Canada PT6A-112](https://openairdocs.org/engine/u-a-canada-pt6a-112.md): 0 registered aircraft · Engine model
- [U/A Canada PT6A-114](https://openairdocs.org/engine/u-a-canada-pt6a-114.md): 0 registered aircraft · Engine model
- [U/A Canada PT6A-114A](https://openairdocs.org/engine/u-a-canada-pt6a-114a.md): 0 registered aircraft · Engine model
- [U/A Canada PT6A-11AG](https://openairdocs.org/engine/u-a-canada-pt6a-11ag.md): 0 registered aircraft · Engine model
- [U/A Canada PT6A-121](https://openairdocs.org/engine/u-a-canada-pt6a-121.md): 0 registered aircraft · Engine model
- [U/A Canada PT6A-15AG](https://openairdocs.org/engine/u-a-canada-pt6a-15ag.md): 0 registered aircraft · Engine model

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

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