# Registered aircraft: Bayfield, CO

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

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

- [N1027X](https://openairdocs.org/aircraft/N1027X.md): Cessna 180 · S/N 31205 · Built 1954 · Harper Shawn
- [N1871T](https://openairdocs.org/aircraft/N1871T.md): Piper PA-28-140 · S/N 28-7225021 · Bynum Jeffery A
- [N2575P](https://openairdocs.org/aircraft/N2575P.md): Balloon Works FIREFLY 8B-15 · S/N F8B-436 · Campbell Philip L
- [N2ZF](https://openairdocs.org/aircraft/N2ZF.md): Aviat S-2C · S/N 6040 · Built 2000 · Split S LLC
- [N3493A](https://openairdocs.org/aircraft/N3493A.md): Beech E33 · S/N CD-1234 · Built 1969 · Papago Equipment LLC
- [N356A](https://openairdocs.org/aircraft/N356A.md): Holtzman Arthur J SONEX - 03 · S/N 356 · Brooks Bill D
- [N3886D](https://openairdocs.org/aircraft/N3886D.md): Cessna 182A · S/N 34586 · Built 1957 · Harper Shawn W
- [N4649B](https://openairdocs.org/aircraft/N4649B.md): Cessna 180 · S/N 31547 · Built 1955 · Nicholson Stephen G
- [N512PL](https://openairdocs.org/aircraft/N512PL.md): Cubcrafters CC11-160 · S/N CC11-00182 · Built 2011 · Longfellow Ellis A
- [N56180](https://openairdocs.org/aircraft/N56180.md): Cessna 180 · S/N 32165 · Built 1955 · Gosney Don L
- [N64199](https://openairdocs.org/aircraft/N64199.md): Cessna 172M · S/N 17265081 · Built 1975 · Mutschler George Robert Jr
- [N711G](https://openairdocs.org/aircraft/N711G.md): Smith BIPLANE · S/N 5822-40 · Built 1968 · Johnson Harold V
- [N733ZS](https://openairdocs.org/aircraft/N733ZS.md): Cessna 172N · S/N 17268684 · Built 1977 · Mccown Jamey
- [N81E](https://openairdocs.org/aircraft/N81E.md): Stinson SR-8B · S/N 9815 · Built 1937 · Lunsford David R
- [N8822T](https://openairdocs.org/aircraft/N8822T.md): Cessna 182C · S/N 52722 · Built 1960 · Morris Joshua
- [N89673](https://openairdocs.org/aircraft/N89673.md): Cessna 140 · S/N 8721 · Built 1946 · Jensen Jake J

## 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 = 'CO' AND g.registrant_city = 'BAYFIELD'
ORDER BY g.n_number
```

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