Benton, PA
Registered aircraft · 40
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 = 'PA' 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 = 'PA' 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.
N10256Grumman G-164 · S/N 56N1202WBell 47G-5 · S/N 7857N132HDBell OH-58A · S/N 72-21264N1374XBell 47G-5 · S/N 7839N15030Balloon Works FIREFLY 7 · S/N 11135N1503LBell 47G-5 · S/N 25042N16JDGarlick Helicopters OH-58C · S/N 71-20435N23790Stinson SR-10C · S/N 5928N284AABeech 35-33 · S/N CD-189N318XMaule M-5-210C · S/N 6145CN33534Piper PA-28-180 · S/N 28-7505155N33PHPiper PA-24-250 · S/N 24-1451N4097GBell 47G-5 · S/N 7907N4277FCessna 172 · S/N 46177N4798RBell 47G-5 · S/N 7925N48582Grumman Acft ENG Cor-Schweizer G-164A · S/N 1674N497ZDBell OH-58C · S/N 72-21172N5673ECessna 150 · S/N 17173N5923Woodruff MUSTANG I · S/N WM1-00692N6260HBell OH-58C · S/N 68-16794N63086Bell OH-58A · S/N 71-20521N661YGrumman G-164 · S/N 204N668CLLong Charles F Z-HI-MAX 1400 · S/N 668N700EWEagle EA-100 · S/N 1001N7236Grumman Acft ENG Cor-Schweizer G-164A · S/N 988N724NCBell OH-58C · S/N 68-16724N735YGrumman G-164 · S/N 295N73974Bell 47G-2A-1 · S/N 2874N752BBRobert M Brewington STOL CH750 · S/N 75-8670N7693Grumman Acft ENG Cor-Schweizer G-164A · S/N 985N7936SBell 47G-3B-1 · S/N 6600N8103JBell 47G-5 · S/N 25001N816JFBell OH-58C · S/N 71-20345N82855Garlick Helicopters OH-58C · S/N 71-20822N8593FBell 47G-5 · S/N 7820N9062TContinental Copters TOMCAT MK5A · S/N CCI-75-4N911TFBell OH-58C · S/N 72-21302N915XGrumman G-164A · S/N 434N955EBarchik Edward Carl PIETENPOLE · S/N 001N98536Piper J3C-65 · S/N 18746
Back to Benton, PA