# Registered aircraft: Saint Johns, FL

A list on [Saint Johns, FL](https://openairdocs.org/faa-place/FL/Saint%20Johns.md).

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

- [N1086V](https://openairdocs.org/aircraft/N1086V.md): Cessna R172K · S/N R1722111 · Built 1976 · Kinney Philip S
- [N13MJ](https://openairdocs.org/aircraft/N13MJ.md): Varnum Frank VANS RV-4 · S/N 2537 · Built 2007 · Vanderbilt Carl D
- [N145MS](https://openairdocs.org/aircraft/N145MS.md): Jonker Sailplanes JS3 RES · S/N 03-145 · Built 2023 · Clark Harold R
- [N14705](https://openairdocs.org/aircraft/N14705.md): Bellanca 17-30A · S/N 74-30668 · Built 1974 · Bernath Robert J
- [N169VT](https://openairdocs.org/aircraft/N169VT.md): Jonathan Sule VELOCITY V-TWIN · S/N VT006 · Built 2017 · Jsmd Aeronautics LLC
- [N177BA](https://openairdocs.org/aircraft/N177BA.md): Cessna 177B · S/N 17701449 · Anderson David J
- [N1791G](https://openairdocs.org/aircraft/N1791G.md): Beech 35-B33 · S/N CD-514 · Built 1962 · Pac Flying LLC
- [N231LM](https://openairdocs.org/aircraft/N231LM.md): Mooney M20K · S/N 25-0232 · Built 1979 · Asianov Alexander
- [N27CU](https://openairdocs.org/aircraft/N27CU.md): Alexander Schleicher ASW 27-18 · S/N 29058 · Clark Harold R
- [N2845A](https://openairdocs.org/aircraft/N2845A.md): Piper PA-34-200T · S/N 34-7970279 · Schwartzkopf Gregory
- [N2894B](https://openairdocs.org/aircraft/N2894B.md): Piper PA-28-181 · S/N 28-7990535 · Barthell Burley O
- [N4YL](https://openairdocs.org/aircraft/N4YL.md): Cagliero Giorgio LANCAIR 360 · S/N 366 · Built 1997 · Robinson Roger Jr
- [N5505L](https://openairdocs.org/aircraft/N5505L.md): Grumman American Avn. AA-5 · S/N AA5-0505 · Registration pending · Built 1974
- [N555LS](https://openairdocs.org/aircraft/N555LS.md): Smith Lawrence D VARIEZE · S/N 132 · Johnston Timothy A
- [N6199A](https://openairdocs.org/aircraft/N6199A.md): Thomas Thomas Clay SKY STAR KITFOX XL · S/N GCX-011 · Built 1998 · Parrish Jamie G
- [N75DW](https://openairdocs.org/aircraft/N75DW.md): Cessna 182P · S/N 18263906 · Built 1975 · Bliss Gregory A
- [N812GB](https://openairdocs.org/aircraft/N812GB.md): Beech F90 · S/N LA-72 · Built 1980 · Trinity Logistics Holdings LLC
- [N86ER](https://openairdocs.org/aircraft/N86ER.md): Cessna 172P · S/N 17276027 · Built 1983 · Innovative Aerial Solutions LLC
- [N8733P](https://openairdocs.org/aircraft/N8733P.md): Piper PA-24-260 · S/N 24-4183 · Built 1965 · Spaulding Rachael K
- [N92687](https://openairdocs.org/aircraft/N92687.md): Belknap John TITAN TORANADO S · S/N S01912SOHK0433 · Built 2002 · Belknap John R
- [N9896](https://openairdocs.org/aircraft/N9896.md): Piper PA-32R-300 · S/N 32R-7680184 · Built 1976 · Paul Chappano Pa
- [N992M](https://openairdocs.org/aircraft/N992M.md): Cirrus Design SR22 · S/N 5049 · Built 2021 · Bob Blandford Air 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 = 'FL' AND g.registrant_city = 'SAINT JOHNS'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/FL/Saint%20Johns/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.
