Queensbury, NY
Registered aircraft · 50
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 = 'QUEENSBURY' 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 = 'QUEENSBURY' 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.
N1046GCameron Balloons US A-210 · S/N 6376N160HFCameron Balloons US Z-160 · S/N 6697N1847YCessna 172C · S/N 17249447First renewal noticeN18EWBeech 35-C33A · S/N CE-22N1CFBombardier BD-700-1A10 · S/N 9519N214WBHeldeberg Designs BLUE HERON MARATHON · S/N HD 04124MN224CHCessna A185F · S/N 18503075N226FFRubens Kalousdian RUBIC FISH · S/N 095N227SVGulfstream Aerospace GIV-X (G450) · S/N 4210N24225Head Balloons AX8-105 · S/N 368N3007FCessna 182J · S/N 18257107N30228Lindstrand Balloons 77A · S/N 5083N3239ECessna 172N · S/N 17271478N3486RPiper PA-28-180 · S/N 28-5701N351APipistrel Italia S R L ALPHA TRAINER · S/N 1051 AT 912 LSAN3870LCessna 172G · S/N 17254039N4006KHead Balloons AX9-118 · S/N 425N4033JAdams Balloon A B · S/N 144N4059PBoeing B75N1 · S/N 75-7140N44FGRobinson Helicopter R44 II · S/N 13925N4925GCessna 172N · S/N 17273472N5412SCessna R182 · S/N R18201567N5442TPiper PA-28R-200 · S/N 28R-7235232N557BAIcon A5 · S/N 00171N561PBRonald B Belliveau PA-18 REPLICA · S/N RBB0064N582DSAero Designs PULSAR · S/N 125N62488Cessna 172P · S/N 17275282N625FFLuiz Paulo Gnecco Rodrigues De AF-SS-14 · S/N LP2013-02N625LLLindstrand Balloons LBL LION · S/N 1026N625SKCameron Balloons US A-225 · S/N 6983N625SLAir Fly Balonismo E Inflaveis AF-SS-71 · S/N LP2020-04N625TGAir Fly Balloons AF-SS-76 · S/N LP2021-04N625UNBalonismo E Inflaveis Ltda AF-SS-32 · S/N LP2019-02N65066Cameron Balloons Z-90 · S/N 6637N652MPiper J3C-65 · S/N 16623N74JDSocata TB-20 TRINIDAD · S/N 576N8013ULake LA-4-200 · S/N 1073N84741Aeronca 7AC · S/N 7AC-3457N8829AAlexander Schleicher ASW 27-18 · S/N 29034N8873ALindstrand Balloons 90A · S/N 5286N9029ZAerostar International RX-7 · S/N RX7-3270N91297Aerostar International S60H · S/N S60H-3007N942AMCirrus Design SR22 · S/N 10699N94CGSchleicher ASW-24 · S/N 24229N965GSAerostar International S-60A · S/N S60A-3235N9713SCassidy Ron 2466 · S/N 101N9838QPiper PA-18-135 · S/N 18-3372N99402Ercoupe 415-C · S/N 2025N999UMUltramagic S A N-300 · S/N 300/136N9ABeech 35 · S/N D-523
Back to Queensbury, NY