# Earlier aircraft under this name: Vintage War Birds LLC

A list on [Vintage War Birds LLC](https://openairdocs.org/faa-owner/VINTAGE%20WAR%20BIRDS%20LLC.md).

Cancelled registrations that named this owner when they ended, newest first.

- [N20681](https://openairdocs.org/deregistered/N20681-2021-10-30.md): North American T-28B · S/N 54-137700 · Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Stepvensville, MT
- [N823VW](https://openairdocs.org/deregistered/N823VW-2019-09-06.md): North American T-28B · S/N 137727 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N824VW](https://openairdocs.org/deregistered/N824VW-2019-09-06.md): North American T-28C · S/N 140657 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N825VW](https://openairdocs.org/deregistered/N825VW-2019-09-06.md): North American T-28B · S/N 137649 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N826VW](https://openairdocs.org/deregistered/N826VW-2019-09-06.md): North American T-28B · S/N 137724 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N827VW](https://openairdocs.org/deregistered/N827VW-2019-09-06.md): North American T-28B · S/N 137778 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N828VW](https://openairdocs.org/deregistered/N828VW-2019-09-06.md): North American T-28B · S/N 138134 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N829VW](https://openairdocs.org/deregistered/N829VW-2019-09-06.md): North American T-28B · S/N 138176 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N831VW](https://openairdocs.org/deregistered/N831VW-2019-09-06.md): North American T-28C · S/N 140069 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N832VW](https://openairdocs.org/deregistered/N832VW-2019-09-06.md): North American T-28C · S/N 140074 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N833VW](https://openairdocs.org/deregistered/N833VW-2019-09-06.md): North American T-28B · S/N 137707 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N834VW](https://openairdocs.org/deregistered/N834VW-2019-09-06.md): North American T-28C · S/N 140462 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N835VW](https://openairdocs.org/deregistered/N835VW-2019-09-06.md): North American T-28C · S/N 140465 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N836VW](https://openairdocs.org/deregistered/N836VW-2019-09-06.md): North American T-28C · S/N 140534 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N837VW](https://openairdocs.org/deregistered/N837VW-2019-09-06.md): North American T-28C · S/N 140544 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N838VW](https://openairdocs.org/deregistered/N838VW-2019-09-06.md): North American T-28C · S/N 140552 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N839VW](https://openairdocs.org/deregistered/N839VW-2019-09-06.md): North American T-28C · S/N 140608 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT
- [N840VW](https://openairdocs.org/deregistered/N840VW-2019-09-06.md): North American T-28C · S/N 140626 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stevensville, MT

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_name = 'VINTAGE WAR BIRDS LLC' OR list_contains(d.other_registrant_names, 'VINTAGE WAR BIRDS LLC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/VINTAGE%20WAR%20BIRDS%20LLC/earlier

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
