OpenAirDocs.org
Hudson, NY

Registered aircraft · 28

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

N1085LConsolidated Aeronautics LAKE LA-4-200 · S/N 678Northeast Cub LLCN130BTConsolidated Vultee BT-13A · S/N 1891Built 1941 · Yandik Stephen EN13787Boeing A75 · S/N 75-3141Built 1942 · Yandik Stephen EN18737Cessna 150L · S/N 15074075Built 1972 · Giamichael Thomas CN2619KLuscombe 8E · S/N 5346Northeast Cub LLCN2999UCessna 172E · S/N 17250599Built 1963 · Richmor Aviation IncN33559Piper J3C-65 · S/N 14036Built 1945 · Hutman Stephen L JrN3567KPiper J3C-65 · S/N 22258Built 1946 · Yandik Stephen EN38822Piper J3F-65 · S/N 7308Built 1941 · Yandik Stephen EN41095Piper J3L-65 · S/N 7704Built 1941 · Yandik Stephen EN41CKNorth American AT-6D · S/N 889967Yandik Stephen EN4224URaven S55A · S/N S55A-1034Built 1984 · Barber RussellN5088LCessna 152 · S/N 15284254Built 1980 · Richmor Aviation IncN5233ECessna 172N · S/N 17271786Built 1978 · Richmor Aviation IncN5357HCessna 152 · S/N 15284092Built 1979 · Richmor Aviation IncN5394BCessna 152 · S/N 15283859Built 1979 · Richmor Aviation IncN5404BCessna 152 · S/N 15283862Built 1979 · Richmor Aviation IncN5855HPiper PA-16 · S/N 16-473Northeast Cub LLCN588FCHawker Beechcraft HAWKER 900XP · S/N HA-0193Built 2011 · Juno Aviation II LLCN63356Stinson L-5G · S/N 4627Yandik Stephen EN66531Stinson L-5 · S/N 42-15025Built 1943 · Yandik Stephen EN68920Cessna 152 · S/N 15282403Built 1978 · Richmor Aviation IncN757URCessna 152 · S/N 15280018Built 1977 · Richmor Aviation IncN777MTMooney M20K · S/N 25-0418Built 1980 · Northeast Cub LLCN8370RPiper PA-28-140 · S/N 28-22247Built 1966 · Yandik Stephen E JrN93529Cessna 152 · S/N 15285510Built 1982 · Richmor Aviation IncN94570Cessna 152 · S/N 15285732Built 1983 · Richmor Aviation IncN95KKBeech D95A · S/N TD-649Built 1966 · Grimes Chris
Back to Hudson, NY