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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N340RCSaab-Scania SAAB 340B · S/N 340B-340N34265Cessna 177B · S/N 17701739N3487KPiper J3C-65 · S/N 22177N34AURobinson Helicopter R44 II · S/N 13691N371CTFlight Design CTSW · S/N 06-05-11N372BPTextron 700 · S/N 700-0045N372BTTextron 700 · S/N 700-0170N3767BButler Benny SONERAI-II · S/N 660N37SGAviat S-2C · S/N 6050N41CUCessna 421C · S/N 421C0318N4322UAero L-39 ALBATROS · S/N 432844N435LLEurocopter Deutschland EC 135 P2+ · S/N 0758N4415TTadin Noel N KR-2 · S/N 111948N4590BCessna 152 · S/N 15283545N481JHDJI MINI 4 PRO · S/N 1581F6Z9C238E00326DHN4843WRockwell International 114 · S/N 14173N485DSCessna 421C · S/N 421C0459N4881ECessna 172N · S/N 17271672N502EGCessna 560XL · S/N 560-5502N5032CBeech B35 · S/N D-2294N5064ZPiper PA-22-108 · S/N 22-8692N5127NCessna 182Q · S/N 18267534N5150ERaytheon A36 · S/N E-3412N520EPCessna 182T · S/N 18282274N535LLEurocopter Deutschland EC 135 P2+ · S/N 0817N541HWWilliam H Isenberger DMG 560 · S/N DMG20150201N5441MSwearingen SA-226T · S/N T-283N550RLBombardier BD-700-1A11 · S/N 60179N5529XCessna 140 · S/N 14303N55PVRobinson Helicopter R44 II · S/N 10815N560PGCessna 560XL · S/N 560-5645N5680RCessna 172F · S/N 17253320N571APCessna 560 · S/N 560-0805N586FDCessna 525A · S/N 525A0324N588AStits SA3A PLAYBOY · S/N HS-1N5908TCessna 150D · S/N 15060608N594JDCoussens Jerry KITFOX V · S/N S9410-0052N60735Cessna 150J · S/N 15070535N60TAPiper PA-31-350 · S/N 31-7552094N612BEAviat A-1 · S/N 1367N61302Boeing A75N1(PT17) · S/N 75-2331N620KEIsrael Aircraft Industries ASTRA SPX · S/N 137N6210YCessna T206H · S/N T20608890N624NBGulfstream Aerospace GVII-G600 · S/N 73145N62KWTextron 560XL · S/N 560-6205N63DDWait Dale O RV 10 · S/N 42365N64LCCoatney Larry VANS RV6-A · S/N 21836Sale reportedN68302Cessna 152 · S/N 15282240N683GRDJI MAVIC 3 CINE · S/N 1581F4QZB21AW1AE00U1N6969NPiper J3C-65 · S/N 4586
Back to Springfield, MO