Seneca, KS
Registered aircraft · 41
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 = 'SENECA' 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 = 'SENECA' 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.
N125HBPiper PA-36-300 · S/N 367860021N126HBAir Tractor AT-502B · S/N 502B-2947N156APDJI AGRAS T40 · S/N 1581F574B239600100N9N214BWAmerican Champion 7GCBC · S/N 1202-94N223HKRobinson Helicopter R44 II · S/N 14984N282WJDJI AGRAS T40 · S/N 1581F574B2398001000KN288LAPiaggio Aero Industries P180 · S/N 1176N343RZDJI AGRAS T30 · S/N 3U5BJ6L001000EN367RZDJI AGRAS T30 · S/N 3U5BJ670010018N4128XDJI AGRAS T50 · S/N 63YBLAM0020046N413AXDJI AGRAS T50 · S/N 63YBLAM002004AN415DAEa Vision EA J100 · S/N 85398N432TVBell 206B · S/N 3286N5086MEa Vision J100 · S/N EAVUAV502586272N508HBAir Tractor AT-502B · S/N 502B-2816N51284Cessna 150J · S/N 15069894N513HBAir Tractor AT-502B · S/N 502B-2901N530HBHughes Helicopters HUGHES 369D · S/N 121096DN562TSCessna 560XL · S/N 560-5178N565LFDaniel F Ronnebaum CHALLENGER II · S/N CH2-1213-LSS-L65-0249N586JDDunn James W GLASAIR I · S/N 368N65EBCessna R172K · S/N R1722331N73084Air Tractor AT-400 · S/N 400-0638N776DCDJI AGRAS T40 · S/N 64TBL5A0020059N801HBAir Tractor AT-802A · S/N 802A-0539N802CLAir Tractor AT-802A · S/N 802A-0682N802DJAir Tractor AT-802A · S/N 802A-0485N802HBAir Tractor AT-802A · S/N 802A-0547N802KDAir Tractor AT-802A · S/N 802A-0500N802LTAir Tractor AT-802A · S/N 802A-0785N803HBAir Tractor AT-802A · S/N 802A-0635N804HBAir Tractor AT-802A · S/N 802A-0710N805HBAir Tractor AT-802A · S/N 802A-0570N808HBAir Tractor AT-802A · S/N 802A-0498N80GCGame Composites GB1 GAMEBIRD · S/N 0080N8342VChampion 7ECA · S/N 232N851DCAir Tractor AT-802A · S/N 802A-0921N871SCPiper PA-18-150 · S/N 18-8935N8839TCessna 182C · S/N 52739N8ZXAmerican Champion 7GCBC · S/N 1210-95N9148CAir Tractor AT-502B · S/N 502B-0632
Back to Seneca, KS