# Registered aircraft: Bristol, VA

A list on [Bristol, VA](https://openairdocs.org/faa-place/VA/Bristol.md).

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N132KM](https://openairdocs.org/aircraft/N132KM.md): Piper PA-32-300 · S/N 32-7940161 · King General Contractors Inc
- [N17UC](https://openairdocs.org/aircraft/N17UC.md): Bombardier BD-100-1A10 · S/N 20345 · Built 2011 · United Company
- [N21UC](https://openairdocs.org/aircraft/N21UC.md): Gulfstream Aerospace GV-SP (G550) · S/N 5484 · Built 2014 · United Co
- [N226SW](https://openairdocs.org/aircraft/N226SW.md): Textron 560XL · S/N 560-6306 · Built 2021 · Nicklaus LLC
- [N2481X](https://openairdocs.org/aircraft/N2481X.md): Buckeye DREAM MACHINE 582 · S/N 4425 · Built 1998 · Cross Gary D
- [N3564F](https://openairdocs.org/aircraft/N3564F.md): Kolb FIRESTAR · S/N KF11739 · Built 1991 · Plamieri Terry M
- [N4570](https://openairdocs.org/aircraft/N4570.md): Allen Earl L TITAN-T51 · S/N MO4XXXS0HK0042 · Goodson Danny
- [N53RE](https://openairdocs.org/aircraft/N53RE.md): Textron 525C · S/N 525C0427 · Built 2023 · Nuco Gen2 LLC
- [N5NG](https://openairdocs.org/aircraft/N5NG.md): Embraer Executive EMB-505 · S/N 50500946 · Built 2026 · Papa Don Aviation LLC
- [N6022R](https://openairdocs.org/aircraft/N6022R.md): Cessna 172G · S/N 17253691 · Built 1965 · Cunningham Gene Jr
- [N675RF](https://openairdocs.org/aircraft/N675RF.md): Rodney F Foutch VANS RV6-A · S/N 21845 · Built 2021 · Goodson Danny R
- [N6919G](https://openairdocs.org/aircraft/N6919G.md): Cessna 150L · S/N 15072419 · Built 1970 · Seats Frank R
- [N743KS](https://openairdocs.org/aircraft/N743KS.md): Cessna 180J · S/N 18052710 · Built 1976 · Barrett Buford L
- [N785CB](https://openairdocs.org/aircraft/N785CB.md): Bell 206B · S/N 4051 · Built 1989 · Advanced Aerial Services Inc
- [N87SJ](https://openairdocs.org/aircraft/N87SJ.md): Bell Helicopter Textron Canada 429 · S/N 57023 · Built 2010 · Air Biggie LLC
- [N929DJ](https://openairdocs.org/aircraft/N929DJ.md): Piper PA-32R-301T · S/N 3257344 · Built 2004 · A And S Flying Services Inc
- [N970XX](https://openairdocs.org/aircraft/N970XX.md): Korean Air 500MD · S/N 80-0136 · Advance Land Management And Tree Removal Inc
- [N9995R](https://openairdocs.org/aircraft/N9995R.md): Beech B95A · S/N TD-465 · Built 1961 · Big Sky Navigation & Flight Training LLC

## The whole list in SQL

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

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'VA' AND g.registrant_city = 'BRISTOL'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/VA/Bristol/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.
