# Registry models it may concern: SAIB NM-08-24 A list on [SAIB NM-08-24](https://openairdocs.org/saib/NM-08-24.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 · 137 models - [Boeing 737-823](https://openairdocs.org/model/boeing-737-823.md): 278 registered aircraft · Airframe model - [Boeing 737-800](https://openairdocs.org/model/boeing-737-800.md): 139 registered aircraft · Airframe model - [Boeing 737-824](https://openairdocs.org/model/boeing-737-824.md): 135 registered aircraft · Airframe model - [Boeing 737-924ER](https://openairdocs.org/model/boeing-737-924er.md): 130 registered aircraft · Airframe model - [Boeing 737-900ER](https://openairdocs.org/model/boeing-737-900er.md): 99 registered aircraft · Airframe model - [Boeing 737-832](https://openairdocs.org/model/boeing-737-832.md): 73 registered aircraft · Airframe model - [Boeing 737-932ER](https://openairdocs.org/model/boeing-737-932er.md): 65 registered aircraft · Airframe model - [Boeing 737-890](https://openairdocs.org/model/boeing-737-890.md): 60 registered aircraft · Airframe model - [Boeing 737-990ER](https://openairdocs.org/model/boeing-737-990er.md): 51 registered aircraft · Airframe model - [Boeing 737-724](https://openairdocs.org/model/boeing-737-724.md): 36 registered aircraft · Airframe model - [Boeing 737-790](https://openairdocs.org/model/boeing-737-790.md): 14 registered aircraft · Airframe model - [Boeing 737-752](https://openairdocs.org/model/boeing-737-752.md): 13 registered aircraft · Airframe model - [Boeing 737-924](https://openairdocs.org/model/boeing-737-924.md): 12 registered aircraft · Airframe model - [Boeing 737-400](https://openairdocs.org/model/boeing-737-400.md): 8 registered aircraft · Airframe model - [Boeing 737-852](https://openairdocs.org/model/boeing-737-852.md): 7 registered aircraft · Airframe model - [Boeing 737-436](https://openairdocs.org/model/boeing-737-436.md): 6 registered aircraft · Airframe model - [Boeing 737-500](https://openairdocs.org/model/boeing-737-500.md): 6 registered aircraft · Airframe model - [Boeing 737-700](https://openairdocs.org/model/boeing-737-700.md): 5 registered aircraft · Airframe model - [Boeing 737-300](https://openairdocs.org/model/boeing-737-300.md): 4 registered aircraft · Airframe model - [Boeing 737-883](https://openairdocs.org/model/boeing-737-883.md): 4 registered aircraft · Airframe model - [Boeing 737-205](https://openairdocs.org/model/boeing-737-205.md): 3 registered aircraft · Airframe model - [Boeing 737-484](https://openairdocs.org/model/boeing-737-484.md): 3 registered aircraft · Airframe model - [Boeing 737-490](https://openairdocs.org/model/boeing-737-490.md): 3 registered aircraft · Airframe model - [Boeing 737-524](https://openairdocs.org/model/boeing-737-524.md): 3 registered aircraft · Airframe model - [Boeing 737-732](https://openairdocs.org/model/boeing-737-732.md): 3 registered aircraft · Airframe model - [Boeing 737-505](https://openairdocs.org/model/boeing-737-505.md): 2 registered aircraft · Airframe model - [Boeing 737-200](https://openairdocs.org/model/boeing-737-200.md): 1 registered aircraft · Airframe model - [Boeing 737-201](https://openairdocs.org/model/boeing-737-201.md): 1 registered aircraft · Airframe model - [Boeing 737-209](https://openairdocs.org/model/boeing-737-209.md): 1 registered aircraft · Airframe model - [Boeing 737-210C](https://openairdocs.org/model/boeing-737-210c.md): 1 registered aircraft · Airframe model - [Boeing 737-242C](https://openairdocs.org/model/boeing-737-242c.md): 1 registered aircraft · Airframe model - [Boeing 737-275C](https://openairdocs.org/model/boeing-737-275c.md): 1 registered aircraft · Airframe model - [Boeing 737-290C](https://openairdocs.org/model/boeing-737-290c.md): 1 registered aircraft · Airframe model - [Boeing 737-301](https://openairdocs.org/model/boeing-737-301.md): 1 registered aircraft · Airframe model - [Boeing 737-306](https://openairdocs.org/model/boeing-737-306.md): 1 registered aircraft · Airframe model - [Boeing 737-319](https://openairdocs.org/model/boeing-737-319.md): 1 registered aircraft · Airframe model - [Boeing 737-330](https://openairdocs.org/model/boeing-737-330.md): 1 registered aircraft · Airframe model - [Boeing 737-401](https://openairdocs.org/model/boeing-737-401.md): 1 registered aircraft · Airframe model - [Boeing 737-405](https://openairdocs.org/model/boeing-737-405.md): 1 registered aircraft · Airframe model - [Boeing 737-528](https://openairdocs.org/model/boeing-737-528.md): 1 registered aircraft · Airframe model - [Boeing 737-705](https://openairdocs.org/model/boeing-737-705.md): 1 registered aircraft · Airframe model - [Boeing 737-804](https://openairdocs.org/model/boeing-737-804.md): 1 registered aircraft · Airframe model - [Boeing 737-808](https://openairdocs.org/model/boeing-737-808.md): 1 registered aircraft · Airframe model - [Boeing 737-809](https://openairdocs.org/model/boeing-737-809.md): 1 registered aircraft · Airframe model - [Boeing 737-112](https://openairdocs.org/model/boeing-737-112.md): 0 registered aircraft · Airframe model - [Boeing 737-130](https://openairdocs.org/model/boeing-737-130.md): 0 registered aircraft · Airframe model - [Boeing 737-200C](https://openairdocs.org/model/boeing-737-200c.md): 0 registered aircraft · Airframe model - [Boeing 737-202C](https://openairdocs.org/model/boeing-737-202c.md): 0 registered aircraft · Airframe model - [Boeing 737-204](https://openairdocs.org/model/boeing-737-204.md): 0 registered aircraft · Airframe model - [Boeing 737-204C](https://openairdocs.org/model/boeing-737-204c.md): 0 registered aircraft · Airframe model Next page: https://openairdocs.org/saib/NM-08-24/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 = 'E65E841E13B8E78B86257451006EB1F1') 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 = 'E65E841E13B8E78B86257451006EB1F1') GROUP BY ALL ORDER BY aircraft DESC, code ``` This list as a web page: https://openairdocs.org/saib/NM-08-24/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.