Springfield, IL
Registered aircraft · 120
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 = 'IL' 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 = 'IL' 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.
N522MRyan Aeronautical ST3KR · S/N 2005N525VECessna 525A · S/N 525A0213N551SPTextron T206H · S/N T20609766N553GRDassault FALCON 2000 · S/N 64N561SPCessna 182S · S/N 18280825N562VPCessna 560XL · S/N 560-5623N5647WPiper PA-28-160 · S/N 28-804N5655HPiper PA-16 · S/N 16-266N5724RCessna 172G · S/N 17253393N58015William Bernard BUTTERCUP · S/N 251N582WSSmith Wesley R PHOENIX II · S/N 5-8-9-0005N5855RCessna 172G · S/N 17253524N589WKDehavilland DHC-1 SERIES 22 · S/N C1/0613N5956CBeech C35 · S/N D-3317N612AKreutzer K-5 · S/N 102N631SPDJI INSPIRE 1 · S/N W13DCC30030663N634MBeech A45 · S/N G-761N64448Cessna 172M · S/N 17265235N64463Beech C18S · S/N 4534N6448ECessna 172 · S/N 46548N645BEmbraer S A EMB-505 · S/N 50500238N6484ACessna 210N · S/N 21063535N65RLCessna 560 · S/N 560-0179N661SPTextron T206H · S/N T20609767N671KWCessna 525 · S/N 5250273N68CPPiper PA 46-350P · S/N 4636238N700CMCessna 510 · S/N 510-0009N700RVRonald W Ingram RV-6A · S/N 001N7066NBeech E33A · S/N CE-190Registration pendingN74BRBeech A36 · S/N E-3106N750XZMorgan G Russell STOL CH 750 · S/N 75-8963N751LLSikorsky S-76B · S/N 760318N75CHCessna 525A · S/N 525A0182N77021Cessna 140 · S/N 11467N771SPTextron T206H · S/N T20609769N773KWaco GXE · S/N 1808Registration pendingN775TBCessna 525 · S/N 525-0075N777RBCessna 560XL · S/N 560-5641N786JPAmerican Champion 8GCBC · S/N 484-2006N788JMHawker Beechcraft C90GTI · S/N LJ-1868N8060WPiper PA-28-180 · S/N 28-2139N831LLCessna 182Q · S/N 18266533N8431Stinson SM-2AA · S/N 1051N8475SAutel Robotics X-STAR PREMIUM · S/N UXS917242421N848BSAutel Robotics X-STAR PREMIUM · S/N UXS917242503N8661BCessna 172 · S/N 36361N871PDCessna 182S · S/N 18280871N8725SCessna 150F · S/N 15062025N881SPCessna 182S · S/N 18280784N8835Stearman C3-B · S/N 241
Back to Springfield, IL