# Registry models it may concern: SAIB SW-15-20

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

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

- [Bell Helicopter Textron Canada 407](https://openairdocs.org/model/bell-helicopter-textron-canada-407.md): 418 registered aircraft · Airframe model
- [Bell 407](https://openairdocs.org/model/bell-407.md): 371 registered aircraft · Airframe model
- [Airbus Helicopters AS350B3](https://openairdocs.org/model/airbus-helicopters-as350b3.md): 291 registered aircraft · Airframe model
- [Bell Textron Canada 407](https://openairdocs.org/model/bell-textron-canada-407.md): 196 registered aircraft · Airframe model
- [Eurocopter AS 350 B3](https://openairdocs.org/model/eurocopter-as-350-b3.md): 167 registered aircraft · Airframe model
- [Eurocopter EC 130 B4](https://openairdocs.org/model/eurocopter-ec-130-b4.md): 154 registered aircraft · Airframe model
- [Eurocopter AS 350 B2](https://openairdocs.org/model/eurocopter-as-350-b2.md): 146 registered aircraft · Airframe model
- [Airbus Helicopters EC 130 T2](https://openairdocs.org/model/airbus-helicopters-ec-130-t2.md): 124 registered aircraft · Airframe model
- [American Eurocopter AS350B3](https://openairdocs.org/model/american-eurocopter-as350b3.md): 124 registered aircraft · Airframe model
- [Eurocopter EC120B](https://openairdocs.org/model/eurocopter-ec120b.md): 68 registered aircraft · Airframe model
- [Airbus Helicopters AS 350B3](https://openairdocs.org/model/airbus-helicopters-as-350b3.md): 56 registered aircraft · Airframe model
- [American Eurocopter AS350B2](https://openairdocs.org/model/american-eurocopter-as350b2.md): 38 registered aircraft · Airframe model
- [Eurocopter EC 130 T2](https://openairdocs.org/model/eurocopter-ec-130-t2.md): 22 registered aircraft · Airframe model
- [Aerospatiale AS350BA](https://openairdocs.org/model/aerospatiale-as350ba.md): 18 registered aircraft · Airframe model
- [Bell 206](https://openairdocs.org/model/bell-206.md): 16 registered aircraft · Airframe model
- [Aerospatiale AS350B](https://openairdocs.org/model/aerospatiale-as350b.md): 13 registered aircraft · Airframe model
- [Eurocopter AS 350 BA](https://openairdocs.org/model/eurocopter-as-350-ba.md): 13 registered aircraft · Airframe model
- [Agusta A119](https://openairdocs.org/model/agusta-a119.md): 12 registered aircraft · Airframe model
- [Aerospatiale AS350B2](https://openairdocs.org/model/aerospatiale-as350b2.md): 11 registered aircraft · Airframe model
- [Airbus Helicopters AS350B2](https://openairdocs.org/model/airbus-helicopters-as350b2.md): 10 registered aircraft · Airframe model
- [Eurocopter France AS 350 B3](https://openairdocs.org/model/eurocopter-france-as-350-b3.md): 8 registered aircraft · Airframe model
- [Eurocopter France AS350B2](https://openairdocs.org/model/eurocopter-france-as350b2.md): 8 registered aircraft · Airframe model
- [Bell Helicopter Textron Canada 427](https://openairdocs.org/model/bell-helicopter-textron-canada-427.md): 7 registered aircraft · Airframe model
- [Bell 427](https://openairdocs.org/model/bell-427.md): 6 registered aircraft · Airframe model
- [Eurocopter France EC 130 B4](https://openairdocs.org/model/eurocopter-france-ec-130-b4.md): 6 registered aircraft · Airframe model
- [S N I A S AS-350B ECUREUIL](https://openairdocs.org/model/s-n-i-a-s-as-350b-ecureuil.md): 5 registered aircraft · Airframe model
- [Aerospatiale AS350B1 ECUREUIL](https://openairdocs.org/model/aerospatiale-as350b1-ecureuil.md): 2 registered aircraft · Airframe model
- [Airbus Helicopters AS350BA](https://openairdocs.org/model/airbus-helicopters-as350ba.md): 2 registered aircraft · Airframe model
- [Airbus Helicopters EC 130B4](https://openairdocs.org/model/airbus-helicopters-ec-130b4.md): 2 registered aircraft · Airframe model
- [Eurocopter France AS350BA](https://openairdocs.org/model/eurocopter-france-as350ba.md): 2 registered aircraft · Airframe model
- [Airbus Helicopters EC120B](https://openairdocs.org/model/airbus-helicopters-ec120b.md): 1 registered aircraft · Airframe model
- [Eurocopter AS350B](https://openairdocs.org/model/eurocopter-as350b.md): 1 registered aircraft · Airframe model
- [Eurocopter France AS350B](https://openairdocs.org/model/eurocopter-france-as350b.md): 1 registered aircraft · Airframe model
- [Eurocopter France EC120B](https://openairdocs.org/model/eurocopter-france-ec120b.md): 1 registered aircraft · Airframe model
- [S N I A S AS350BA](https://openairdocs.org/model/s-n-i-a-s-as350ba.md): 1 registered aircraft · Airframe model
- [S N I A S AS350D ASTAR](https://openairdocs.org/model/s-n-i-a-s-as350d-astar.md): 1 registered aircraft · Airframe model
- [Aerospatiale AS350B ECUREUIL](https://openairdocs.org/model/aerospatiale-as350b-ecureuil.md): 0 registered aircraft · Airframe model
- [Aerospatiale AS350D](https://openairdocs.org/model/aerospatiale-as350d.md): 0 registered aircraft · Airframe model
- [Agusta Aerospace A119](https://openairdocs.org/model/agusta-aerospace-a119.md): 0 registered aircraft · Airframe model
- [Bell/Sparks 206](https://openairdocs.org/model/bell-sparks-206.md): 0 registered aircraft · Airframe model
- [Eurocopter AS350-B-1](https://openairdocs.org/model/eurocopter-as350-b-1.md): 0 registered aircraft · Airframe model
- [Helibras AS 350 B3](https://openairdocs.org/model/helibras-as-350-b3.md): 0 registered aircraft · Airframe model
- [Helibras AS-350B2](https://openairdocs.org/model/helibras-as-350b2.md): 0 registered aircraft · Airframe model
- [S N I A S AS-350B2](https://openairdocs.org/model/s-n-i-a-s-as-350b2.md): 0 registered aircraft · Airframe model
- [S N I A S AS-350C ASTAR](https://openairdocs.org/model/s-n-i-a-s-as-350c-astar.md): 0 registered aircraft · Airframe model
- [S N I A S AS350B1 ECUREUIL](https://openairdocs.org/model/s-n-i-a-s-as350b1-ecureuil.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 = '78E20CBB0D2DB8C786257EA00061EF7A')
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 = '78E20CBB0D2DB8C786257EA00061EF7A')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

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