# Registered aircraft: TCDS B2EU

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

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

- [Thunder & Colt Airborne Amer AX8-90 S 2](https://openairdocs.org/model/thunder-colt-airborne-amer-ax8-90-s-2.md): 13 registered aircraft · Registry code 2301214
- [Thunder & Colt Balloons AX8-90 SERIES 2](https://openairdocs.org/model/thunder-colt-balloons-ax8-90-series-2.md): 5 registered aircraft · Registry code 2301204
- [Thunder Balloons AX8-90](https://openairdocs.org/model/thunder-balloons-ax8-90.md): 4 registered aircraft · Registry code 8970111
- [Thunder & Colt THUNDER AX7-77](https://openairdocs.org/model/thunder-colt-thunder-ax7-77.md): 3 registered aircraft · Registry code 8970121
- [Thunder & Colt THUNDER AX8-105](https://openairdocs.org/model/thunder-colt-thunder-ax8-105.md): 3 registered aircraft · Registry code 8970126
- [Thunder & Colt THUNDER AX8-90 S2](https://openairdocs.org/model/thunder-colt-thunder-ax8-90-s2.md): 3 registered aircraft · Registry code 8970129
- [Thunder Balloons AX7-77Z](https://openairdocs.org/model/thunder-balloons-ax7-77z.md): 3 registered aircraft · Registry code 8970110
- [Thunder & Colt Airborne Amer AX7-77 S1](https://openairdocs.org/model/thunder-colt-airborne-amer-ax7-77-s1.md): 2 registered aircraft · Registry code 2301211
- [Thunder & Colt THUNDER AX8-105 S1](https://openairdocs.org/model/thunder-colt-thunder-ax8-105-s1.md): 2 registered aircraft · Registry code 8970124
- [Thunder Balloons AX7-77A](https://openairdocs.org/model/thunder-balloons-ax7-77a.md): 2 registered aircraft · Registry code 8970108
- [Thunder Balloons AX9-140 SII](https://openairdocs.org/model/thunder-balloons-ax9-140-sii.md): 2 registered aircraft · Registry code 8970116
- [Thunder & Colt AX8-90 S2](https://openairdocs.org/model/thunder-colt-ax8-90-s2.md): 1 registered aircraft · Registry code 8970135
- [Thunder Balloons AX7-65](https://openairdocs.org/model/thunder-balloons-ax7-65.md): 1 registered aircraft · Registry code 8970105
- [Thunder & Colt Airborne Amer AX8-90](https://openairdocs.org/model/thunder-colt-airborne-amer-ax8-90.md): 0 registered aircraft · Registry code 2301215
- [Thunder & Colt AX7-65](https://openairdocs.org/model/thunder-colt-ax7-65.md): 0 registered aircraft · Registry code 8970200
- [Thunder & Colt THUNDER AX6-56](https://openairdocs.org/model/thunder-colt-thunder-ax6-56.md): 0 registered aircraft · Registry code 8970132
- [Thunder & Colt THUNDER AX7-77 S1](https://openairdocs.org/model/thunder-colt-thunder-ax7-77-s1.md): 0 registered aircraft · Registry code 8970123
- [Thunder & Colt THUNDER AX9-140 S2](https://openairdocs.org/model/thunder-colt-thunder-ax9-140-s2.md): 0 registered aircraft · Registry code 8970125
- [Thunder Balloons AX5-42](https://openairdocs.org/model/thunder-balloons-ax5-42.md): 0 registered aircraft · Registry code 8970100
- [Thunder Balloons AX6-56](https://openairdocs.org/model/thunder-balloons-ax6-56.md): 0 registered aircraft · Registry code 8970102
- [Thunder Balloons AX6-56A](https://openairdocs.org/model/thunder-balloons-ax6-56a.md): 0 registered aircraft · Registry code 8970104
- [Thunder Balloons AX6-56Z](https://openairdocs.org/model/thunder-balloons-ax6-56z.md): 0 registered aircraft · Registry code 8970103
- [Thunder Balloons AX7-65 BOLT](https://openairdocs.org/model/thunder-balloons-ax7-65-bolt.md): 0 registered aircraft · Registry code 8970106
- [Thunder Balloons AX7-65Z](https://openairdocs.org/model/thunder-balloons-ax7-65z.md): 0 registered aircraft · Registry code 8970120
- [Thunder Balloons AX7-77 BOLT](https://openairdocs.org/model/thunder-balloons-ax7-77-bolt.md): 0 registered aircraft · Registry code 8970109
- [Thunder Balloons AX9-140](https://openairdocs.org/model/thunder-balloons-ax9-140.md): 0 registered aircraft · Registry code 8970115

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

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