Topeka, KS
Registered aircraft · 137
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 = 'KS' AND g.registrant_city = 'TOPEKA' 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 = 'KS' AND g.registrant_city = 'TOPEKA' 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.
N7421KBalloon Works FIREFLY 8B · S/N F8B-028N7565YPiper PA-30 · S/N 30-629N7578PPiper PA-24-180 · S/N 24-2789N7591TCessna 172A · S/N 47191N7627DPiper PA-28R-200 · S/N 28R-35055N76975Cessna 140 · S/N 11421N776PCPilatus PC-6/B2-H2 · S/N 775N7780CSabrena TIERRA II · S/N 072401N785TBCessna 560XL · S/N 560-5625N78MWCessna TU206F · S/N U20603205N81395Fairchild 24W-46 · S/N W46295N831KBRaytheon 400A · S/N RK-504N84639Beech D-45 · S/N BG-241N8477PPiper PA-24-400 · S/N 26-55N8549NPiper PA-28-235 · S/N 28-11348N855MCBeech D-45 · S/N BG-189N8638ZCessna P206C · S/N P206-0438N8647QCessna TU206F · S/N U20603463N87693Beech SNB-5 · S/N 51241N88444Piper J3C-65 · S/N 16066N88796Beech D-45 · S/N BG-203N892SBCessna 560XL · S/N 560-5686N89585Cessna 152 · S/N 15282796N900HPCessna 206H · S/N 20608344N901SJVans RV-12IS · S/N 12214N9059WAmerican AA-5 · S/N AA5-0584N916XXHylio AG-216 · S/N 17906090224N92330Piper J3C-65 · S/N 16785N9348NPiper PA-28R-200 · S/N 28R-35049N940HPCessna 206H · S/N 20608343N94527Cessna 182Q · S/N 18266428N94667Ercoupe 415-CD · S/N 4778N950HPCessna 206H · S/N 20608002N9525EBellanca 17-30A · S/N 76-30839N9768KPiper PA-28R-201T · S/N 28R-7803067N98349Piper J3C-50S · S/N 18520N98531Piper J3C-65 · S/N 7272
Back to Topeka, KS