OpenAirDocs.org
Saint Joseph, MO

Registered aircraft · 42

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N1003FMooney M20J · S/N 24-1161Built 1981 · Chyatte DouglasN1010WFairchild 24R-9 · S/N R46-253Built 1946 · Lawlor Stephen MN10186Cessna 150L · S/N 15074813Built 1973 · Mckinley Brady LN11ZBGolden Circle Air T-BIRD II · S/N 29048Built 2004 · Goodman Donald L JrN1781JPiper PA-28-140 · S/N 28-24204Built 1968 · Weaver Dana LN1HZBombardier CL-600-2B16 · S/N 5711Built 2007 · Herzog Contracting CorpN2002ATaylorcraft F19 · S/N F-137Built 1979 · Ledford Stacey LN2HZIsrael Aircraft Industries GULFSTREAM G150 · S/N 216Built 2006 · Herzog Contracting CorpN302VADJI AGRAS T40 · S/N 64TBL9600200ALFarm Air LLCN325PRCirrus Design SR22T · S/N 1644Built 2017 · Bt Capital Assets II LLCN330CTCessna 177B · S/N 17702158Built 1974 · Robinson Paul JN4010VCessna 170 · S/N 18329Sale reportedBuilt 1948N41259Piper PA-28-181 · S/N 2843138Built 1998 · Pan Am Flight Services - St Joseph LLCN419TWAir Tractor AT-602 · S/N 602-1251Built 2014 · Midwest Agri Drone LLCN4939LPiper PA-28-180 · S/N 28-4309Built 1967 · Norcross Tracy DN499VACirrus Design SR22 · S/N 1921Built 2006 · Ideker IncN4HZBell 407 · S/N 53779Built 2007 · Herzog Contracting CorpN51NPHawker Beechcraft HAWKER 4000 · S/N RC-45Built 2010 · Npg Management LLCN5344WPiper PA-32R-301 · S/N 3246201Tech Team CorpN55317Piper PA-28R-200 · S/N 28R-7335214Built 1973 · Schwader Aviation LLCN5571MAero Commander 100 · S/N 105Built 1967 · Edwards Larry NN5772ACessna 172 · S/N 28372Built 1956 · Lawlor Stephen MN57JSSuccop HATZ CB-1 · S/N 57Built 1982 · Frohm Robert CN5865PPiper PA-24-250 · S/N 24-948Built 1959 · Ll Aviation LLCN6220UMooney M20C · S/N 2059Built 1962 · Barnes Dennis WN652PLPiper PA-31-350 · S/N 31-8052159Built 1980 · N652pl LLCN672MRBuckeye BREEZE · S/N A 11 MELBuilt 2004 · Lutes Martin EN70MWCirrus Design SR22 · S/N 1188Built 2004 · N70mw LLCN76060Cessna 120 · S/N 10454Parker Boston RN762DFStarkel G/Newton W VANS ACFT RV-8 · S/N 81933Starkel Gregory DN793YCHylio AG-22 · S/N 010232Midwest Agri Drone LLCN802HPAir Tractor AT-802A · S/N 802A-0819Built 2020 · Midwest Agri Drone LLCN847BCCrum Bruce ZENITH 750 · S/N 75-8375Built 2013 · Crum BruceN8570PVans RV-12IS · S/N 121134Built 2023 · H-Cubed Aircraft LLCN868VBLearjet 45 · S/N 354Built 2008 · Nw Holdings LLCN8864VBellanca 17-31A · S/N 32-48Built 1971 · Anthony BaruthN900FTSling SLING LSA · S/N 381ABuilt 2023 · Fly Tech Aviation Academy LLCN9204BCessna 175 · S/N 55004Built 1958 · Mcelwain FloydN9229EAeronca 11AC · S/N 11AC-863Built 1946 · Weaver DanaN937FMHylio AG-122 · S/N 010232Midwest Agri Drone LLCN9538CPiper PA-28-181 · S/N 28-7890421Built 1978 · Cobb JanetN9HZRobinson Helicopter R22 BETA · S/N 4338Built 2008 · Grace River Ranch LLC
Back to Saint Joseph, MO