# Registry models it may concern: SAIB AIR-20-19

A list on [SAIB AIR-20-19](https://openairdocs.org/saib/AIR-20-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 · 54 models

- [Boeing 787-9](https://openairdocs.org/model/boeing-787-9.md): 118 registered aircraft · Airframe model
- [Boeing 787-8](https://openairdocs.org/model/boeing-787-8.md): 75 registered aircraft · Airframe model
- [Boeing 777-222](https://openairdocs.org/model/boeing-777-222.md): 52 registered aircraft · Airframe model
- [Boeing 777-223](https://openairdocs.org/model/boeing-777-223.md): 49 registered aircraft · Airframe model
- [Boeing 777F](https://openairdocs.org/model/boeing-777f.md): 47 registered aircraft · Airframe model
- [Boeing 777-300ER](https://openairdocs.org/model/boeing-777-300er.md): 24 registered aircraft · Airframe model
- [Boeing 777-224](https://openairdocs.org/model/boeing-777-224.md): 22 registered aircraft · Airframe model
- [Boeing 787-10](https://openairdocs.org/model/boeing-787-10.md): 21 registered aircraft · Airframe model
- [Boeing 777-323ER](https://openairdocs.org/model/boeing-777-323er.md): 20 registered aircraft · Airframe model
- [Boeing 777-212](https://openairdocs.org/model/boeing-777-212.md): 13 registered aircraft · Airframe model
- [Boeing 777-200](https://openairdocs.org/model/boeing-777-200.md): 8 registered aircraft · Airframe model
- [Boeing 777-232LR](https://openairdocs.org/model/boeing-777-232lr.md): 8 registered aircraft · Airframe model
- [Boeing 777-232](https://openairdocs.org/model/boeing-777-232.md): 7 registered aircraft · Airframe model
- [Boeing 777-246](https://openairdocs.org/model/boeing-777-246.md): 7 registered aircraft · Airframe model
- [Boeing 777-237LR](https://openairdocs.org/model/boeing-777-237lr.md): 3 registered aircraft · Airframe model
- [Boeing 777-266](https://openairdocs.org/model/boeing-777-266.md): 3 registered aircraft · Airframe model
- [Boeing 777-289](https://openairdocs.org/model/boeing-777-289.md): 3 registered aircraft · Airframe model
- [Boeing 777-346](https://openairdocs.org/model/boeing-777-346.md): 3 registered aircraft · Airframe model
- [Boeing 777-367ER](https://openairdocs.org/model/boeing-777-367er.md): 3 registered aircraft · Airframe model
- [Boeing 777-219](https://openairdocs.org/model/boeing-777-219.md): 2 registered aircraft · Airframe model
- [Boeing 777-312](https://openairdocs.org/model/boeing-777-312.md): 2 registered aircraft · Airframe model
- [Boeing 777-381ER](https://openairdocs.org/model/boeing-777-381er.md): 2 registered aircraft · Airframe model
- [Boeing 777-236](https://openairdocs.org/model/boeing-777-236.md): 1 registered aircraft · Airframe model
- [Boeing 777-268](https://openairdocs.org/model/boeing-777-268.md): 1 registered aircraft · Airframe model
- [Boeing 777-200LR](https://openairdocs.org/model/boeing-777-200lr.md): 0 registered aircraft · Airframe model
- [Boeing 777-206](https://openairdocs.org/model/boeing-777-206.md): 0 registered aircraft · Airframe model
- [Boeing 777-228](https://openairdocs.org/model/boeing-777-228.md): 0 registered aircraft · Airframe model
- [Boeing 777-233LR](https://openairdocs.org/model/boeing-777-233lr.md): 0 registered aircraft · Airframe model
- [Boeing 777-240](https://openairdocs.org/model/boeing-777-240.md): 0 registered aircraft · Airframe model
- [Boeing 777-240LR](https://openairdocs.org/model/boeing-777-240lr.md): 0 registered aircraft · Airframe model
- [Boeing 777-243](https://openairdocs.org/model/boeing-777-243.md): 0 registered aircraft · Airframe model
- [Boeing 777-258](https://openairdocs.org/model/boeing-777-258.md): 0 registered aircraft · Airframe model
- [Boeing 777-260LR](https://openairdocs.org/model/boeing-777-260lr.md): 0 registered aircraft · Airframe model
- [Boeing 777-267](https://openairdocs.org/model/boeing-777-267.md): 0 registered aircraft · Airframe model
- [Boeing 777-269](https://openairdocs.org/model/boeing-777-269.md): 0 registered aircraft · Airframe model
- [Boeing 777-278](https://openairdocs.org/model/boeing-777-278.md): 0 registered aircraft · Airframe model
- [Boeing 777-281](https://openairdocs.org/model/boeing-777-281.md): 0 registered aircraft · Airframe model
- [Boeing 777-300](https://openairdocs.org/model/boeing-777-300.md): 0 registered aircraft · Airframe model
- [Boeing 777-306ER](https://openairdocs.org/model/boeing-777-306er.md): 0 registered aircraft · Airframe model
- [Boeing 777-309ER](https://openairdocs.org/model/boeing-777-309er.md): 0 registered aircraft · Airframe model
- [Boeing 777-312ER](https://openairdocs.org/model/boeing-777-312er.md): 0 registered aircraft · Airframe model
- [Boeing 777-316](https://openairdocs.org/model/boeing-777-316.md): 0 registered aircraft · Airframe model
- [Boeing 777-319ER](https://openairdocs.org/model/boeing-777-319er.md): 0 registered aircraft · Airframe model
- [Boeing 777-323](https://openairdocs.org/model/boeing-777-323.md): 0 registered aircraft · Airframe model
- [Boeing 777-328ER](https://openairdocs.org/model/boeing-777-328er.md): 0 registered aircraft · Airframe model
- [Boeing 777-333ER](https://openairdocs.org/model/boeing-777-333er.md): 0 registered aircraft · Airframe model
- [Boeing 777-336ER](https://openairdocs.org/model/boeing-777-336er.md): 0 registered aircraft · Airframe model
- [Boeing 777-337ER](https://openairdocs.org/model/boeing-777-337er.md): 0 registered aircraft · Airframe model
- [Boeing 777-340ER](https://openairdocs.org/model/boeing-777-340er.md): 0 registered aircraft · Airframe model
- [Boeing 777-346ER](https://openairdocs.org/model/boeing-777-346er.md): 0 registered aircraft · Airframe model

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

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