# Registered aircraft: TCDS B3GL

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

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

- [Cameron Balloons Z-90](https://openairdocs.org/model/cameron-balloons-z-90.md): 69 registered aircraft · Registry code 1880300
- [Cameron Balloons US Z-105](https://openairdocs.org/model/cameron-balloons-us-z-105.md): 48 registered aircraft · Registry code 1880401
- [Cameron Balloons US Z-77](https://openairdocs.org/model/cameron-balloons-us-z-77.md): 47 registered aircraft · Registry code 1880302
- [Cameron Balloons US Z-90](https://openairdocs.org/model/cameron-balloons-us-z-90.md): 42 registered aircraft · Registry code 1880312
- [Cameron Balloons US ZL-70](https://openairdocs.org/model/cameron-balloons-us-zl-70.md): 16 registered aircraft · Registry code 1880370
- [Cameron Balloons US ZL-65](https://openairdocs.org/model/cameron-balloons-us-zl-65.md): 15 registered aircraft · Registry code 1880499
- [Cameron Balloons Z-70](https://openairdocs.org/model/cameron-balloons-z-70.md): 15 registered aircraft · Registry code 1880307
- [Cameron Balloons Z-120](https://openairdocs.org/model/cameron-balloons-z-120.md): 8 registered aircraft · Registry code 1880500
- [Cameron Balloons ZL-60](https://openairdocs.org/model/cameron-balloons-zl-60.md): 8 registered aircraft · Registry code 1880339
- [Cameron Balloons U S N 120](https://openairdocs.org/model/cameron-balloons-u-s-n-120.md): 5 registered aircraft · Registry code 1880228
- [Cameron Balloons US M-34](https://openairdocs.org/model/cameron-balloons-us-m-34.md): 5 registered aircraft · Registry code 1880400
- [Cameron Balloons ZL-77](https://openairdocs.org/model/cameron-balloons-zl-77.md): 5 registered aircraft · Registry code 1880455
- [Cameron Balloons ZL-84](https://openairdocs.org/model/cameron-balloons-zl-84.md): 5 registered aircraft · Registry code 1880450
- [Cameron Balloons US N-160](https://openairdocs.org/model/cameron-balloons-us-n-160.md): 4 registered aircraft · Registry code 1880245
- [Cameron Balloons US Z-160](https://openairdocs.org/model/cameron-balloons-us-z-160.md): 4 registered aircraft · Registry code 1880310
- [Cameron Balloons Z-133](https://openairdocs.org/model/cameron-balloons-z-133.md): 4 registered aircraft · Registry code 1880299
- [Cameron Balloons Z-65](https://openairdocs.org/model/cameron-balloons-z-65.md): 4 registered aircraft · Registry code 1880340
- [Cameron Balloons ZL-56](https://openairdocs.org/model/cameron-balloons-zl-56.md): 4 registered aircraft · Registry code 1880338
- [Cameron Balloons U S Z-60](https://openairdocs.org/model/cameron-balloons-u-s-z-60.md): 3 registered aircraft · Registry code 1880342
- [Cameron Balloons US Z-225](https://openairdocs.org/model/cameron-balloons-us-z-225.md): 3 registered aircraft · Registry code 1880329
- [Cameron Balloons US Z-42](https://openairdocs.org/model/cameron-balloons-us-z-42.md): 3 registered aircraft · Registry code 1880328
- [Cameron Balloons U S N-133](https://openairdocs.org/model/cameron-balloons-u-s-n-133.md): 2 registered aircraft · Registry code 1880227
- [Cameron Balloons US N-145](https://openairdocs.org/model/cameron-balloons-us-n-145.md): 2 registered aircraft · Registry code 1880230
- [Cameron Balloons US Z-120](https://openairdocs.org/model/cameron-balloons-us-z-120.md): 2 registered aircraft · Registry code 1880425
- [Cameron Balloons US Z-150](https://openairdocs.org/model/cameron-balloons-us-z-150.md): 2 registered aircraft · Registry code 1880308
- [Cameron Balloons US Z-250](https://openairdocs.org/model/cameron-balloons-us-z-250.md): 2 registered aircraft · Registry code 1880324
- [Cameron Balloons Z-140](https://openairdocs.org/model/cameron-balloons-z-140.md): 2 registered aircraft · Registry code 1880341
- [Cameron Balloons CHAMPAGNE-90](https://openairdocs.org/model/cameron-balloons-champagne-90.md): 1 registered aircraft · Registry code 1880292
- [Cameron Balloons SPHERE-90](https://openairdocs.org/model/cameron-balloons-sphere-90.md): 1 registered aircraft · Registry code 1880327
- [Cameron Balloons U S N-70](https://openairdocs.org/model/cameron-balloons-u-s-n-70.md): 1 registered aircraft · Registry code 1880330
- [Cameron Balloons US BOTTLE-105](https://openairdocs.org/model/cameron-balloons-us-bottle-105.md): 1 registered aircraft · Registry code 1880105
- [Cameron Balloons US MICKEY 90](https://openairdocs.org/model/cameron-balloons-us-mickey-90.md): 1 registered aircraft · Registry code 1880261
- [Cameron Balloons US SB-128](https://openairdocs.org/model/cameron-balloons-us-sb-128.md): 1 registered aircraft · Registry code 1880298
- [Cameron Balloons US Z-140](https://openairdocs.org/model/cameron-balloons-us-z-140.md): 1 registered aircraft · Registry code 1880305
- [Cameron Balloons US Z-180](https://openairdocs.org/model/cameron-balloons-us-z-180.md): 1 registered aircraft · Registry code 188031Z
- [Cameron Balloons US Z-210](https://openairdocs.org/model/cameron-balloons-us-z-210.md): 1 registered aircraft · Registry code 1880311
- [Cameron Balloons US Z-300](https://openairdocs.org/model/cameron-balloons-us-z-300.md): 1 registered aircraft · Registry code 1880343
- [Cameron Balloons Z-150](https://openairdocs.org/model/cameron-balloons-z-150.md): 1 registered aircraft · Registry code 1880434
- [Cameron Balloons JDCC-90](https://openairdocs.org/model/cameron-balloons-jdcc-90.md): 0 registered aircraft · Registry code 1880197
- [Cameron Balloons U S FIJI-105](https://openairdocs.org/model/cameron-balloons-u-s-fiji-105.md): 0 registered aircraft · Registry code 1880278
- [Cameron Balloons US DONALD-97](https://openairdocs.org/model/cameron-balloons-us-donald-97.md): 0 registered aircraft · Registry code 1880109
- [Cameron Balloons US MICKEY HAT 97](https://openairdocs.org/model/cameron-balloons-us-mickey-hat-97.md): 0 registered aircraft · Registry code 1880263
- [Cameron Balloons US N-210](https://openairdocs.org/model/cameron-balloons-us-n-210.md): 0 registered aircraft · Registry code 1880251
- [Cameron Balloons US N90S](https://openairdocs.org/model/cameron-balloons-us-n90s.md): 0 registered aircraft · Registry code 1880266
- [Cameron Balloons US PENGUIN-90](https://openairdocs.org/model/cameron-balloons-us-penguin-90.md): 0 registered aircraft · Registry code 1880267
- [Cameron Balloons US STAGECOACH-110](https://openairdocs.org/model/cameron-balloons-us-stagecoach-110.md): 0 registered aircraft · Registry code 1880325
- [Cameron Balloons US TANK-77](https://openairdocs.org/model/cameron-balloons-us-tank-77.md): 0 registered aircraft · Registry code 1880288
- [Cameron Balloons US Z-84](https://openairdocs.org/model/cameron-balloons-us-z-84.md): 0 registered aircraft · Registry code 1880309

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

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