# Registered aircraft: Venice, CA

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

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

- [N20188](https://openairdocs.org/aircraft/N20188.md): Cessna 172C · S/N 17248948 · Built 1961 · Creamer Rodger R
- [N245WP](https://openairdocs.org/aircraft/N245WP.md): Cirrus Design SR22 · S/N 4840 · Built 2019 · Eberhard Air LLC
- [N3031F](https://openairdocs.org/aircraft/N3031F.md): Cessna 182J · S/N 18257131 · Built 1966 · Alderson John M
- [N315HP](https://openairdocs.org/aircraft/N315HP.md): Cirrus Design SR22T · S/N 1014 · N315hp LLC
- [N316DB](https://openairdocs.org/aircraft/N316DB.md): Shane Douglas B SHANE RUNABOUT · S/N 869 · Built 1988 · Shane Douglas B
- [N345B](https://openairdocs.org/aircraft/N345B.md): Cessna 172S · S/N 172S8177 · Built 1999 · Peraton Services LLC
- [N500GP](https://openairdocs.org/aircraft/N500GP.md): Cessna 172R · S/N 17280500 · Built 1998 · Ehg Flight LLC
- [N6153M](https://openairdocs.org/aircraft/N6153M.md): Stinson 108-3 · S/N 108-4153 · Built 1948 · Shane Douglas B
- [N745B](https://openairdocs.org/aircraft/N745B.md): Cessna 172S · S/N 172S10863 · Built 2008 · Planelease LLC
- [N75013](https://openairdocs.org/aircraft/N75013.md): Cessna 172N · S/N 17272705 · Frank Technologies Inc
- [N767ER](https://openairdocs.org/aircraft/N767ER.md): Robinson Helicopter R22 BETA · S/N 3956 · Built 2005 · Jet Stream Jockey LLC
- [N8213T](https://openairdocs.org/aircraft/N8213T.md): Cessna 175B · S/N 17556913 · Built 1960 · Mortenson Jay E
- [N824KS](https://openairdocs.org/aircraft/N824KS.md): Cessna 172R · S/N 17280564 · Built 1999 · Planelease LLC
- [N825KS](https://openairdocs.org/aircraft/N825KS.md): Cessna 172R · S/N 17280791 · Built 1999 · Planelease LLC
- [N826KS](https://openairdocs.org/aircraft/N826KS.md): Cessna 172R · S/N 17280792 · Built 1999 · Planelease LLC
- [N827KS](https://openairdocs.org/aircraft/N827KS.md): Cessna 172R · S/N 17280793 · Built 1999 · Planelease LLC
- [N9045B](https://openairdocs.org/aircraft/N9045B.md): Cessna 172S · S/N 172S11057 · Built 2010 · Ehg Flight LLC
- [N957RS](https://openairdocs.org/aircraft/N957RS.md): Statham James R RV-7 · S/N 72989 · Built 2008 · Biltz Jesse

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

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