# Registered aircraft: Haymarket, VA

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

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

- [N1479C](https://openairdocs.org/aircraft/N1479C.md): Cessna 177B · S/N 17702735 · Built 1977 · Built Aviation LLC
- [N176DC](https://openairdocs.org/aircraft/N176DC.md): S N I A S SE 3130 ALOUETTE II · S/N 1719 · Cyclone Aviation LLC
- [N176LL](https://openairdocs.org/aircraft/N176LL.md): Cessna 210L · S/N 21061135 · Built 1975 · Clear Above LLC
- [N1YM](https://openairdocs.org/aircraft/N1YM.md): Beech 35 · S/N D-1145 · Supreme Aeronautics LLC
- [N281R](https://openairdocs.org/aircraft/N281R.md): Beech 95-B55 · S/N TC-757 · Built 1964 · Walker Lawrence J
- [N31VX](https://openairdocs.org/aircraft/N31VX.md): Lional Ray Ward WARD F-4 ROCKET · S/N 00182 · Built 2018 · Gordon Charles M Trustee
- [N381F](https://openairdocs.org/aircraft/N381F.md): Diamond Aircraft Ind DA20-C1 · S/N C0322 · Magrahen Air LLC
- [N40CR](https://openairdocs.org/aircraft/N40CR.md): Robin Eodice GLASAIR II FT SH-2F · S/N 1003 · Built 2015 · Moyer Gregg A
- [N425KS](https://openairdocs.org/aircraft/N425KS.md): Cessna 425 · S/N 425-0102 · Built 1981 · Swja LLC
- [N446AS](https://openairdocs.org/aircraft/N446AS.md): Piper PA-32R-300 · S/N 32R-7780464 · First renewal notice · Built 1977 · Freeman Tim B
- [N458MA](https://openairdocs.org/aircraft/N458MA.md): Diamond Aircraft Ind DA20-C1 · S/N C0340 · Built 2005 · Magrahen Air LLC
- [N477GY](https://openairdocs.org/aircraft/N477GY.md): Textron 182T · S/N 18283265 · Built 2024 · Golf Yankee LLC
- [N551TX](https://openairdocs.org/aircraft/N551TX.md): Entenmann William G MUSTANG II · S/N MII1984 · Built 2000 · Carrozza Louis R
- [N601XZ](https://openairdocs.org/aircraft/N601XZ.md): Coberly David M ZODIAC 601XL · S/N 6-7016 · Built 2009 · Mcintire John R
- [N6112E](https://openairdocs.org/aircraft/N6112E.md): Cessna 172 · S/N 46212 · Built 1958 · Mcintire John R
- [N6382S](https://openairdocs.org/aircraft/N6382S.md): Cessna TR182 · S/N R18201668 · Built 1980 · Nichols Daniel Alan
- [N699PF](https://openairdocs.org/aircraft/N699PF.md): Cirrus Design SR22T · S/N 9212 · Built 2023 · N699pf LLC
- [N7307S](https://openairdocs.org/aircraft/N7307S.md): Cessna 182P · S/N 18265100 · Built 1976 · Dunlap Michael L
- [N7392P](https://openairdocs.org/aircraft/N7392P.md): Piper PA-24-250 · S/N 24-2576 · Built 1961 · Gray Matthew R
- [N8308C](https://openairdocs.org/aircraft/N8308C.md): Piper PA-28-181 · S/N 28-7690113 · Built 1975 · N8308c LLC
- [N856ST](https://openairdocs.org/aircraft/N856ST.md): Pilatus PC-12/47E · S/N 1256 · Built 2010 · K&B Aviation 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 = 'HAYMARKET'
ORDER BY g.n_number
```

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