# Registry models it may concern: SAIB SW-11-07

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

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

- [Airbus Helicopters AS350B3](https://openairdocs.org/model/airbus-helicopters-as350b3.md): 291 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
- [American Eurocopter AS350B3](https://openairdocs.org/model/american-eurocopter-as350b3.md): 124 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
- [Aerospatiale AS350BA](https://openairdocs.org/model/aerospatiale-as350ba.md): 18 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
- [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
- [Aerospatiale AS 355F1](https://openairdocs.org/model/aerospatiale-as-355f1.md): 9 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
- [Aerospatiale AS 355F2](https://openairdocs.org/model/aerospatiale-as-355f2.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
- [Eurocopter/France AS355N TWINSTAR](https://openairdocs.org/model/eurocopter-france-as355n-twinstar.md): 4 registered aircraft · Airframe model
- [Aerospatiale AS355F2 ECUREUIL](https://openairdocs.org/model/aerospatiale-as355f2-ecureuil.md): 3 registered aircraft · Airframe model
- [Aerospatiale AS350B1 ECUREUIL](https://openairdocs.org/model/aerospatiale-as350b1-ecureuil.md): 2 registered aircraft · Airframe model
- [Aerospatiale AS355F TWINSTAR](https://openairdocs.org/model/aerospatiale-as355f-twinstar.md): 2 registered aircraft · Airframe model
- [Airbus Helicopters AS350BA](https://openairdocs.org/model/airbus-helicopters-as350ba.md): 2 registered aircraft · Airframe model
- [Airbus Helicopters AS355N](https://openairdocs.org/model/airbus-helicopters-as355n.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
- [Aerospatiale AS-355E TWIN STAR](https://openairdocs.org/model/aerospatiale-as-355e-twin-star.md): 1 registered aircraft · Airframe model
- [Aerospatiale AS355N](https://openairdocs.org/model/aerospatiale-as355n.md): 1 registered aircraft · Airframe model
- [Airbus Helicopter AS355F1](https://openairdocs.org/model/airbus-helicopter-as355f1.md): 1 registered aircraft · Airframe model
- [Airbus Helicopters AS355F2](https://openairdocs.org/model/airbus-helicopters-as355f2.md): 1 registered aircraft · Airframe model
- [Eurocopter AS 355N](https://openairdocs.org/model/eurocopter-as-355n.md): 1 registered aircraft · Airframe model
- [Eurocopter AS350B](https://openairdocs.org/model/eurocopter-as350b.md): 1 registered aircraft · Airframe model
- [Eurocopter AS355NP](https://openairdocs.org/model/eurocopter-as355np.md): 1 registered aircraft · Airframe model
- [Eurocopter France AS350B](https://openairdocs.org/model/eurocopter-france-as350b.md): 1 registered aircraft · Airframe model
- [Eurocopter France AS355F2](https://openairdocs.org/model/eurocopter-france-as355f2.md): 1 registered aircraft · Airframe model
- [S N I A S AS 355F](https://openairdocs.org/model/s-n-i-a-s-as-355f.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 AS 355F](https://openairdocs.org/model/aerospatiale-as-355f.md): 0 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
- [Airbus Helicopters AS355NP](https://openairdocs.org/model/airbus-helicopters-as355np.md): 0 registered aircraft · Airframe model
- [Eurocopter AS350-B-1](https://openairdocs.org/model/eurocopter-as350-b-1.md): 0 registered aircraft · Airframe model
- [Eurocopter France AS355F1](https://openairdocs.org/model/eurocopter-france-as355f1.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
- [S N I A S AS355 F2](https://openairdocs.org/model/s-n-i-a-s-as355-f2.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 = '770847295AA121BF862577FF00563AC5')
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 = '770847295AA121BF862577FF00563AC5')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

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