# Registry models it may concern: SAIB SW-17-28

A list on [SAIB SW-17-28](https://openairdocs.org/saib/SW-17-28.md).

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

- [Boeing A75N1(PT17)](https://openairdocs.org/model/boeing-a75n1-pt17.md): 760 registered aircraft · Airframe model
- [Boeing E75](https://openairdocs.org/model/boeing-e75.md): 261 registered aircraft · Airframe model
- [Boeing B75N1](https://openairdocs.org/model/boeing-b75n1.md): 241 registered aircraft · Airframe model
- [Boeing A75](https://openairdocs.org/model/boeing-a75.md): 93 registered aircraft · Airframe model
- [Boeing E75N1](https://openairdocs.org/model/boeing-e75n1.md): 79 registered aircraft · Airframe model
- [Boeing A75N1](https://openairdocs.org/model/boeing-a75n1.md): 59 registered aircraft · Airframe model
- [Boeing D75N1](https://openairdocs.org/model/boeing-d75n1.md): 35 registered aircraft · Airframe model
- [Boeing A75L300](https://openairdocs.org/model/boeing-a75l300.md): 33 registered aircraft · Airframe model
- [Boeing A75L3](https://openairdocs.org/model/boeing-a75l3.md): 32 registered aircraft · Airframe model
- [Boeing 75](https://openairdocs.org/model/boeing-75.md): 18 registered aircraft · Airframe model
- [Boeing B75](https://openairdocs.org/model/boeing-b75.md): 15 registered aircraft · Airframe model
- [Boeing IB75A](https://openairdocs.org/model/boeing-ib75a.md): 12 registered aircraft · Airframe model
- [Boeing A75J1](https://openairdocs.org/model/boeing-a75j1.md): 2 registered aircraft · Airframe model
- [Boeing E75(N2S-5)](https://openairdocs.org/model/boeing-e75-n2s-5.md): 2 registered aircraft · Airframe model
- [Boeing B75(N2S-2)](https://openairdocs.org/model/boeing-b75-n2s-2.md): 1 registered aircraft · Airframe model
- [Boeing Stearman/Huff A75-N1](https://openairdocs.org/model/boeing-stearman-huff-a75-n1.md): 1 registered aircraft · Airframe model
- [Boeing/Cains Richard G A75N1](https://openairdocs.org/model/boeing-cains-richard-g-a75n1.md): 1 registered aircraft · Airframe model
- [Boeing/Dekker A75N1](https://openairdocs.org/model/boeing-dekker-a75n1.md): 1 registered aircraft · Airframe model
- [Boeing/Hawk E-75](https://openairdocs.org/model/boeing-hawk-e-75.md): 1 registered aircraft · Airframe model
- [Boeing/Humm Stanley A75-N1](https://openairdocs.org/model/boeing-humm-stanley-a75-n1.md): 1 registered aircraft · Airframe model
- [Boeing/Johnson A75N1](https://openairdocs.org/model/boeing-johnson-a75n1.md): 1 registered aircraft · Airframe model
- [Boeing/Mays A75N1](https://openairdocs.org/model/boeing-mays-a75n1.md): 1 registered aircraft · Airframe model
- [Boeing/Mehrer A75N1](https://openairdocs.org/model/boeing-mehrer-a75n1.md): 1 registered aircraft · Airframe model
- [Boeing/Mountain View Air Rep A75N1](https://openairdocs.org/model/boeing-mountain-view-air-rep-a75n1.md): 1 registered aircraft · Airframe model
- [Boeing/Porter/Epperson B-75N1](https://openairdocs.org/model/boeing-porter-epperson-b-75n1.md): 1 registered aircraft · Airframe model
- [Boeing/Smith A75N1](https://openairdocs.org/model/boeing-smith-a75n1.md): 1 registered aircraft · Airframe model
- [Boeing/Stiles R B75N1](https://openairdocs.org/model/boeing-stiles-r-b75n1.md): 1 registered aircraft · Airframe model
- [Boeing / Farhat B75N1](https://openairdocs.org/model/boeing-farhat-b75n1.md): 0 registered aircraft · Airframe model
- [Boeing / Ryan STEARMAN A75N1](https://openairdocs.org/model/boeing-ryan-stearman-a75n1.md): 0 registered aircraft · Airframe model
- [Boeing A75 (PT13)](https://openairdocs.org/model/boeing-a75-pt13.md): 0 registered aircraft · Airframe model
- [Boeing E75 (PT-13D)](https://openairdocs.org/model/boeing-e75-pt-13d.md): 0 registered aircraft · Airframe model
- [Boeing E75(N2S5)](https://openairdocs.org/model/boeing-e75-n2s5.md): 0 registered aircraft · Airframe model
- [Boeing-Phibbs 75](https://openairdocs.org/model/boeing-phibbs-75.md): 0 registered aircraft · Airframe model
- [Boeing-Stearman/Shacklette A75N1](https://openairdocs.org/model/boeing-stearman-shacklette-a75n1.md): 0 registered aircraft · Airframe model
- [Boeing/Alianelli/Prim A75-N1](https://openairdocs.org/model/boeing-alianelli-prim-a75-n1.md): 0 registered aircraft · Airframe model
- [Boeing/Classic Planes 75](https://openairdocs.org/model/boeing-classic-planes-75.md): 0 registered aircraft · Airframe model
- [Boeing/Corsaut A75N1](https://openairdocs.org/model/boeing-corsaut-a75n1.md): 0 registered aircraft · Airframe model
- [Boeing/Cox A75-N1](https://openairdocs.org/model/boeing-cox-a75-n1.md): 0 registered aircraft · Airframe model
- [Boeing/Gillespie A75N1](https://openairdocs.org/model/boeing-gillespie-a75n1.md): 0 registered aircraft · Airframe model
- [Boeing/Mocabee B75N1](https://openairdocs.org/model/boeing-mocabee-b75n1.md): 0 registered aircraft · Airframe model
- [Boeing/White Scott E75N1](https://openairdocs.org/model/boeing-white-scott-e75n1.md): 0 registered aircraft · Airframe model
- [Boeing/Wright Joe W B75N1](https://openairdocs.org/model/boeing-wright-joe-w-b75n1.md): 0 registered aircraft · Airframe model
- [Boeing/Younkin A-75](https://openairdocs.org/model/boeing-younkin-a-75.md): 0 registered aircraft · Airframe 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 = '3100F0794BD386D6862581B5005027EB')
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 = '3100F0794BD386D6862581B5005027EB')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

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