OpenAirDocs.org
Alburgh, VT

Registered aircraft · 25

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N10548Cessna 150L · S/N 15074908Built 1973 · Scootair LLCN1069DCessna 195A · S/N 7681Built 1951 · Prescott ScotN16WHHoellerich STEEN SKYBOLT · S/N WH-1Prescott ScotN2100CCessna 195 · S/N 16085Built 1953 · Scootair LLCN3374DCessna 180 · S/N 32172Built 1955 · Scootair LLCN3450APiper PA-22-135 · S/N 22-1719Built 1953 · Scootair LLCN3493ZPiper PA-18 · S/N 18-7333Prescott Scot AN34PCessna 195 · S/N 7193Scootair LLCN355STCessna 195 · S/N 7285Built 1948 · Scootair LLCN36773Bellanca 7KCAB · S/N 395-73Scootair LLCN42697Piper J3C-65 · S/N 14993Built 1945 · Scootair LLCN4584HPiper PA-17 · S/N 17-9Built 1948 · Scootair LLCN4681MPiper PA-11 · S/N 11-190Built 1947 · Scootair LLCN5112DCessna 182A · S/N 51212Built 1958 · Scootair LLCN5644TCessna 172E · S/N 17251544Built 1964 · Scootair LLCN5715DPiper PA-22-150 · S/N 22-4411Scootair LLCN6577DCessna 195 · S/N 7847Scootair LLCN7148Tombolato MARQUART MA-5 · S/N MA-5-006Built 1971 · Prescott ScotN7472HPiper J3C-65 · S/N 20742Scootair LLCN75464Six Chuter SR7 XL · S/N SR7XL-2871Elkins Lyndol L JrN7582JPiper PA-28R-180 · S/N 28R-30932Johnsen Leif ErikN7797KPiper PA-20 · S/N 20-614Built 1951 · Scootair LLCN8500DPiper PA-22-160 · S/N 22-5727Built 1957 · Scootair LLCN88069Piper J3C-65 · S/N 15685Built 1946 · Scootair LLCN9395DPiper PA-18 · S/N 18-6671Built 1958 · Scoot Air LLC
Back to Alburgh, VT