# Registry models it may concern: SAIB AIR-21-16 A list on [SAIB AIR-21-16](https://openairdocs.org/saib/AIR-21-16.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 · 85 models - [Cessna 172M](https://openairdocs.org/model/cessna-172m.md): 3,573 registered aircraft · Airframe model - [Cessna 172N](https://openairdocs.org/model/cessna-172n.md): 3,138 registered aircraft · Airframe model - [Cessna 182P](https://openairdocs.org/model/cessna-182p.md): 2,099 registered aircraft · Airframe model - [Cessna 182Q](https://openairdocs.org/model/cessna-182q.md): 1,565 registered aircraft · Airframe model - [Cessna A185F](https://openairdocs.org/model/cessna-a185f.md): 1,120 registered aircraft · Airframe model - [Cessna 172P](https://openairdocs.org/model/cessna-172p.md): 1,111 registered aircraft · Airframe model - [Cessna 172K](https://openairdocs.org/model/cessna-172k.md): 1,026 registered aircraft · Airframe model - [Cessna 172L](https://openairdocs.org/model/cessna-172l.md): 857 registered aircraft · Airframe model - [Cessna 177B](https://openairdocs.org/model/cessna-177b.md): 843 registered aircraft · Airframe model - [Cessna 177RG](https://openairdocs.org/model/cessna-177rg.md): 788 registered aircraft · Airframe model - [Cessna R172K](https://openairdocs.org/model/cessna-r172k.md): 653 registered aircraft · Airframe model - [Cessna 182R](https://openairdocs.org/model/cessna-182r.md): 487 registered aircraft · Airframe model - [Cessna T210N](https://openairdocs.org/model/cessna-t210n.md): 466 registered aircraft · Airframe model - [Cessna 177](https://openairdocs.org/model/cessna-177.md): 446 registered aircraft · Airframe model - [Cessna 182M](https://openairdocs.org/model/cessna-182m.md): 432 registered aircraft · Airframe model - [Cessna 180H](https://openairdocs.org/model/cessna-180h.md): 366 registered aircraft · Airframe model - [Cessna U206G](https://openairdocs.org/model/cessna-u206g.md): 347 registered aircraft · Airframe model - [Cessna 182N](https://openairdocs.org/model/cessna-182n.md): 336 registered aircraft · Airframe model - [Cessna T210M](https://openairdocs.org/model/cessna-t210m.md): 321 registered aircraft · Airframe model - [Cessna T210L](https://openairdocs.org/model/cessna-t210l.md): 305 registered aircraft · Airframe model - [Cessna 180K](https://openairdocs.org/model/cessna-180k.md): 274 registered aircraft · Airframe model - [Cessna 180J](https://openairdocs.org/model/cessna-180j.md): 266 registered aircraft · Airframe model - [Cessna A185E](https://openairdocs.org/model/cessna-a185e.md): 252 registered aircraft · Airframe model - [Cessna 210L](https://openairdocs.org/model/cessna-210l.md): 234 registered aircraft · Airframe model - [Cessna U206F](https://openairdocs.org/model/cessna-u206f.md): 230 registered aircraft · Airframe model - [Cessna A188B](https://openairdocs.org/model/cessna-a188b.md): 212 registered aircraft · Airframe model - [Cessna 210M](https://openairdocs.org/model/cessna-210m.md): 122 registered aircraft · Airframe model - [Cessna T337G](https://openairdocs.org/model/cessna-t337g.md): 118 registered aircraft · Airframe model - [Cessna 337G](https://openairdocs.org/model/cessna-337g.md): 96 registered aircraft · Airframe model - [Cessna 177A](https://openairdocs.org/model/cessna-177a.md): 81 registered aircraft · Airframe model - [Cessna 210N](https://openairdocs.org/model/cessna-210n.md): 81 registered aircraft · Airframe model - [Cessna 207A](https://openairdocs.org/model/cessna-207a.md): 75 registered aircraft · Airframe model - [Cessna 337A](https://openairdocs.org/model/cessna-337a.md): 55 registered aircraft · Airframe model - [Cessna 210K](https://openairdocs.org/model/cessna-210k.md): 50 registered aircraft · Airframe model - [Cessna 337](https://openairdocs.org/model/cessna-337.md): 50 registered aircraft · Airframe model - [Cessna T207A](https://openairdocs.org/model/cessna-t207a.md): 44 registered aircraft · Airframe model - [Cessna 337D](https://openairdocs.org/model/cessna-337d.md): 42 registered aircraft · Airframe model - [Cessna T188C](https://openairdocs.org/model/cessna-t188c.md): 42 registered aircraft · Airframe model - [Cessna 207](https://openairdocs.org/model/cessna-207.md): 40 registered aircraft · Airframe model - [Cessna 337B](https://openairdocs.org/model/cessna-337b.md): 40 registered aircraft · Airframe model - [Cessna M337B](https://openairdocs.org/model/cessna-m337b.md): 34 registered aircraft · Airframe model - [Cessna 337C](https://openairdocs.org/model/cessna-337c.md): 33 registered aircraft · Airframe model - [Cessna P337H](https://openairdocs.org/model/cessna-p337h.md): 31 registered aircraft · Airframe model - [Cessna U206E](https://openairdocs.org/model/cessna-u206e.md): 31 registered aircraft · Airframe model - [Cessna P206D](https://openairdocs.org/model/cessna-p206d.md): 28 registered aircraft · Airframe model - [Cessna T210R](https://openairdocs.org/model/cessna-t210r.md): 28 registered aircraft · Airframe model - [Cessna T210K](https://openairdocs.org/model/cessna-t210k.md): 26 registered aircraft · Airframe model - [Cessna U206D](https://openairdocs.org/model/cessna-u206d.md): 26 registered aircraft · Airframe model - [Cessna 337F](https://openairdocs.org/model/cessna-337f.md): 24 registered aircraft · Airframe model - [Cessna T337H](https://openairdocs.org/model/cessna-t337h.md): 23 registered aircraft · Airframe model Next page: https://openairdocs.org/saib/AIR-21-16/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 = 'D9651BF0C0DC61058625873D00675DBC') 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 = 'D9651BF0C0DC61058625873D00675DBC') GROUP BY ALL ORDER BY aircraft DESC, code ``` This list as a web page: https://openairdocs.org/saib/AIR-21-16/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.