# Registered aircraft: TCDS B2GL

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

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

- [Cameron Balloons US A-120](https://openairdocs.org/model/cameron-balloons-us-a-120.md): 21 registered aircraft · Registry code 1880213
- [Cameron Balloons US A-275](https://openairdocs.org/model/cameron-balloons-us-a-275.md): 20 registered aircraft · Registry code 1880445
- [Cameron Balloons US A-180](https://openairdocs.org/model/cameron-balloons-us-a-180.md): 13 registered aircraft · Registry code 1880233
- [Cameron Balloons US A-160](https://openairdocs.org/model/cameron-balloons-us-a-160.md): 10 registered aircraft · Registry code 1880296
- [Cameron Balloons US A-225](https://openairdocs.org/model/cameron-balloons-us-a-225.md): 9 registered aircraft · Registry code 1880232
- [Cameron Balloons US A-400](https://openairdocs.org/model/cameron-balloons-us-a-400.md): 7 registered aircraft · Registry code 1880117
- [Cameron Balloons U S A-375](https://openairdocs.org/model/cameron-balloons-u-s-a-375.md): 3 registered aircraft · Registry code 1880198
- [Cameron Balloons US A-340](https://openairdocs.org/model/cameron-balloons-us-a-340.md): 3 registered aircraft · Registry code 1880055
- [Cameron Balloons KIWI-90](https://openairdocs.org/model/cameron-balloons-kiwi-90.md): 1 registered aircraft · Registry code 1880304
- [Cameron Balloons MR POTATO HEAD-90](https://openairdocs.org/model/cameron-balloons-mr-potato-head-90.md): 1 registered aircraft · Registry code 1880196
- [Cameron Balloons U S A-190](https://openairdocs.org/model/cameron-balloons-u-s-a-190.md): 1 registered aircraft · Registry code 1880237
- [Cameron Balloons U S A-77](https://openairdocs.org/model/cameron-balloons-u-s-a-77.md): 1 registered aircraft · Registry code 1880403
- [Cameron Balloons US KONG-120](https://openairdocs.org/model/cameron-balloons-us-kong-120.md): 1 registered aircraft · Registry code 1880257
- [Cameron Balloons A-275](https://openairdocs.org/model/cameron-balloons-a-275.md): 0 registered aircraft · Registry code 1880444
- [Cameron Balloons US CONE-105](https://openairdocs.org/model/cameron-balloons-us-cone-105.md): 0 registered aircraft · Registry code 1880303
- [Cameron Balloons US FLAME-90](https://openairdocs.org/model/cameron-balloons-us-flame-90.md): 0 registered aircraft · Registry code 1880259
- [Cameron Balloons US HEAD-90](https://openairdocs.org/model/cameron-balloons-us-head-90.md): 0 registered aircraft · Registry code 1880103

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

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