# Registered aircraft: Summerfield, FL

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

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

- [N2001L](https://openairdocs.org/aircraft/N2001L.md): Aerofab LA-4 · S/N 334 · Built 1966 · Seventh LLC
- [N206SH](https://openairdocs.org/aircraft/N206SH.md): Bell 206B · S/N 1666 · Built 1975 · Mc Helicopter LLC
- [N281Y](https://openairdocs.org/aircraft/N281Y.md): Haggerty Eugene J DAUNTLESS II · S/N 1091 · Built 1991 · Turan John S
- [N3142Q](https://openairdocs.org/aircraft/N3142Q.md): Cessna 182K · S/N 18258142 · Built 1967 · Rogers James
- [N3405K](https://openairdocs.org/aircraft/N3405K.md): Davidson Karl A RV-12 · S/N 120796 · Built 2024 · Davidson Karl A
- [N3808Q](https://openairdocs.org/aircraft/N3808Q.md): Beech F33A · S/N CE-936 · Jordan Klein DBA
- [N3948V](https://openairdocs.org/aircraft/N3948V.md): Cessna 170 · S/N 18267 · Klein Jordan Jr
- [N4230B](https://openairdocs.org/aircraft/N4230B.md): Beech F35 · S/N D-4201 · Yonge Chase L
- [N487JP](https://openairdocs.org/aircraft/N487JP.md): David M Liess VAGARY · S/N 1001 · Built 2023 · Liess David M
- [N5420E](https://openairdocs.org/aircraft/N5420E.md): Cessna 150E · S/N 644 · Built 1963 · Crowder John T
- [N61EE](https://openairdocs.org/aircraft/N61EE.md): Beech E33 · S/N CD-1226 · Built 1969 · Gerber Ernst
- [N731JC](https://openairdocs.org/aircraft/N731JC.md): Crowder John T SAFARI · S/N 0588N · Built 2006 · Crowder John T
- [N73279](https://openairdocs.org/aircraft/N73279.md): Bell 47G-4 · S/N 3134 · Mc Helicopter LLC
- [N7344M](https://openairdocs.org/aircraft/N7344M.md): Cessna 175 · S/N 55644 · Built 1958 · Kiever Robert P Jr
- [N8971J](https://openairdocs.org/aircraft/N8971J.md): Piper PA-28-180 · S/N 28-2994 · Built 1965 · Swearingen Louis S
- [N987SB](https://openairdocs.org/aircraft/N987SB.md): Consolidated Aeronautics LAKE LA-4-200 · S/N 568 · Built 1973 · Yonge Lawrence W III

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

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