# Registry models it may concern: SAIB NM-09-27

A list on [SAIB NM-09-27](https://openairdocs.org/saib/NM-09-27.md).

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

Page 1 of 3 · 104 models

- [Boeing 747-446](https://openairdocs.org/model/boeing-747-446.md): 10 registered aircraft · Airframe model
- [Boeing 747-422](https://openairdocs.org/model/boeing-747-422.md): 8 registered aircraft · Airframe model
- [Boeing 747-412](https://openairdocs.org/model/boeing-747-412.md): 5 registered aircraft · Airframe model
- [Boeing 747-400F](https://openairdocs.org/model/boeing-747-400f.md): 4 registered aircraft · Airframe model
- [Boeing 747-409](https://openairdocs.org/model/boeing-747-409.md): 4 registered aircraft · Airframe model
- [Boeing 747-409F](https://openairdocs.org/model/boeing-747-409f.md): 3 registered aircraft · Airframe model
- [Boeing 747-428F](https://openairdocs.org/model/boeing-747-428f.md): 3 registered aircraft · Airframe model
- [Boeing 747-481](https://openairdocs.org/model/boeing-747-481.md): 3 registered aircraft · Airframe model
- [Boeing 747-481F](https://openairdocs.org/model/boeing-747-481f.md): 3 registered aircraft · Airframe model
- [Boeing 747-123](https://openairdocs.org/model/boeing-747-123.md): 2 registered aircraft · Airframe model
- [Boeing 747-251F](https://openairdocs.org/model/boeing-747-251f.md): 2 registered aircraft · Airframe model
- [Boeing 747-428](https://openairdocs.org/model/boeing-747-428.md): 2 registered aircraft · Airframe model
- [Boeing 747-438](https://openairdocs.org/model/boeing-747-438.md): 2 registered aircraft · Airframe model
- [Boeing 747-443](https://openairdocs.org/model/boeing-747-443.md): 2 registered aircraft · Airframe model
- [Boeing 747-121](https://openairdocs.org/model/boeing-747-121.md): 1 registered aircraft · Airframe model
- [Boeing 747-128](https://openairdocs.org/model/boeing-747-128.md): 1 registered aircraft · Airframe model
- [Boeing 747-131](https://openairdocs.org/model/boeing-747-131.md): 1 registered aircraft · Airframe model
- [Boeing 747-257B](https://openairdocs.org/model/boeing-747-257b.md): 1 registered aircraft · Airframe model
- [Boeing 747-273C](https://openairdocs.org/model/boeing-747-273c.md): 1 registered aircraft · Airframe model
- [Boeing 747-283B](https://openairdocs.org/model/boeing-747-283b.md): 1 registered aircraft · Airframe model
- [Boeing 747-400](https://openairdocs.org/model/boeing-747-400.md): 1 registered aircraft · Airframe model
- [Boeing 747-412F](https://openairdocs.org/model/boeing-747-412f.md): 1 registered aircraft · Airframe model
- [Boeing 747-451](https://openairdocs.org/model/boeing-747-451.md): 1 registered aircraft · Airframe model
- [Boeing 747-467F](https://openairdocs.org/model/boeing-747-467f.md): 1 registered aircraft · Airframe model
- [Boeing 747-100](https://openairdocs.org/model/boeing-747-100.md): 0 registered aircraft · Airframe model
- [Boeing 747-100B](https://openairdocs.org/model/boeing-747-100b.md): 0 registered aircraft · Airframe model
- [Boeing 747-100B-SUD](https://openairdocs.org/model/boeing-747-100b-sud.md): 0 registered aircraft · Airframe model
- [Boeing 747-101](https://openairdocs.org/model/boeing-747-101.md): 0 registered aircraft · Airframe model
- [Boeing 747-122](https://openairdocs.org/model/boeing-747-122.md): 0 registered aircraft · Airframe model
- [Boeing 747-124](https://openairdocs.org/model/boeing-747-124.md): 0 registered aircraft · Airframe model
- [Boeing 747-127](https://openairdocs.org/model/boeing-747-127.md): 0 registered aircraft · Airframe model
- [Boeing 747-129](https://openairdocs.org/model/boeing-747-129.md): 0 registered aircraft · Airframe model
- [Boeing 747-130](https://openairdocs.org/model/boeing-747-130.md): 0 registered aircraft · Airframe model
- [Boeing 747-132](https://openairdocs.org/model/boeing-747-132.md): 0 registered aircraft · Airframe model
- [Boeing 747-133](https://openairdocs.org/model/boeing-747-133.md): 0 registered aircraft · Airframe model
- [Boeing 747-136](https://openairdocs.org/model/boeing-747-136.md): 0 registered aircraft · Airframe model
- [Boeing 747-143](https://openairdocs.org/model/boeing-747-143.md): 0 registered aircraft · Airframe model
- [Boeing 747-146](https://openairdocs.org/model/boeing-747-146.md): 0 registered aircraft · Airframe model
- [Boeing 747-146B](https://openairdocs.org/model/boeing-747-146b.md): 0 registered aircraft · Airframe model
- [Boeing 747-148](https://openairdocs.org/model/boeing-747-148.md): 0 registered aircraft · Airframe model
- [Boeing 747-151](https://openairdocs.org/model/boeing-747-151.md): 0 registered aircraft · Airframe model
- [Boeing 747-156](https://openairdocs.org/model/boeing-747-156.md): 0 registered aircraft · Airframe model
- [Boeing 747-168B](https://openairdocs.org/model/boeing-747-168b.md): 0 registered aircraft · Airframe model
- [Boeing 747-186B](https://openairdocs.org/model/boeing-747-186b.md): 0 registered aircraft · Airframe model
- [Boeing 747-200B](https://openairdocs.org/model/boeing-747-200b.md): 0 registered aircraft · Airframe model
- [Boeing 747-200C](https://openairdocs.org/model/boeing-747-200c.md): 0 registered aircraft · Airframe model
- [Boeing 747-200F](https://openairdocs.org/model/boeing-747-200f.md): 0 registered aircraft · Airframe model
- [Boeing 747-206B](https://openairdocs.org/model/boeing-747-206b.md): 0 registered aircraft · Airframe model
- [Boeing 747-209B](https://openairdocs.org/model/boeing-747-209b.md): 0 registered aircraft · Airframe model
- [Boeing 747-209F](https://openairdocs.org/model/boeing-747-209f.md): 0 registered aircraft · Airframe model

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

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