OpenAirDocs.org
Rutland, VT

Registered aircraft · 23

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 = 'VT' AND g.registrant_city = 'RUTLAND'
  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.

N28636Fairchild 24W-40 · S/N W40-151Built 1940 · Natoli Nathaniel TN416HGSchempp-Hirth DISCUS CS · S/N 294 CSBuilt 2002 · Kelley Peter PN5278CBeech B35 · S/N D-2672Built 1951 · Moore LouisN5876ZPiper PA-22-108 · S/N 22-9736Built 1963 · Draper ScottN588AADJI PHANTOM 4 · S/N 07DDD5J0A10223Green Mountain Power CorpN7413DPiper PA-22-150 · S/N 22-5174Built 1957 · Draper ScottN7774MDJI PHANTOM 3 PROFESSION · S/N P76DCI11010755Green Mountain Power CorpN777QMDJI PHANTOM 3 PROFESSION · S/N P76DCL10011517Green Mountain Power CorpN778AGDJI PHANTOM 3 PROFESSION · S/N P76DCL11010617Green Mountain Power CorpN780CWRaytheon B200 · S/N BB-1924Casella Major Account Services LLCN7868GDJI PHANTOM 4 · S/N 07DDD4S0B11182Green Mountain Power CorpN7870GDJI PHANTOM 4 · S/N 07DDD5J0A11298Green Mountain Power CorpN787HGDJI PHANTOM 4 · S/N 07DDD5M0A10507Green Mountain Power CorpN787JGDJI PHANTOM 4 · S/N 07DDD5M0A10791Green Mountain Power CorpN787KGDJI PHANTOM 4 · S/N 07DDD590A10483Green Mountain Power CorpN787QGDJI PHANTOM 4 · S/N 07DDD560A10404Green Mountain Power CorpN787UGDJI PHANTOM 4 · S/N 07DDD5M0A11436Green Mountain Power CorpN787VGDJI PHANTOM 4 · S/N 07DDD5M0A11099Green Mountain Power CorpN787WGDJI PHANTOM 4 · S/N 07DDD5M0A10897Green Mountain Power CorpN787ZGDJI PHANTOM 4 · S/N 07DDD5L0A11089Green Mountain Power CorpN80938North American AT-6D · S/N 41-34702-2Built 1944 · Natoli Nathaniel TN9088UPiper PA-28-236 · S/N 28-8611008Built 1986 · Pennington Daniel WN9310ZNaval Aircraft Factory N3N-3 · S/N 2920Natoli Nathaniel T
Back to Rutland, VT