Ballston Spa, NY
Registered aircraft · 48
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 = 'NY' AND g.registrant_city = 'BALLSTON SPA' 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 = 'NY' AND g.registrant_city = 'BALLSTON SPA' 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.
N105WRSchleicher ASW-24 · S/N 24217N1108HPiper PA-28-151 · S/N 28-7715309N118YVSchempp Hirth NIMBUS II · S/N 25N121TTBolkow PHOEBUS C · S/N 819N152ASBurkhart Grob Werke GROB G 103 TWIN II · S/N 3545N179AMAviat A-1B · S/N 2317N17HWSchempp-Hirth DUO DISCUS CS · S/N 350 CSN198AZCessna U206G · S/N U20605961N20295Cessna 172M · S/N 17261168N2181TPiper PA-28-180 · S/N 28-7205036N24694Piper J3C-65 · S/N 3361N25026Glasflugel STD LIBELLE 201B · S/N 355N279JMBuckeye DREAM MACHINE · S/N 3168N302PMElan Tovarna Sportnega Orodja DG-300 ELAN · S/N 3E62N3106EAeronca 7CCM · S/N 7AC-6705N36WWBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1113N3843MPiper PA-12 · S/N 12-2754N3861ASchweizer SGS 1-26A · S/N 10N4119RPiper PA-32-300 · S/N 32-40188N415EPGlenn John R KITFOX SPEEDSTER IV · S/N C9404-0016N4246BI.C.A.-Brasov IS-28B2 · S/N 117First renewal noticeN43MDGlaser-Dirks DG 600 · S/N 6-40N456DBSchleicher ASH-25 · S/N 25023N4606YPiper PA-25-235 · S/N 25-4303N4615CBeech C90A · S/N LJ-1273N476PWRay L Hill WAGABOND · S/N 1432N47977Piper PA-32R-300 · S/N 32R-7880031N50425Cessna 150H · S/N 15069295N5054Burkhard Grob Werke Gmbh&Co ASTIR CS · S/N 1058N5331LPiper PA-28-180 · S/N 28-4635N537PVPipistrel Doo Ajdovscina VIRUS SW · S/N 537 SWN 100N575ASGrob-Werke GROB G 103A TWIN II · S/N 34039-K-270N6089QMooney M20C · S/N 3259N65317Pilatus B4-PC11 · S/N 190N67LBSchempp-Hirth NIMBUS 3 · S/N 23N729MDSchleicher ASW-27B · S/N 27197N7304JPiper PA-28-140 · S/N 28-24648N763RCMooney M20M · S/N 27-0160N7741FCessna 150F · S/N 15063841N81YVPilatus B4-PC11 · S/N 156N82169Piper PA-18-150 · S/N 18-7909063N863JACessna T206H · S/N T20608863N8656LPiper PA-25-235 · S/N 25-5101N873HBNeukom A ELFE S3 · S/N 16N902BGBurkhart Grob Flugzeugbau G102 STD ASTIR III · S/N 5559SN94HEBeech 400A · S/N RK-89N9524JPiper PA-28-180 · S/N 28-3649N996TBurkhart Grob Luft-Und Raumfah G103C TWIN III ACRO · S/N 34130
Back to Ballston Spa, NY