# Registered aircraft: Saint Joseph, MO

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

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

- [N1003F](https://openairdocs.org/aircraft/N1003F.md): Mooney M20J · S/N 24-1161 · Built 1981 · Chyatte Douglas
- [N1010W](https://openairdocs.org/aircraft/N1010W.md): Fairchild 24R-9 · S/N R46-253 · Built 1946 · Lawlor Stephen M
- [N10186](https://openairdocs.org/aircraft/N10186.md): Cessna 150L · S/N 15074813 · Built 1973 · Mckinley Brady L
- [N11ZB](https://openairdocs.org/aircraft/N11ZB.md): Golden Circle Air T-BIRD II · S/N 29048 · Built 2004 · Goodman Donald L Jr
- [N1781J](https://openairdocs.org/aircraft/N1781J.md): Piper PA-28-140 · S/N 28-24204 · Built 1968 · Weaver Dana L
- [N1HZ](https://openairdocs.org/aircraft/N1HZ.md): Bombardier CL-600-2B16 · S/N 5711 · Built 2007 · Herzog Contracting Corp
- [N2002A](https://openairdocs.org/aircraft/N2002A.md): Taylorcraft F19 · S/N F-137 · Built 1979 · Ledford Stacey L
- [N2HZ](https://openairdocs.org/aircraft/N2HZ.md): Israel Aircraft Industries GULFSTREAM G150 · S/N 216 · Built 2006 · Herzog Contracting Corp
- [N302VA](https://openairdocs.org/aircraft/N302VA.md): DJI AGRAS T40 · S/N 64TBL9600200AL · Farm Air LLC
- [N325PR](https://openairdocs.org/aircraft/N325PR.md): Cirrus Design SR22T · S/N 1644 · Built 2017 · Bt Capital Assets II LLC
- [N330CT](https://openairdocs.org/aircraft/N330CT.md): Cessna 177B · S/N 17702158 · Built 1974 · Robinson Paul J
- [N4010V](https://openairdocs.org/aircraft/N4010V.md): Cessna 170 · S/N 18329 · Sale reported · Built 1948
- [N41259](https://openairdocs.org/aircraft/N41259.md): Piper PA-28-181 · S/N 2843138 · Built 1998 · Pan Am Flight Services - St Joseph LLC
- [N419TW](https://openairdocs.org/aircraft/N419TW.md): Air Tractor AT-602 · S/N 602-1251 · Built 2014 · Midwest Agri Drone LLC
- [N4939L](https://openairdocs.org/aircraft/N4939L.md): Piper PA-28-180 · S/N 28-4309 · Built 1967 · Norcross Tracy D
- [N499VA](https://openairdocs.org/aircraft/N499VA.md): Cirrus Design SR22 · S/N 1921 · Built 2006 · Ideker Inc
- [N4HZ](https://openairdocs.org/aircraft/N4HZ.md): Bell 407 · S/N 53779 · Built 2007 · Herzog Contracting Corp
- [N51NP](https://openairdocs.org/aircraft/N51NP.md): Hawker Beechcraft HAWKER 4000 · S/N RC-45 · Built 2010 · Npg Management LLC
- [N5344W](https://openairdocs.org/aircraft/N5344W.md): Piper PA-32R-301 · S/N 3246201 · Tech Team Corp
- [N55317](https://openairdocs.org/aircraft/N55317.md): Piper PA-28R-200 · S/N 28R-7335214 · Built 1973 · Schwader Aviation LLC
- [N5571M](https://openairdocs.org/aircraft/N5571M.md): Aero Commander 100 · S/N 105 · Built 1967 · Edwards Larry N
- [N5772A](https://openairdocs.org/aircraft/N5772A.md): Cessna 172 · S/N 28372 · Built 1956 · Lawlor Stephen M
- [N57JS](https://openairdocs.org/aircraft/N57JS.md): Succop HATZ CB-1 · S/N 57 · Built 1982 · Frohm Robert C
- [N5865P](https://openairdocs.org/aircraft/N5865P.md): Piper PA-24-250 · S/N 24-948 · Built 1959 · Ll Aviation LLC
- [N6220U](https://openairdocs.org/aircraft/N6220U.md): Mooney M20C · S/N 2059 · Built 1962 · Barnes Dennis W
- [N652PL](https://openairdocs.org/aircraft/N652PL.md): Piper PA-31-350 · S/N 31-8052159 · Built 1980 · N652pl LLC
- [N672MR](https://openairdocs.org/aircraft/N672MR.md): Buckeye BREEZE · S/N A 11 MEL · Built 2004 · Lutes Martin E
- [N70MW](https://openairdocs.org/aircraft/N70MW.md): Cirrus Design SR22 · S/N 1188 · Built 2004 · N70mw LLC
- [N76060](https://openairdocs.org/aircraft/N76060.md): Cessna 120 · S/N 10454 · Parker Boston R
- [N762DF](https://openairdocs.org/aircraft/N762DF.md): Starkel G/Newton W VANS ACFT RV-8 · S/N 81933 · Starkel Gregory D
- [N793YC](https://openairdocs.org/aircraft/N793YC.md): Hylio AG-22 · S/N 010232 · Midwest Agri Drone LLC
- [N802HP](https://openairdocs.org/aircraft/N802HP.md): Air Tractor AT-802A · S/N 802A-0819 · Built 2020 · Midwest Agri Drone LLC
- [N847BC](https://openairdocs.org/aircraft/N847BC.md): Crum Bruce ZENITH 750 · S/N 75-8375 · Built 2013 · Crum Bruce
- [N8570P](https://openairdocs.org/aircraft/N8570P.md): Vans RV-12IS · S/N 121134 · Built 2023 · H-Cubed Aircraft LLC
- [N868VB](https://openairdocs.org/aircraft/N868VB.md): Learjet 45 · S/N 354 · Built 2008 · Nw Holdings LLC
- [N8864V](https://openairdocs.org/aircraft/N8864V.md): Bellanca 17-31A · S/N 32-48 · Built 1971 · Anthony Baruth
- [N900FT](https://openairdocs.org/aircraft/N900FT.md): Sling SLING LSA · S/N 381A · Built 2023 · Fly Tech Aviation Academy LLC
- [N9204B](https://openairdocs.org/aircraft/N9204B.md): Cessna 175 · S/N 55004 · Built 1958 · Mcelwain Floyd
- [N9229E](https://openairdocs.org/aircraft/N9229E.md): Aeronca 11AC · S/N 11AC-863 · Built 1946 · Weaver Dana
- [N937FM](https://openairdocs.org/aircraft/N937FM.md): Hylio AG-122 · S/N 010232 · Midwest Agri Drone LLC
- [N9538C](https://openairdocs.org/aircraft/N9538C.md): Piper PA-28-181 · S/N 28-7890421 · Built 1978 · Cobb Janet
- [N9HZ](https://openairdocs.org/aircraft/N9HZ.md): Robinson Helicopter R22 BETA · S/N 4338 · Built 2008 · Grace River Ranch 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 = 'MO' AND g.registrant_city = 'SAINT JOSEPH'
ORDER BY g.n_number
```

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