Benton, KS
Registered aircraft · 73
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 = 'BENTON' 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 = 'BENTON' 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.
N1205SBeech E-90 · S/N LW-319N121GWPipistrel Italia S R L TAURUS ELECTRO G2 · S/N 175 T ETN1222WCessna 150M · S/N 15075991N1290XMooney M20E · S/N 163N13143Cessna 172M · S/N 17262526N14123Paul Roy RV-14 · S/N 140011N1541PPiper PA-22-135 · S/N 22-2405N162WBBeech T-34B · S/N BG-362JSN1825Schleicher KA 6 CR · S/N 6619N2049XCessna 182H · S/N 18256149N222PHBombardier CL-600-2B16 · S/N 5151N22448Cessna 150H · S/N 15068291N2374UCessna 172D · S/N 17249974N247AABeech K35 · S/N D-6034N25006Keleher Lark JK-1B · S/N 118N26502Cessna 172R · S/N 17280600N3019TMaule M-7-235B · S/N 23099CN3147QCessna 182K · S/N 18258147N3256ABoeing A75N1(PT17) · S/N 75-2830N3439BBeech D35 · S/N D-3677N3658JCessna 150G · S/N 15064958N371DSPiper PA-23 · S/N 23-153N400PVRaytheon 400A · S/N RK-263N4166NCessna 120 · S/N 13637N44044Taylorcraft BC12-D · S/N 9844N4416TTaylorcraft BC12-D · S/N 7502N4610VBoeing A75N1(PT17) · S/N 75-366N4630KCessna 182P · S/N 18263632N4862ECessna 182R · S/N 18268279N495BCCirrus Design SR22T · S/N 2239N5024BBeech F35 · S/N D-4289N507GBBurke Randy LANCAIR 320 · S/N 593-320-340FBN58086Mooney M20J · S/N 24-1552N58285Stinson VULTEE V-77 · S/N 77-103N5950PPiper PA-24-250 · S/N 24-1041N60390Boeing B75N1 · S/N 75-1254N61SMBeech A36 · S/N E-199N6283CAeronca 7BCM · S/N 47-894N63774Buckendahl Steve RV-4 · S/N 4192N6459EEric C Danner RUCKUS FX · S/N TR016-7-25N649LADJI AGRAS T100 · S/N 1581F8ZLC25950025WQNN6509HCessna 172M · S/N 17265470Sale reportedN6528LGrumman American Avn. AA-1B · S/N AA1B-0328N6713CCessna 182H · S/N 18256662N6842VMooney M20E · S/N 21-1176N68JXWynter David PITTS S1S · S/N S1-10-59N6964QBeech A23-24 · S/N MA-309N69GBoeing B75N1 · S/N 75-7781N70541Cessna 172K · S/N 17258757N70723Reed Doyle L RV7A · S/N 70003
Back to Benton, KS