OpenAirDocs.org
Purchase, NY

Registered aircraft · 75

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

N1013ABoeing 767-36N · S/N 30110Built 1999 · Andromeda Leasing I LLCN1049ABoeing 767-36N · S/N 30109Built 1999 · Andromeda Leasing II LLCN1093ABoeing 767-36N · S/N 30111Built 1999 · Andromeda Leasing II LLCN1181ABoeing 767-3Y0 · S/N 26206Msn 26206 LLCN1217ABoeing 767-375 · S/N 25865Built 1992 · Andromeda Leasing I LLCN121AEBell Textron Canada 505 · S/N 65605Built 2024 · Aea Aviation LLCN1229ABoeing 767-306 · S/N 28884Built 1999 · Andromeda Leasing I LLCN1321ABoeing 767-306 · S/N 27957Built 1995 · Andromeda Leasing I LLCN1327ABoeing 767-37D · S/N 26328Built 1996 · Msn 26328 LLCN1361ABoeing 767-31B · S/N 26265Built 1995 · Msn 26265 LLCN1373ABoeing 767-31K · S/N 27205Built 1994 · Msn 27205 LLCN1381ABoeing 767-316 · S/N 27615Built 1997 · Msn 27615 LLCN1399ABoeing 767-306 · S/N 27959Built 1996 · Andromeda Leasing I LLCN1409ABoeing 767-306 · S/N 27960Built 1996 · Msn 27959 LLCN1427ABoeing 767-306 · S/N 28098Built 1996 · Andromeda Leasing I LLCN1439ABoeing 767-33A · S/N 28495Built 1997 · Andromeda Leasing I LLCN1487ABoeing 767-31K · S/N 28865Built 1997 · Andromeda Leasing I LLCN1489ABoeing 767-31K · S/N 27206Built 1994 · Andromeda Leasing I LLCN1499ABoeing 767-328 · S/N 27428Built 1996 · Andromeda Leasing I LLCN1511ABoeing 767-383 · S/N 24318Built 1989 · Atlas Air IncN1619ABoeing 767-3Y0 · S/N 26208Built 1994 · Atlas Air IncN1709ABoeing 767-375 · S/N 24086Andromeda Leasing I LLCN17AVPiper PA-28-181 · S/N 28-8390078Built 1983 · Westchester Flying Club IncN18GNGulfstream Aerospace GV-SP (G550) · S/N 5180Built 2008 · Nair LLCN190FTPiper PA-28R-201 · S/N 28R-7837245Built 1978 · Westchester Flying Club IncN1997ABoeing 767-33A · S/N 27310Built 1994 · Andromeda Leasing II LLCN20SQBombardier BD-700-1A10 · S/N 9491Built 2012 · Flying Plane LLCN263SGBoeing 747-481 · S/N 29263Built 1999 · Atlas Air IncN275BMBeech V35 · S/N D-8196Built 1966 · Westchester Flying Club IncN322SGBoeing 747-481 · S/N 30322Built 2000 · Atlas Air IncN408MCBoeing 747-47UF · S/N 29261Built 1998 · Atlas Air IncN409MCBoeing 747-47UF · S/N 30558Built 2000 · Atlas Air IncN416MCBoeing 747-47UF · S/N 32838Built 2002 · Atlas Air IncN418MCBoeing 747-47UF · S/N 32840Built 2002 · Atlas Air IncN419MCBoeing 747-48EF · S/N 28367Atlas Air IncN429MCBoeing 747-481 · S/N 24833Built 1990 · Atlas Air IncN445MCBoeing 747-4B5F · S/N 33515Built 2003 · Atlas Air IncN446MCBoeing 747-4B5F · S/N 33517Built 2004 · Atlas Air IncN4508XPiper PA-28-181 · S/N 28-7690026Built 1975 · Westchester Flying Club IncN454PABoeing 747-46NF · S/N 30812Built 2002 · Atlas Air IncN464MCBoeing 747-446 · S/N 26341Built 1992 · Atlas Air IncN465MCBoeing 747-446 · S/N 24784Built 1990 · Atlas Air IncN472MCBoeing 747-45E · S/N 27062Built 1992 · Atlas Air IncN473MCBoeing 747-45E · S/N 27174Built 1993 · Atlas Air IncN475MCBoeing 747-47UF · S/N 29252Built 1998 · Atlas Air IncN476MCBoeing 747-47UF · S/N 29256Built 1999 · Atlas Air IncN477MCBoeing 747-47UF · S/N 29255Built 1998 · Atlas Air IncN480MCBoeing 747-422 · S/N 28812Built 1999 · Atlas Air IncN481MCBoeing 747-443 · S/N 32339Atlas Air IncN482MCBoeing 747-443 · S/N 32340Built 2001 · Atlas Air Inc
Back to Purchase, NY