OpenAirDocs.org
Farmingdale, NY

Registered aircraft · 147

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

N1089DCessna 172S · S/N 172S10269Built 2006 · Heavy Metal Air LLCN1197QAmerican General Acft AG5B · S/N 10138Built 1992 · Smoke Seen LLCN1252LPipistrel D O O ALPHA TRAINER · S/N 1252 AT 912 LSABuilt 2024 · Heavy Metal Air LLCN1364JNorth American T-6G · S/N 53655Built 1951 · Snj-2 CorpN141AACessna 172S · S/N 172S10630Built 2007 · Heavy Metal Air LLCN142LHPiper PA-44-180 · S/N 4496177Built 2003 · Farmingdale State UniversityN144AMPiper PA-28-181 · S/N 28020016Built 2021 · Stardust Aviation LLCN148LHPiper PA-28-161 · S/N 2842191Built 2003 · Farmingdale State UniversityN149LHPiper PA-28-161 · S/N 2842192Built 2003 · Farmingdale State UniversityN150LHPiper PA-28-161 · S/N 2842193Built 2003 · Farmingdale State UniversityN1517ECessna 172N · S/N 17271031First renewal noticeBuilt 1978 · Heavy Metal Air LLCN151LHPiper PA-28-161 · S/N 2842194Built 2003 · Farmingdale State UniversityN152LHPiper PA-28-161 · S/N 2842195Built 2003 · Farmingdale State UniversityN153LHPiper PA-28-161 · S/N 2842196Built 2003 · Farmingdale State UniversityN155LHPiper PA-28-161 · S/N 2842197Built 2003 · Farmingdale State UniversityN156LHPiper PA-28-161 · S/N 2842198Built 2003 · Farmingdale State UniversityN156WJGulfstream Aerospace G-IV · S/N 1347Built 1998 · 156wj LLCN157LHPiper PA-28-161 · S/N 2842199Built 2003 · Farmingdale State UniversityN159LHPiper PA-28-161 · S/N 2842200Farmingdale State UniversityN15SJDouglas DC3C · S/N 33049Built 1944 · American Airpower Museum IncN162LHPiper PA-28-161 · S/N 2842361Built 2010 · Farmingdale State CollegeN163LHPiper PA-28-161 · S/N 2842362Built 2010 · Farmingdale State CollegeN166LHPiper PA-28-181 · S/N 2881373Built 2020 · Farmingdale State CollegeN1675HPiper PA-28-161 · S/N 28-7716040Built 1977 · Icarus Flying Academy LLCN1688LCessna 172S · S/N 172S10613Heavy Metal Air LLCN168LHPiper PA-28-181 · S/N 2881374Built 2020 · Farmingdale State CollegeN169LHPiper PA-28-181 · S/N 2881375Built 2020 · Farmingdale State CollegeN170LHPiper PA-28-181 · S/N 2881376Built 2020 · Farmingdale State CollegeN189BLCirrus Design SF50 · S/N 0278Built 2021 · Innovation Advisory Aviation IncN199JCAmerican Champion 8KCAB · S/N 1031-2006First renewal noticeBuilt 2006 · Heavy Metal Air LLCN205MSBeech C90 · S/N LJ-948Built 1981 · Justice Air IncN221APPipistrel D O O ALPHA TRAINER · S/N 1221 AT 912 LSABuilt 2024 · Heavy Metal Air LLCN2225DPiper PA-28-161 · S/N 28-7916152Built 1978 · Paphos Airways LLCN2277WBell 47G-3B-2 · S/N 6829Built 1971 · Sterling Lane Helicopters LLCN2280QPiper PA-28-161 · S/N 28-7716095Jaz One Holdings IncN234JSCessna A185F · S/N 18502956Built 1976 · Ocean Blue Aviation LLCN236ZKPiper PA-28-181 · S/N 2843401Maximum Ceiling Aviation LLCN246NDPiper PA-28-161 · S/N 2842056Built 1999 · Global Aviation CorpN25582Cessna 152 · S/N 15280746Built 1977 · Heavy Metal Air LLCN25646Douglas DC3A · S/N 2234Built 1941 · Justice Air IncN2634MPiper PA-28-161 · S/N 28-7816298Built 1977 · N2634mm LLCN264TMCirrus Design SR20 · S/N 10044Built 2024 · Four Seven Ventures LLCN26862North American AT-6D · S/N 90699American Airpower MuseumN29VPAero Vodochody L39C · S/N 031623Built 1980 · American Airpower Museum IncN301VRCessna 560XL · S/N 560-5301Built 2002 · Tonglen LLCN32EPCirrus Design SR22 · S/N 10801Built 2025 · Caravelle Aviation LLCN331MKPiper PA-28-181 · S/N 2843477Built 2001 · Stardust Aviation LLCN331SMCirrus Design SR22 · S/N 4630Built 2018 · Apex Aviation LLCN334ACPiper PA-28-161 · S/N 2842219Registration pendingBuilt 2005N337FBPiper PA-28-181 · S/N 2843550Built 2003 · Ma Aviation Group LLC
Back to Farmingdale, NY