# Registered aircraft: TCDS B00010CH

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

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

- [Arbc Inc DBA Lindstrand 77X](https://openairdocs.org/model/arbc-inc-dba-lindstrand-77x.md): 38 registered aircraft · Registry code 5190026
- [Arbc Inc DBA Lindstrand 60X](https://openairdocs.org/model/arbc-inc-dba-lindstrand-60x.md): 34 registered aircraft · Registry code 5190021
- [Lindstrand Balloons 60X](https://openairdocs.org/model/lindstrand-balloons-60x.md): 14 registered aircraft · Registry code 5180017
- [Arbc Inc DBA Lindstrand 69X](https://openairdocs.org/model/arbc-inc-dba-lindstrand-69x.md): 13 registered aircraft · Registry code 5190022
- [Arbc Inc DBA Lindstrand 65X](https://openairdocs.org/model/arbc-inc-dba-lindstrand-65x.md): 12 registered aircraft · Registry code 5190028
- [Lindstrand Balloons 56X](https://openairdocs.org/model/lindstrand-balloons-56x.md): 8 registered aircraft · Registry code 5180032
- [Arbc Inc DBA Lindstrand 160A](https://openairdocs.org/model/arbc-inc-dba-lindstrand-160a.md): 7 registered aircraft · Registry code 5190025
- [Arbc Inc DBA Lindstrand 56X](https://openairdocs.org/model/arbc-inc-dba-lindstrand-56x.md): 6 registered aircraft · Registry code 5190024
- [Arbc Inc DBA Lindstrand 140A](https://openairdocs.org/model/arbc-inc-dba-lindstrand-140a.md): 3 registered aircraft · Registry code 5190027
- [Arbc Inc DBA Lindstrand 180A](https://openairdocs.org/model/arbc-inc-dba-lindstrand-180a.md): 3 registered aircraft · Registry code 5190010
- [Arbc Inc DBA Lindstrand 90E](https://openairdocs.org/model/arbc-inc-dba-lindstrand-90e.md): 3 registered aircraft · Registry code 5190030
- [Lindstrand Balloons 69X](https://openairdocs.org/model/lindstrand-balloons-69x.md): 3 registered aircraft · Registry code 5180013
- [A R B C Inc DBA Lindstrand 62X](https://openairdocs.org/model/a-r-b-c-inc-dba-lindstrand-62x.md): 2 registered aircraft · Registry code 5190037
- [Arbc Inc DBA Lindstrand 100E](https://openairdocs.org/model/arbc-inc-dba-lindstrand-100e.md): 2 registered aircraft · Registry code 5190042
- [Arbc Inc DBA Lindstrand 70E](https://openairdocs.org/model/arbc-inc-dba-lindstrand-70e.md): 2 registered aircraft · Registry code 5190003
- [Arbc Inc DBA Lindstrand 80E](https://openairdocs.org/model/arbc-inc-dba-lindstrand-80e.md): 2 registered aircraft · Registry code 5190031
- [Thunder & Colt Balloons 160A](https://openairdocs.org/model/thunder-colt-balloons-160a.md): 2 registered aircraft · Registry code 2301200
- [Arbc Inc DBA Lindstrand 150A](https://openairdocs.org/model/arbc-inc-dba-lindstrand-150a.md): 1 registered aircraft · Registry code 5190033
- [Arbc Inc DBA Lindstrand 317A](https://openairdocs.org/model/arbc-inc-dba-lindstrand-317a.md): 1 registered aircraft · Registry code 5190035
- [Arbc Inc DBA Lindstrand SPHERE-105](https://openairdocs.org/model/arbc-inc-dba-lindstrand-sphere-105.md): 1 registered aircraft · Registry code 5190020
- [Colt Balloons 160A](https://openairdocs.org/model/colt-balloons-160a.md): 1 registered aircraft · Registry code 2300160
- [Lindstrand Balloons 210S](https://openairdocs.org/model/lindstrand-balloons-210s.md): 1 registered aircraft · Registry code 5180030
- [Lindstrand Balloons LBL BOX](https://openairdocs.org/model/lindstrand-balloons-lbl-box.md): 0 registered aircraft · Registry code 5180034

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

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