# Registered aircraft: Foristell, MO

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

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

- [N222AX](https://openairdocs.org/aircraft/N222AX.md): Cessna 414 · S/N 414-0078 · Built 1970 · Graven Timothy G
- [N23671](https://openairdocs.org/aircraft/N23671.md): Taylorcraft BL-65 · S/N 1404 · Built 1939 · Newcombe Steven P
- [N2641F](https://openairdocs.org/aircraft/N2641F.md): JDT Mini-Max 1550 V · S/N 499 · Newcombe Steven P
- [N2748C](https://openairdocs.org/aircraft/N2748C.md): Cessna 170B · S/N 26292 · Built 1954 · Zaathof Aero LLC
- [N3107G](https://openairdocs.org/aircraft/N3107G.md): Hiller H-23A · S/N 236 · Built 1959 · Zaathof Aero LLC
- [N3357A](https://openairdocs.org/aircraft/N3357A.md): Piper PA-18 · S/N 18-3004 · Built 1953 · Beachum Norman L
- [N35215](https://openairdocs.org/aircraft/N35215.md): Piper J3F-65 · S/N 6212 · Built 1941 · Sachs Maurice G
- [N363FS](https://openairdocs.org/aircraft/N363FS.md): Maule M-7-235B · S/N 23049C · Built 1999 · Marlu Enterprises Inc
- [N37GB](https://openairdocs.org/aircraft/N37GB.md): Broomell Glenn RV-8 · S/N 003 · Built 2005 · Albright David J
- [N423PM](https://openairdocs.org/aircraft/N423PM.md): Robinson Helicopter R44 II · S/N 12211 · Built 2008 · Men Aviation LLC
- [N4412P](https://openairdocs.org/aircraft/N4412P.md): Peterson Lowell KITFOX II · S/N 591 · Built 1992 · Newcombe Steven P
- [N455CX](https://openairdocs.org/aircraft/N455CX.md): Thomas Hrdlicka CX4 · S/N 455 · Built 2014 · Hrdlicka Thomas O
- [N50286](https://openairdocs.org/aircraft/N50286.md): Cessna 150H · S/N 15069197 · Built 1968 · Baue Michael G
- [N53431](https://openairdocs.org/aircraft/N53431.md): Ryan Aeronautical ST3KR · S/N 1896 · Built 1942 · Zaathof Aero LLC
- [N606WM](https://openairdocs.org/aircraft/N606WM.md): Mooney M20R · S/N 29-0070 · Built 1995 · Holt Timothy L
- [N625AL](https://openairdocs.org/aircraft/N625AL.md): Mays Allan G FLIGHTSTAR II SL · S/N 095 · Newcombe Steven P
- [N65580](https://openairdocs.org/aircraft/N65580.md): Boeing A75N1(PT17) · S/N 75-3302 · Built 1943 · Marlu Enterprises Inc
- [N6621W](https://openairdocs.org/aircraft/N6621W.md): Piper PA-28-140 · S/N 28-20717 · Built 1965 · Gbg Aviation LLC
- [N678DJ](https://openairdocs.org/aircraft/N678DJ.md): Jonas Donald NIEUPORT · S/N 735 · Jonas Joann
- [N71038](https://openairdocs.org/aircraft/N71038.md): Parascender PARASCENDER II · S/N 220115 · Built 1998 · Grable Eugene W
- [N72489](https://openairdocs.org/aircraft/N72489.md): Cessna 140 · S/N 9657 · Built 1946 · Armor Air Corp
- [N7883T](https://openairdocs.org/aircraft/N7883T.md): Taylorcraft F22A · S/N 2211 · Built 1991 · Marlu Enterprises Inc
- [N8163T](https://openairdocs.org/aircraft/N8163T.md): Piper PA-28-181 · S/N 28-8090253 · Built 1980 · Heuschele Michael C
- [N8613S](https://openairdocs.org/aircraft/N8613S.md): Cessna 150F · S/N 15061913 · Built 1965 · Hanna Michael
- [N8707V](https://openairdocs.org/aircraft/N8707V.md): Bellanca 8KCAB · S/N 190-75 · Built 1975 · Beckerwilliam M Trustee
- [N9142P](https://openairdocs.org/aircraft/N9142P.md): Piper PA-24-260 · S/N 24-4623 · Built 1966 · Erickson Ralph E

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

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