OpenAirDocs.org
Syracuse, NY

Registered aircraft · 42

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

N118DDDominick D / Rotorway EXEC · S/N 0001Danna DominickN12755Cessna 305A · S/N 21931Real Aviation IncN1374QCessna 150L · S/N 15072674Adams Robert JN1765MCessna 182P · S/N 18264430Built 1975 · Flying Cow LLCN1853BBeech 95-B55 (T42A) · S/N TC-2420Built 1981 · Altius Aviation LLCN2076KLuscombe 8A · S/N 4803Built 1947 · Muhammad NaseemN21413Cessna 182T · S/N 18281273Built 2003 · Botwinick Jeffrey Richard PatrickN2401VDJI AGRAS T40 · S/N 1581F574B225300101EHVolatus Aerospace USA CorpN279LGPiper PA-28-236 · S/N 28-8611004Built 1986 · Altius Aviation LLCN312RKCirrus Design SR22T · S/N 1370Built 2016 · Rjk Air LLCN315RCRaytheon HAWKER 800XP · S/N 258480Built 2000 · Rocklyn National LLCN3195NCessna 140 · S/N 11007Built 1946 · Limpert Theodore HN350ATBombardier BD-100-1A10 · S/N 20795Built 2019 · Rmf Horizon LLCN3532ZPiper PA-22-150 · S/N 22-7437Built 1960 · Murphy Michael R TrusteeN399MDHelio H800 · S/N H-18Built 1984 · Rusyniak Anthony JohnN407SDBell 407 · S/N 53330Built 1999 · County Of OnondagaN4182HMooney M20J · S/N 24-0656Built 1978 · Air Superiority IncN4343RCessna 172M · S/N 17263096Built 1974 · Endless Sky Aviation IncN439CCRod Bower BOWER CC · S/N CCK-1865-0003Built 2013 · Rusyniak Spencer AN523GCTextron 525C · S/N 525C0383Built 2022 · Pfgc Air LLCN543EZLearjet 60 · S/N 225Built 2001 · Altius Aviation LLCN55449Piper PA-28-140 · S/N 28-7325406Built 1973 · Syracuse Flight School IncN60416Boeing A75 · S/N 75-240Built 1940 · Williams Samuel RN61260Piper PA-28R-201 · S/N 28R-7837255Built 1978 · Syracuse Flight School IncN6290WCessna P210N · S/N P21000742Built 1981 · Lord Of The Wings LLCN6518VFlying Basket FB3 · S/N 1596A34EC2EA733Volatus Aerospace US CorpN6519VFlying Basket FB3 · S/N 1596A34C5EB7389Volatus Aerospace US CorpN6780VMooney M20E · S/N 700061Built 1970 · Limpert Theodore HN684THCessna 510 · S/N 510-0067Built 2008 · Rjk Air LLCN70ZPiper PA-31-310 · S/N 31-357Built 1968 · Rusyniak Anthony JN713NGBell Helicopter Textron Canada 429 · S/N 57219Built 2014 · Niagara Mohawk Power Corp DBAN7144KMeech Bradley A MEECH BABY ACE MOD D · S/N 91-1Built 1996 · Meech Bradley AN734YMCessna 172N · S/N 17269221Built 1977 · Stockbridge Valley Flying Club IncN738ZYCessna 172N · S/N 17270377Registration pendingBuilt 1978N77657Fairchild 24R-46 · S/N R46316Built 1947 · Kahl William EN797HSHarmening HIGH FLYER · S/N 5853Built 2007 · Clarry Bradford DN817JVAviat A-1 · S/N 1283Built 1995 · Rusyniak Anthony JN8421UCessna 172F · S/N 17252321Sky Falcon LLCN844DKKennedy David E KIS CRUISER TR-4 · S/N 0002Built 2009 · Kennedy David EN8641VBellanca 8GCBC · S/N 163-75Built 1975 · Rusyniak Anthony JN918VACessna 172P · S/N 17274912Volatus Aerospace US CorpN9959RCessna U206G · S/N U20607000Built 1986 · Rusyniak Anthony J
Back to Syracuse, NY