OpenAirDocs.org
Seaford, NY

Registered aircraft · 22

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

N144JKPiper PA-34-220T · S/N 34-8133010Built 1981 · Long Island Aviators LLCN2097SCessna 182T · S/N 18281308Built 2004 · Long Island Aviators LLCN21394Cessna 172S · S/N 172S10449Built 2007 · Long Island Aviators LLCN21412Piper PA-28-181 · S/N 28-7990045Built 1978 · Long Island Aviators LLCN522JWPiper PA-28-181 · S/N 2843461Built 2001 · Long Island Aviators LLCN5251RCessna 172M · S/N 17263465Long Island Aviators LLCN526ERCessna 172S · S/N 172S9110Built 2002 · Long Island Aviators LLCN5416BCessna 152 · S/N 15283867Long Island Aviators LLCN587MAPiper PA-28-181 · S/N 2843517Built 2002 · Long Island Aviators LLCN6059DCessna 172S · S/N 172S10275Built 2006 · Long Island Aviators LLCN6372CPiper PA-28R-201T · S/N 28R-7803223Built 1978 · Fair Skies LLCN65199Cessna 152 · S/N 15284323Built 1980 · Long Island Aviators LLCN723GAGrumman American Avn. GA-7 · S/N GA7-0021Built 1978 · Long Island Aviators LLCN727ACPiper PA-28-181 · S/N 28-7890128Built 1977 · Long Island Aviators LLCN733LYCessna 172N · S/N 17268386Built 1976 · Long Island Aviators LLCN75270Piper PA-28-151 · S/N 28-7615277Built 1976 · Long Island Aviators LLCN757ADCessna 152 · S/N 15279578Built 1977 · Long Island Aviators LLCN769GAGrumman American Avn. GA-7 · S/N GA7-0056Built 1978 · Long Island Aviators LLCN828YCessna 172N · S/N 17268168Built 1976 · Long Island Aviators LLCN935DEPiper PA-28-181 · S/N 28-7990146Built 1978 · Long Island Aviators LLCN9410VMooney M20C · S/N 700036Built 1969 · Rlangone IncN99709Cessna 172P · S/N 17276498Built 1985 · Long Island Aviators LLC
Back to Seaford, NY