# Registered aircraft: TCDS B02CE

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

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

- [Ultramagic N-300](https://openairdocs.org/model/ultramagic-n-300.md): 18 registered aircraft · Registry code 9130013
- [Ultramagic S A N-250](https://openairdocs.org/model/ultramagic-s-a-n-250.md): 13 registered aircraft · Registry code 9130008
- [Ultramagic N-210](https://openairdocs.org/model/ultramagic-n-210.md): 9 registered aircraft · Registry code 9230016
- [Ultramagic M-105](https://openairdocs.org/model/ultramagic-m-105.md): 7 registered aircraft · Registry code 9130002
- [Ultramagic M-90](https://openairdocs.org/model/ultramagic-m-90.md): 7 registered aircraft · Registry code 9130005
- [Ultramagic T210](https://openairdocs.org/model/ultramagic-t210.md): 7 registered aircraft · Registry code 9230012
- [Ultramagic M-56C](https://openairdocs.org/model/ultramagic-m-56c.md): 6 registered aircraft · Registry code 9230014
- [Ultramagic S A N-300](https://openairdocs.org/model/ultramagic-s-a-n-300.md): 6 registered aircraft · Registry code 9129997
- [Ultramagic M-130](https://openairdocs.org/model/ultramagic-m-130.md): 5 registered aircraft · Registry code 9230015
- [Ultramagic M-60Z](https://openairdocs.org/model/ultramagic-m-60z.md): 5 registered aircraft · Registry code 9230018
- [Ultramagic N-180](https://openairdocs.org/model/ultramagic-n-180.md): 5 registered aircraft · Registry code 9130004
- [Ultramagic S A Z-90](https://openairdocs.org/model/ultramagic-s-a-z-90.md): 5 registered aircraft · Registry code 9240001
- [Ultramagic H-77](https://openairdocs.org/model/ultramagic-h-77.md): 4 registered aircraft · Registry code 9130009
- [Ultramagic M-77](https://openairdocs.org/model/ultramagic-m-77.md): 4 registered aircraft · Registry code 9130001
- [Ultramagic N-425](https://openairdocs.org/model/ultramagic-n-425.md): 4 registered aircraft · Registry code 9130017
- [Ultramagic S-160](https://openairdocs.org/model/ultramagic-s-160.md): 4 registered aircraft · Registry code 9130006
- [Ultramagic S-90](https://openairdocs.org/model/ultramagic-s-90.md): 4 registered aircraft · Registry code 9130011
- [Ultramagic T-180](https://openairdocs.org/model/ultramagic-t-180.md): 4 registered aircraft · Registry code 9130014
- [Ultramagic B-70](https://openairdocs.org/model/ultramagic-b-70.md): 3 registered aircraft · Registry code 9130026
- [Ultramagic M-160](https://openairdocs.org/model/ultramagic-m-160.md): 3 registered aircraft · Registry code 9130016
- [Ultramagic M-65C](https://openairdocs.org/model/ultramagic-m-65c.md): 3 registered aircraft · Registry code 9230013
- [Ultramagic S A M-105](https://openairdocs.org/model/ultramagic-s-a-m-105.md): 3 registered aircraft · Registry code 9129995
- [Ultramagic S A N-180](https://openairdocs.org/model/ultramagic-s-a-n-180.md): 3 registered aircraft · Registry code 9129996
- [Ultramagic T-150](https://openairdocs.org/model/ultramagic-t-150.md): 3 registered aircraft · Registry code 9130012
- [Ultramagic M-120](https://openairdocs.org/model/ultramagic-m-120.md): 2 registered aircraft · Registry code 9130015
- [Ultramagic M-145](https://openairdocs.org/model/ultramagic-m-145.md): 2 registered aircraft · Registry code 9130003
- [Ultramagic N355](https://openairdocs.org/model/ultramagic-n355.md): 2 registered aircraft · Registry code 9130022
- [Ultramagic S A N-500](https://openairdocs.org/model/ultramagic-s-a-n-500.md): 2 registered aircraft · Registry code 9130018
- [Ultramagic S A S-105](https://openairdocs.org/model/ultramagic-s-a-s-105.md): 2 registered aircraft · Registry code 9130010
- [Ultramagic S A S-90](https://openairdocs.org/model/ultramagic-s-a-s-90.md): 2 registered aircraft · Registry code 9130020
- [Ultramagic S A T-150](https://openairdocs.org/model/ultramagic-s-a-t-150.md): 2 registered aircraft · Registry code 9130024
- [Ultramagic M-65Z](https://openairdocs.org/model/ultramagic-m-65z.md): 1 registered aircraft · Registry code 9130023
- [Ultramagic M77C](https://openairdocs.org/model/ultramagic-m77c.md): 1 registered aircraft · Registry code 9130019
- [Ultramagic S A H-42](https://openairdocs.org/model/ultramagic-s-a-h-42.md): 1 registered aircraft · Registry code 9129950
- [Ultramagic S A V-90](https://openairdocs.org/model/ultramagic-s-a-v-90.md): 1 registered aircraft · Registry code 9130025
- [Ultramagic S-130](https://openairdocs.org/model/ultramagic-s-130.md): 1 registered aircraft · Registry code 9230017
- [Ultramagic S-70](https://openairdocs.org/model/ultramagic-s-70.md): 1 registered aircraft · Registry code 913009A
- [Ultramagic ULTRAMAGIC M-77C](https://openairdocs.org/model/ultramagic-ultramagic-m-77c.md): 1 registered aircraft · Registry code 9130021
- [Ultramagic ULTRAMAGIC S-130](https://openairdocs.org/model/ultramagic-ultramagic-s-130.md): 1 registered aircraft · Registry code 9230118
- [Raven S-50](https://openairdocs.org/model/raven-s-50.md): 0 registered aircraft · Registry code 7480202
- [Raven Vulcoon S-50](https://openairdocs.org/model/raven-vulcoon-s-50.md): 0 registered aircraft · Registry code 05604XT
- [Ultramagic F-18](https://openairdocs.org/model/ultramagic-f-18.md): 0 registered aircraft · Registry code 9130007

## 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 = 'B02CE')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

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