# Registered aircraft: TCDS A10CE

A list on [TCDS A10CE](https://openairdocs.org/tcds/A10CE.md).

Registry models that point at this data sheet: 705 registered aircraft in all. Each model’s page lists its aircraft.

- [Learjet 60](https://openairdocs.org/model/learjet-60.md): 237 registered aircraft · Registry code 5170707
- [Gates Learjet 35A](https://openairdocs.org/model/gates-learjet-35a.md): 135 registered aircraft · Registry code 5170602
- [Learjet 31A](https://openairdocs.org/model/learjet-31a.md): 104 registered aircraft · Registry code 5170531
- [Gates Learjet 55](https://openairdocs.org/model/gates-learjet-55.md): 54 registered aircraft · Registry code 5170702
- [Learjet 35A](https://openairdocs.org/model/learjet-35a.md): 24 registered aircraft · Registry codes 5170802, 5170711
- [Gates Lear Jet 36A](https://openairdocs.org/model/gates-lear-jet-36a.md): 21 registered aircraft · Registry code 5170603
- [Gates Learjet 25D](https://openairdocs.org/model/gates-learjet-25d.md): 20 registered aircraft · Registry code 5170514
- [Gates Lear Jet 35](https://openairdocs.org/model/gates-lear-jet-35.md): 16 registered aircraft · Registry code 5170600
- [Learjet 31](https://openairdocs.org/model/learjet-31.md): 15 registered aircraft · Registry code 5170530
- [Gates Lear Jet 36](https://openairdocs.org/model/gates-lear-jet-36.md): 13 registered aircraft · Registry code 5170601
- [Gates Lear Jet 25B](https://openairdocs.org/model/gates-lear-jet-25b.md): 12 registered aircraft · Registry code 5170511
- [Gates Lear Jet 24D](https://openairdocs.org/model/gates-lear-jet-24d.md): 7 registered aircraft · Registry code 5170311
- [Learjet 24](https://openairdocs.org/model/learjet-24.md): 7 registered aircraft · Registry code 5170302
- [Gates Learjet 55C](https://openairdocs.org/model/gates-learjet-55c.md): 6 registered aircraft · Registry code 5170706
- [Gates Lear Jet 24F](https://openairdocs.org/model/gates-lear-jet-24f.md): 4 registered aircraft · Registry code 5170317
- [Learjet 24D](https://openairdocs.org/model/learjet-24d.md): 4 registered aircraft · Registry code 5170310
- [Learjet 55](https://openairdocs.org/model/learjet-55.md): 4 registered aircraft · Registry code 5170804
- [Gates Lear Jet 28](https://openairdocs.org/model/gates-lear-jet-28.md): 3 registered aircraft · Registry code 5170528
- [Gates Learjet 55B](https://openairdocs.org/model/gates-learjet-55b.md): 3 registered aircraft · Registry code 5170705
- [Learjet 24B](https://openairdocs.org/model/learjet-24b.md): 3 registered aircraft · Registry code 5170306
- [Gates Lear Jet 24E](https://openairdocs.org/model/gates-lear-jet-24e.md): 2 registered aircraft · Registry code 5170316
- [Learjet 24A](https://openairdocs.org/model/learjet-24a.md): 2 registered aircraft · Registry code 5170304
- [Learjet 25](https://openairdocs.org/model/learjet-25.md): 2 registered aircraft · Registry code 5170506
- [Learjet 60 XR](https://openairdocs.org/model/learjet-60-xr.md): 2 registered aircraft · Registry code 5170710
- [Gates Lear Jet 25](https://openairdocs.org/model/gates-lear-jet-25.md): 1 registered aircraft · Registry code 5170509
- [Gates Lear Jet 25C](https://openairdocs.org/model/gates-lear-jet-25c.md): 1 registered aircraft · Registry code 5170513
- [Gates Learjet 35A (C-21A)](https://openairdocs.org/model/gates-learjet-35a-c-21a.md): 1 registered aircraft · Registry code 5170809
- [Learjet 25D](https://openairdocs.org/model/learjet-25d.md): 1 registered aircraft · Registry code 5170515
- [Learjet 35](https://openairdocs.org/model/learjet-35.md): 1 registered aircraft · Registry code 5170803
- [Gates Lear Jet 24B](https://openairdocs.org/model/gates-lear-jet-24b.md): 0 registered aircraft · Registry code 5170307
- [Gates Lear Jet 24B-A](https://openairdocs.org/model/gates-lear-jet-24b-a.md): 0 registered aircraft · Registry code 5170308
- [Gates Lear Jet 24C](https://openairdocs.org/model/gates-lear-jet-24c.md): 0 registered aircraft · Registry code 5170309
- [Gates Lear Jet 24D-A](https://openairdocs.org/model/gates-lear-jet-24d-a.md): 0 registered aircraft · Registry code 5170312
- [Gates Lear Jet 25F](https://openairdocs.org/model/gates-lear-jet-25f.md): 0 registered aircraft · Registry code 5170516
- [Gates Lear Jet 29](https://openairdocs.org/model/gates-lear-jet-29.md): 0 registered aircraft · Registry code 5170529
- [Gates Learjet 24](https://openairdocs.org/model/gates-learjet-24.md): 0 registered aircraft · Registry code 5170301
- [Learjet 24F-A](https://openairdocs.org/model/learjet-24f-a.md): 0 registered aircraft · Registry code 5170527
- [Learjet 55C](https://openairdocs.org/model/learjet-55c.md): 0 registered aircraft · Registry code 5170708

## 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 code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' WHERE tcds_number = 'A10CE')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

This list as a web page: https://openairdocs.org/tcds/A10CE/aircraft

---
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.