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.
N6NHPiper PA-28-180 · S/N 28-3698N700CHHawker Beechcraft HAWKER 900XP · S/N HA-0030N70627Piper J3C-65 · S/N 17639N7073QGhan William W GHAN-WRIGHT FLYER · S/N GWF-1N7092VMooney M20C · S/N 20-1218N70SECirrus Design SR22T · S/N 2069N711CCCessna 560 · S/N 560-0094N711EUJenkins Ronald RV-4 · S/N 505N714DCheckoway Dan VANS RV-7 · S/N 70379N716SBPiper PA-32RT-300T · S/N 32R-7987088N7261ACessna 172 · S/N 29361N728EGCessna 182Q · S/N 18265842N733LCTextron 700 · S/N 700-0054N73505Cessna 172M · S/N 17267515N7410ECessna 210 · S/N 57110N74241Bellanca 14-13 · S/N 1354N75846Cessna 172N · S/N 17268000N7668KCessna 180J · S/N 18052697N766JWBeech B-60 · S/N P-421N768BKTextron T206H · S/N T20609752N77290DJI AGRAS T30 · S/N DJI3WWDZ-30A06E78N774JTTextron 525 · S/N 525-1065Registration pendingN777AGHawker Beechcraft HAWKER 900XP · S/N HA-0164N782MAMitsubishi MU-2B-26A · S/N 390SAN79264Cessna 172K · S/N 17258010N80225Powrachute PEGASUS · S/N A-333PEGN80971Globe GC-1B · S/N 1164N812VAVans RV-12IS · S/N 12196N8158BPiper PA-32R-301T · S/N 32R-8229038Registration pendingN8166BPiper PA-28-161 · S/N 28-8216129N8170ACirrus Design SR22 · S/N 0745N823ZHDJI MINI 4 PRO · S/N 1581F6Z98246S003F1ZHN82JRCirrus Design SR22 · S/N 10510N831BDCessna 525A · S/N 525A0439N84896Cessna 172K · S/N 17258658N84SLHawker Beechcraft G36 · S/N E-3808N850VFSocata TBM 700 · S/N 532N878TMTextron 680A · S/N 680A0049N8998CDJI MAVIC 3 PRO · S/N 1581F67QE239K00A00C8N8WWBeech 58TC · S/N TK-43N902CHMcdonnell Douglas Helicopter MD 900 · S/N 900-00042N902LCMD Helicopters MD 900 · S/N 900-00118N9086ZCessna 182T · S/N 18282281N90VMPiper PA-31T1 · S/N 31T-8104031N9105XPiper PA-28-181 · S/N 2890006N911MDCessna 182A · S/N 34174N9137EPiper PA-32R-301 · S/N 3213010N92172Cessna 182N · S/N 18260073N92390Piper PA-28-236 · S/N 2811045N923GSCessna 560XL · S/N 560-5624
Back to Springfield, MO