# Registered aircraft: Bumpass, VA

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

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

- [N12SE](https://openairdocs.org/aircraft/N12SE.md): Christen Industries CHRISTEN EAGLE-II SE · S/N 0001 · Built 1981 · Boyce Michael D II
- [N137PP](https://openairdocs.org/aircraft/N137PP.md): Buddy F Henson HENSON PANTHER · S/N P075 · Ervc Holdings LLC
- [N15079](https://openairdocs.org/aircraft/N15079.md): Piper PA-28-140 · S/N 28-7225585 · Built 1972 · Rea Robert III
- [N218PP](https://openairdocs.org/aircraft/N218PP.md): Cessna 172M · S/N 172-67520 · Built 1976 · Sumrell James E III
- [N2375Z](https://openairdocs.org/aircraft/N2375Z.md): Beech 23 · S/N M-99 · Built 1962 · Morrissett Jay Dean
- [N3175F](https://openairdocs.org/aircraft/N3175F.md): Cessna 182J · S/N 18257275 · Built 1966 · Estes Bernard R
- [N38TD](https://openairdocs.org/aircraft/N38TD.md): Cessna 150L · S/N 15073098 · Lewis Brian D
- [N42072](https://openairdocs.org/aircraft/N42072.md): Cessna 182L · S/N 18258844 · Built 1968 · Rempe Richard Henry
- [N4917G](https://openairdocs.org/aircraft/N4917G.md): Cessna 172N · S/N 17273464 · Built 1979 · Carter Richard W
- [N494JV](https://openairdocs.org/aircraft/N494JV.md): DJI AGRAS T40 · S/N 64TBL7D00200BR · Virginia Aerial Applicators LLC
- [N5935A](https://openairdocs.org/aircraft/N5935A.md): Cessna 172 · S/N 28535 · Built 1956 · Dunn James Blair Jr
- [N634DP](https://openairdocs.org/aircraft/N634DP.md): Prizio David P GLASTAR · S/N 5634 · Ervc Holdings LLC
- [N80303](https://openairdocs.org/aircraft/N80303.md): Mack Thomas V RANS S-7S COURIER · S/N 1003335S · Built 2004 · White David A
- [N8298Y](https://openairdocs.org/aircraft/N8298Y.md): Piper PA-30 · S/N 30-1437 · Built 1967 · Estes Bernard R
- [N888LW](https://openairdocs.org/aircraft/N888LW.md): Navion NAVION A · S/N NAV-4-1283 · Built 1948 · Schaffer Gary W
- [N93659](https://openairdocs.org/aircraft/N93659.md): Ercoupe 415-C · S/N 982 · Built 1946 · Morrissett Jay D
- [N9655J](https://openairdocs.org/aircraft/N9655J.md): Piper PA-28-180 · S/N 28-3822 · Built 1966 · Dunn James Blair Jr
- [N9FZ](https://openairdocs.org/aircraft/N9FZ.md): American Legend AL18 · S/N AL-1204 · Built 2015 · Fosdick William P

## 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 = 'BUMPASS'
ORDER BY g.n_number
```

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