# Registered aircraft: TCDS A-2-571

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

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

- [Consolidated Vultee BT-13A](https://openairdocs.org/model/consolidated-vultee-bt-13a.md): 56 registered aircraft · Registry code 2420224
- [Consolidated Vultee BT-13B (SNV-2)](https://openairdocs.org/model/consolidated-vultee-bt-13b-snv-2.md): 11 registered aircraft · Registry code 2420228
- [Convair BT-13A](https://openairdocs.org/model/convair-bt-13a.md): 11 registered aircraft · Registry code 2420204
- [Consolidated Vultee BT-15](https://openairdocs.org/model/consolidated-vultee-bt-15.md): 8 registered aircraft · Registry code 2420312
- [Consolidated Vultee BT-13](https://openairdocs.org/model/consolidated-vultee-bt-13.md): 7 registered aircraft · Registry code 2420222
- [Convair BT-15](https://openairdocs.org/model/convair-bt-15.md): 4 registered aircraft · Registry code 2420302
- [Convair BT-13](https://openairdocs.org/model/convair-bt-13.md): 3 registered aircraft · Registry code 2420202
- [Convair BT-13B](https://openairdocs.org/model/convair-bt-13b.md): 3 registered aircraft · Registry code 2420208
- [Cons Vultee/Basinger BT-13A](https://openairdocs.org/model/cons-vultee-basinger-bt-13a.md): 1 registered aircraft · Registry code 2420225
- [Cons Vultee/Lacey BT-13B](https://openairdocs.org/model/cons-vultee-lacey-bt-13b.md): 1 registered aircraft · Registry code 2420229
- [Cons Vultee/Pittman BT13](https://openairdocs.org/model/cons-vultee-pittman-bt13.md): 1 registered aircraft · Registry code 2420220
- [Consolidated Vultee/Gunderson BT-13A](https://openairdocs.org/model/consolidated-vultee-gunderson-bt-13a.md): 1 registered aircraft · Registry code 2420221
- [Consolidated Vultee/Vanech BT-13A](https://openairdocs.org/model/consolidated-vultee-vanech-bt-13a.md): 1 registered aircraft · Registry code 2420223
- [Consolidated/Nocco C VULTEE BT-13](https://openairdocs.org/model/consolidated-nocco-c-vultee-bt-13.md): 1 registered aircraft · Registry code 2420201
- [Vultee/Reed Ron BT-13A](https://openairdocs.org/model/vultee-reed-ron-bt-13a.md): 1 registered aircraft · Registry code 2421705
- [Consolidated Vultee BT-13B](https://openairdocs.org/model/consolidated-vultee-bt-13b.md): 0 registered aircraft · Registry code 2420231
- [Consolidated/Diaz Mark A BT-13A](https://openairdocs.org/model/consolidated-diaz-mark-a-bt-13a.md): 0 registered aircraft · Registry code 2420227
- [Vultee BT-13](https://openairdocs.org/model/vultee-bt-13.md): 0 registered aircraft · Registry code 2421704
- [Vultee BT-13B](https://openairdocs.org/model/vultee-bt-13b.md): 0 registered aircraft · Registry code 2421706

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

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