# Registered aircraft: Mechanicsville, VA

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

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

- [N153VR](https://openairdocs.org/aircraft/N153VR.md): Vashon RANGER R7 · S/N 10147 · Built 2019 · Spencer K Revenson
- [N17827](https://openairdocs.org/aircraft/N17827.md): Beech V35B · S/N D-10015 · Built 1977 · Cumins Douglas
- [N201FL](https://openairdocs.org/aircraft/N201FL.md): Mooney M20J · S/N 24-0154 · First renewal notice · Built 1977 · Fairservice John G Jr
- [N21953](https://openairdocs.org/aircraft/N21953.md): Firefly Balloons FIREFLY 7 · S/N F7-2024 · Built 2003 · Snead David W
- [N2246H](https://openairdocs.org/aircraft/N2246H.md): Cirrus Design SR22 · S/N 4127 · Built 2014 · Hanover Flying Club LLC
- [N23AW](https://openairdocs.org/aircraft/N23AW.md): Ward ANN C KITFOX 6 · S/N 4 · Built 2002 · Stell Brandon A
- [N28455](https://openairdocs.org/aircraft/N28455.md): Grumman American Avn. AA-5B · S/N AA5B0619 · Built 1977 · Souleret George R
- [N3287E](https://openairdocs.org/aircraft/N3287E.md): Cessna 172N · S/N 17271492 · Built 1978 · Off Course Aero Ventures LLC
- [N32932](https://openairdocs.org/aircraft/N32932.md): Piper PA-28-151 · S/N 28-7515276 · Built 1974 · Gilbert Roy S
- [N343R](https://openairdocs.org/aircraft/N343R.md): Air Fly Balonismo E Inflaveis AF-SS-85 · S/N LP2023-03 · Built 2023 · Rosenbaum Henry D
- [N34ST](https://openairdocs.org/aircraft/N34ST.md): Cessna 510 · S/N 510-0205 · Built 2009 · Iconic Aviation LLC
- [N3689E](https://openairdocs.org/aircraft/N3689E.md): Aeronca 7BCM · S/N 7AC-6995 · Registration pending · Built 1947
- [N3917M](https://openairdocs.org/aircraft/N3917M.md): Piper PA-28-181 · S/N 28-7890339 · Built 1978 · Wells Brandon A
- [N3972L](https://openairdocs.org/aircraft/N3972L.md): Cessna 172G · S/N 17254141 · Built 1966 · Berg Brian R
- [N3972Q](https://openairdocs.org/aircraft/N3972Q.md): Cessna 172L · S/N 17260072 · Built 1971 · Stiles Thomas
- [N411VA](https://openairdocs.org/aircraft/N411VA.md): Lindstrand Balloons 77A · S/N 5045 · Built 1997 · Rosenbaum Henry D
- [N444VA](https://openairdocs.org/aircraft/N444VA.md): Lindstrand Balloons 77A · S/N 5106 · Balloons Over Virginia Inc
- [N44KL](https://openairdocs.org/aircraft/N44KL.md): Linch Kenneth T RV-4 · S/N 803 · Stell Brandon A
- [N485SY](https://openairdocs.org/aircraft/N485SY.md): Todd N Young VANS AIRCRAFT RV9 · S/N 90820 · Young Todd N
- [N54452](https://openairdocs.org/aircraft/N54452.md): Cessna 172P · S/N 17274977 · Built 1981 · Epling Kenny B
- [N60788](https://openairdocs.org/aircraft/N60788.md): Eagle Balloons C-7 · S/N E82736 · Built 1982 · Bivens Eric P
- [N60ZR](https://openairdocs.org/aircraft/N60ZR.md): Arbc Inc DBA Lindstrand 60X · S/N 5401 · Built 2008 · Rosenbaum Henry D
- [N6102M](https://openairdocs.org/aircraft/N6102M.md): Universal Stinson 108-3 · S/N 108-4102 · Built 1947 · Crenshaw Dennis A
- [N6138V](https://openairdocs.org/aircraft/N6138V.md): Piper PA-28-140 · S/N 28-23988 · Built 1968 · Glover Michael M
- [N713EC](https://openairdocs.org/aircraft/N713EC.md): Piper PA-23-250 · S/N 27-7554151 · Built 1975 · Charlie Tango LLC
- [N730J](https://openairdocs.org/aircraft/N730J.md): Jabiru USA Sport J230-SP · S/N 679 · Built 2010 · Jb & H Aviation LLC
- [N75366](https://openairdocs.org/aircraft/N75366.md): Piper J3C-65 · S/N 8538 · Van Ess Christopher G
- [N77341](https://openairdocs.org/aircraft/N77341.md): Cessna 140 · S/N 11782 · Built 1946 · Monti Marco G
- [N78626](https://openairdocs.org/aircraft/N78626.md): Cessna 172K · S/N 17257693 · Built 1968 · Ycm Solutions Inc
- [N8047B](https://openairdocs.org/aircraft/N8047B.md): Cessna 172 · S/N 29847 · Built 1957 · Guidry Janice C
- [N820](https://openairdocs.org/aircraft/N820.md): Cirrus Design SR22 · S/N 3305 · Built 2008 · Ames Air LLC
- [N826DZ](https://openairdocs.org/aircraft/N826DZ.md): Cirrus Design SR22 · S/N 4750 · Built 2019 · Deka LLC
- [N8516W](https://openairdocs.org/aircraft/N8516W.md): Piper PA-28-235 · S/N 28-10017 · Wings Level Flying Club
- [N877SR](https://openairdocs.org/aircraft/N877SR.md): Redding Steve F RIHN ACFT DR-109 · S/N SFR-1 · Built 2008 · Stiff Charles L
- [N88501](https://openairdocs.org/aircraft/N88501.md): Piper J3C-65 · S/N 16125 · Built 1946 · Cumins Douglas J
- [N915ZA](https://openairdocs.org/aircraft/N915ZA.md): Rotorx PALLEDRONE RX · S/N 00001 · Rotorx LLC
- [N91CS](https://openairdocs.org/aircraft/N91CS.md): Textron T206H · S/N T20609755 · Built 2023 · Skye Furniture Inc T/A Sky Aviation
- [N9353P](https://openairdocs.org/aircraft/N9353P.md): Piper PA-24-260 · S/N 24-4854 · Built 1969 · Smith Evan B
- [N9663U](https://openairdocs.org/aircraft/N9663U.md): Grumman American Avn. AA-5A · S/N AA5A-0029 · Built 1975 · Maxfield Ronald

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

This list as a web page: https://openairdocs.org/faa-place/VA/Mechanicsville/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
