# Registered aircraft: Florissant, MO

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

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

- [N13543](https://openairdocs.org/aircraft/N13543.md): Cessna 172M · S/N 17262836 · Built 1973 · Skylink II LLC
- [N2435U](https://openairdocs.org/aircraft/N2435U.md): Cessna 172D · S/N 17250035 · Built 1963 · Galati Stephen E
- [N29160](https://openairdocs.org/aircraft/N29160.md): Cessna 172M · S/N 17264104 · Built 1974 · Felber Dave A
- [N3575E](https://openairdocs.org/aircraft/N3575E.md): Aeronca 7AC · S/N 7AC6917 · Skylink Aviation Inc
- [N3657K](https://openairdocs.org/aircraft/N3657K.md): Piper J3C-65 · S/N 22347 · Built 1946 · Schonhorst John B
- [N410V](https://openairdocs.org/aircraft/N410V.md): C Mitchell Smith RV-10 · S/N 40004 · Built 2014 · Four Ten Flyers LLC
- [N42812](https://openairdocs.org/aircraft/N42812.md): Piper PA-28-180 · S/N 28-7405166 · Built 1974 · Skylink Aviation Inc
- [N43890](https://openairdocs.org/aircraft/N43890.md): Taylorcraft BC12-D · S/N 7549 · Built 1946 · Skylink Aviation Inc
- [N5602A](https://openairdocs.org/aircraft/N5602A.md): Cessna 172 · S/N 28202 · Built 1956 · Looney Hubert
- [N6647W](https://openairdocs.org/aircraft/N6647W.md): Piper PA-28-140 · S/N 28-20748 · Built 1965 · Panama Truck Line LLC
- [N6830E](https://openairdocs.org/aircraft/N6830E.md): Cessna 175A · S/N 56330 · Built 1960 · Jackson Thomas M
- [N68JS](https://openairdocs.org/aircraft/N68JS.md): North American AT-6F · S/N 112070 · Built 1944 · Schonhorst John B Jr
- [N7622J](https://openairdocs.org/aircraft/N7622J.md): Piper PA-28R-180 · S/N 28R-31017 · Built 1968 · Skylink Aviation Inc
- [N7875F](https://openairdocs.org/aircraft/N7875F.md): Cessna 150F · S/N 15063975 · Built 1966 · Deffendall Cathy S
- [N83603](https://openairdocs.org/aircraft/N83603.md): Aeronca 7AC · S/N 7AC-2279 · Built 1946 · Skylink Aviation Inc
- [N8714P](https://openairdocs.org/aircraft/N8714P.md): Piper PA-24-260 · S/N 24-4162 · Built 1965 · Blanchard Paul R
- [N8986S](https://openairdocs.org/aircraft/N8986S.md): Cessna 150F · S/N 15062286 · Built 1965 · Schneider Jackson L
- [N994Q](https://openairdocs.org/aircraft/N994Q.md): Beech N35 · S/N D-6817 · Built 1961 · Looney Hubert

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

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