# Registered aircraft: TCDS B1GL

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

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

- [Cameron Balloons US C-80](https://openairdocs.org/model/cameron-balloons-us-c-80.md): 41 registered aircraft · Registry code 1880224
- [Cameron Balloons US O-90](https://openairdocs.org/model/cameron-balloons-us-o-90.md): 26 registered aircraft · Registry code 1880271
- [Cameron Balloons US C-100](https://openairdocs.org/model/cameron-balloons-us-c-100.md): 13 registered aircraft · Registry code 1880226
- [Cameron Balloons US C-60](https://openairdocs.org/model/cameron-balloons-us-c-60.md): 5 registered aircraft · Registry code 1880223
- [Cameron Balloons US O-120](https://openairdocs.org/model/cameron-balloons-us-o-120.md): 5 registered aircraft · Registry code 1880306
- [Cameron Balloons O-140](https://openairdocs.org/model/cameron-balloons-o-140.md): 2 registered aircraft · Registry code 1880414
- [Cameron Balloons US EAGLE-110](https://openairdocs.org/model/cameron-balloons-us-eagle-110.md): 1 registered aircraft · Registry code 1880274
- [Cameron Balloons US SHOE 90](https://openairdocs.org/model/cameron-balloons-us-shoe-90.md): 1 registered aircraft · Registry code 1880269
- [Cameron Balloons US ZOZOBRA-110](https://openairdocs.org/model/cameron-balloons-us-zozobra-110.md): 1 registered aircraft · Registry code 1880398
- [Cameron Balloons CAN-56](https://openairdocs.org/model/cameron-balloons-can-56.md): 0 registered aircraft · Registry code 1880203
- [Cameron Balloons CUERVO-110](https://openairdocs.org/model/cameron-balloons-cuervo-110.md): 0 registered aircraft · Registry code 1880209
- [Cameron Balloons MONITOR-105](https://openairdocs.org/model/cameron-balloons-monitor-105.md): 0 registered aircraft · Registry code 1880195
- [Cameron Balloons TIRE-100](https://openairdocs.org/model/cameron-balloons-tire-100.md): 0 registered aircraft · Registry code 1880295
- [Cameron Balloons U S BATTERY 90](https://openairdocs.org/model/cameron-balloons-u-s-battery-90.md): 0 registered aircraft · Registry code 1880264
- [Cameron Balloons U S MONITOR-80](https://openairdocs.org/model/cameron-balloons-u-s-monitor-80.md): 0 registered aircraft · Registry code 1880229
- [Cameron Balloons US BURGER-65](https://openairdocs.org/model/cameron-balloons-us-burger-65.md): 0 registered aircraft · Registry code 1880123
- [Cameron Balloons US CAN-56](https://openairdocs.org/model/cameron-balloons-us-can-56.md): 0 registered aircraft · Registry code 1880218
- [Cameron Balloons US PIGGY BANK-90](https://openairdocs.org/model/cameron-balloons-us-piggy-bank-90.md): 0 registered aircraft · Registry code 1880270

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

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