Wurtsboro, NY
Registered aircraft · 25
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 = 'WURTSBORO' 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 = 'WURTSBORO' 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.
N103TGBurkhart Grob G 103 TWIN II · S/N 3829N1080Chuck Cavanaugh SEAREY LSX · S/N 1LK579CN1135SSchweizer SGS 1-26E · S/N 515N1652GChampion 7GCBC · S/N 122N17ZZSchleicher ASW-20C · S/N 20807N1837Cessna Ector 305A · S/N 2009N2656HSchweizer SGS 2-33A · S/N 436N2727BSchleicher ASW-27 · S/N 27137N28407Richard D Sukey QUICKSILVER SPORT 2S · S/N 0307N29QVAlexander Schleicher ASW 27-18 E · S/N 29671N3005TPiper PA-28-161 · S/N 28-7916384N307BGBurkhart Grob G-103A TWIN II ACRO · S/N 34032-K-264N33898Schweizer SGS 1-26E · S/N 628N33BFS.O.C.A.T.A. MS894A · S/N 11720N47WWHawker Beechcraft G36 · S/N E-3963N521SLSchleicher ASK-21 · S/N 21809N5779PPiper PA-24 · S/N 24-858N6021PBeech C24R · S/N MC-657N65828Schweizer SGS 2-33A · S/N 325N66RMLamborn R/Lamborn J ROTORWAY EXEC 90 · S/N 3225N7137VMooney M20E · S/N 21-0046N7721GCessna 172L · S/N 17259421N80953Globe GC-1B · S/N 1146N942GAlexander Schleicher ASW 27-18 · S/N 29043N9593EAeronca 11AC · S/N 11AC-1224
Back to Wurtsboro, NY