Springfield, MO

Registered aircraft · 157

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 = 'SPRINGFIELD'
  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.

N340RCSaab-Scania SAAB 340B · S/N 340B-340Consumer Aviation IncN34265Cessna 177B · S/N 17701739Clc Aviation LLCN3487KPiper J3C-65 · S/N 22177Built 1946 · Mcclean James AN34AURobinson Helicopter R44 II · S/N 13691Built 2014 · Airtime Ventures II LLCN371CTFlight Design CTSW · S/N 06-05-11Built 2006 · Mcafee Aviation LLCN372BPTextron 700 · S/N 700-0045Built 2021 · Bt Aviation LLCN372BTTextron 700 · S/N 700-0170Built 2026 · Bt Aviation LLCN3767BButler Benny SONERAI-II · S/N 660Hall TomN37SGAviat S-2C · S/N 6050Built 2001 · Groce Steven FN41CUCessna 421C · S/N 421C0318Encinal Aviation LLCN4322UAero L-39 ALBATROS · S/N 432844Built 1984 · Orion Aviation LLCN435LLEurocopter Deutschland EC 135 P2+ · S/N 0758Built 2008 · Mercy Hospital SpringfieldN4415TTadin Noel N KR-2 · S/N 111948Built 1983 · Gregory George RN4590BCessna 152 · S/N 15283545Built 1979 · Fulltron Aviation LLCN481JHDJI MINI 4 PRO · S/N 1581F6Z9C238E00326DHConvoy Of HopeN4843WRockwell International 114 · S/N 14173Built 1976 · Mcclean Matthew JamesN485DSCessna 421C · S/N 421C0459Built 1978 · Encinal Aviation LLCN4881ECessna 172N · S/N 17271672Built 1978 · Fulltron Aviation LLCN502EGCessna 560XL · S/N 560-5502Built 2004 · X-Ray Lima Sierra LLCN5032CBeech B35 · S/N D-2294Built 1950 · Gann Mark EN5064ZPiper PA-22-108 · S/N 22-8692Built 1961 · Gregory Trace DN5127NCessna 182Q · S/N 18267534Sierra Breeze LLCN5150ERaytheon A36 · S/N E-3412M & M Aviation Enterprises LLCN520EPCessna 182T · S/N 18282274Built 2010 · Miles In The Sky LLCN535LLEurocopter Deutschland EC 135 P2+ · S/N 0817Built 2009 · Mercy Hospital SpringfieldN541HWWilliam H Isenberger DMG 560 · S/N DMG20150201Isenberger William HN5441MSwearingen SA-226T · S/N T-283Built 1977 · Ca Aviation IncN550RLBombardier BD-700-1A11 · S/N 60179Built 2025 · New Prime IncN5529XCessna 140 · S/N 14303Ferguson Flying Service LLCN55PVRobinson Helicopter R44 II · S/N 10815Built 2005 · Heli Munnik LLCN560PGCessna 560XL · S/N 560-5645Built 2006 · N560pg Xls LLCN5680RCessna 172F · S/N 17253320Built 1965 · Braun Joshua HN571APCessna 560 · S/N 560-0805Built 2011 · Oreilly II Aviation CorpN586FDCessna 525A · S/N 525A0324Built 2006 · Timber Ridge Aviation LLCN588AStits SA3A PLAYBOY · S/N HS-1Built 1966 · Durham Devin LN5908TCessna 150D · S/N 15060608Built 1964 · Dorweiler Tom ON594JDCoussens Jerry KITFOX V · S/N S9410-0052Built 1995 · Hansen Mark BN60735Cessna 150J · S/N 15070535Built 1969 · Ozarks Technical Community CollegeN60TAPiper PA-31-350 · S/N 31-7552094Aero Elite LLCN612BEAviat A-1 · S/N 1367Fulltron Aviation LLCN61302Boeing A75N1(PT17) · S/N 75-2331Built 1941 · Webb Patricia FN620KEIsrael Aircraft Industries ASTRA SPX · S/N 137Built 2001 · Air Coryell Flight LLCN6210YCessna T206H · S/N T20608890Built 2008 · Bddixon Aviation LLCN624NBGulfstream Aerospace GVII-G600 · S/N 73145Built 2024 · M J Enterprises LLCN62KWTextron 560XL · S/N 560-6205Built 2016 · Cricket Creek LLCN63DDWait Dale O RV 10 · S/N 42365Built 2023 · Wait Dale ON64LCCoatney Larry VANS RV6-A · S/N 21836Sale reportedBuilt 2004N68302Cessna 152 · S/N 15282240Fulltron Aviation LLCN683GRDJI MAVIC 3 CINE · S/N 1581F4QZB21AW1AE00U1Convoy Of HopeN6969NPiper J3C-65 · S/N 4586Built 1940 · Mcclean James
Back to Springfield, MO