OpenAirDocs.org
Freeville, NY

Registered aircraft · 18

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 = 'FREEVILLE'
  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.

N1026Stinson SM-8A · S/N 4017Built 1930 · Bellamy John MarkN104AWWsk-Pzl Warzawa-Okecie PZL-104 WILGA 80 · S/N CF21940942Built 1994 · Bellamy Mark AN10SYMaule M-5-235C · S/N 7487CBellany Mark AN23095Air Tractor AT-301 · S/N 301-0356Built 1981 · Bellamy Mark AN284JWBeech V35B · S/N D-9495Built 1973 · Ordway JepsonN31WYAviat A-1C-180 · S/N 3108Built 2010 · Bellamy Mark AN3662XAero Commander S2R · S/N 1890RBuilt 1974 · Bellamy Mark AN4264JCessna 310R · S/N 310R0201Built 1975 · Bellamy Mark AN460ZSiai-Marchetti SM 1019 · S/N 029Built 1976 · Bellamy John MarkN5625ZPiper PA-22-108 · S/N 22-9437Built 1962 · Bellamy John MarkN5644XAero Commander S2R · S/N 1844RBuilt 1973 · Bellamy Mark AN5922ZPiper PA-22-108 · S/N 22-9791Built 1964 · Bellamy John MarkN81576Aeronca 7AC · S/N 7AC-195Built 1945 · Bellamy John-MarkN83369Aeronca 7AC · S/N 7AC-2036Bellamy John-MarkN8388KGrumman Acft ENG Cor-Schweizer G-164B · S/N 679BBellamy Mark AN9192CCessna 180 · S/N 31291Built 1955 · Bellamy Mark AN9753VCessna 188 · S/N 188-0203Built 1966 · Bellamy Mark AN97703Stinson 108 · S/N 108-703Built 1946 · Bellamy John Mark
Back to Freeville, NY