OpenAirDocs.org
Rochester, NY

Registered aircraft · 176

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

N101RTPiper PA-28RT-201 · S/N 28R-8018009Built 1979 · Brodine Alan HN1062VAdams Balloon L D-S · S/N 064Magee Aviation Services LLCN107PAPiper PA-23-250 · S/N 27-7854002Pacific Fleet Aviation LLCN11721Bellanca 7KCAB · S/N 320-72Built 1972 · Yague-Martinez EloyN1221MLearjet 60 · S/N 209Built 2000 · Aviation Association LLCN126KCessna 172K · S/N 17257392Built 1968 · Wersinger DuncanN12789Cessna 172M · S/N 17262261Built 1973 · Marshall Frederic JN127SFIai GULFSTREAM G280 · S/N 2204Built 2020 · Constellation Leasing LLCN1294CCessna 177B · S/N 17702698Built 1977 · Jel Imaging Services LLCN12TFCirrus Design SR22T · S/N 1336Built 2016 · Bumblee Flight LLCN130WRDJI MAVIC 3 · S/N 1581F5FKD233W00D9X1TRochester Institute Of TechnologyN135MNSchweizer SGS 1-35 · S/N 45Built 1975 · Kuyt MichaelN137SFIai GULFSTREAM G280 · S/N 2178Built 2019 · Constellation Leasing LLCN14244Piper PA-23-250 · S/N 27-4796Built 1972 · Pacific Fleet Aviation LLCN1502Bombardier CL-600-2B16 · S/N 5830Built 2010 · Wegmans Food Markets IncN151BBConsolidated Aeronautics LAKE LA-4-200 · S/N 881Built 1978 · Black William MN1527JBalloon Works FIREFLY 7 · S/N 10996Sale reportedBuilt 1981N156DHLearjet 60 · S/N 091Built 1996 · Fs Sean Lee LLCN164BGBede BD-4 · S/N 164Vanhuben Daniel JamesN1715YPiper PA-23-250 · S/N 27-7654096Built 1976 · Pacific Fleet Aviation LLCN175FMPotez-Air FOUGA CM170 MAGISTER · S/N 256Kunze Karl WN17CEBeech B300 · S/N FL120Ldc Air LLCN1953XVans RV-12IS · S/N 121087Logghe Sean BN1976MCessna 182P · S/N 182-64331Jackling Eric SN199TCPiper PA-32R-301T · S/N 3257088Built 1999 · Stearns NathanielN1SYPiper PA-23-250 · S/N 27-7654186Pacific Fleet Aviation LLCN2005STaylorcraft F21 · S/N F-1002Built 1982 · Baker James WN207AWLearjet 60 · S/N 282Built 2005 · Hahn Automotive Fs LLCN2195LPiper PA-28RT-201 · S/N 28R-7918032Built 1979 · Ginsberg Andrew PN21DPPiper PA-23-250 · S/N 27-7854097Built 1978 · Pacific Fleet Aviation LLCN2202APiper PA-28-161 · S/N 28-7916102Built 1978 · Artisan Aviation IncN2218ZPiper PA-28RT-201 · S/N 28R-7918117Built 1979 · Artisan Aviation IncN222ZZGulfstream Aerospace GIV-X (G450) · S/N 4137Built 2008 · Missaglia Aviation LLCN229MDBell 206B · S/N 4293Built 1993 · Upstate Helicopter Services LLCN2323MPiper PA-23-250 · S/N 27-7954039Built 1979 · Pacific Fleet Aviation LLCN2352ZPiper PA-23-250 · S/N 27-8054022Built 1979 · Pacific Fleet Aviation LLCN2562MPiper PA-23-250 · S/N 27-7954078Built 1979 · Pacific Fleet Aviation LLCN25FTPiper PA-23-250 · S/N 27-7754038Built 1976 · Pacific Fleet Aviation LLCN25PKPiper PA-23-250 · S/N 27-7754105Built 1977 · Pacific Fleet Aviation LLCN26620Taylorcraft BF-65 · S/N 1962Built 1940 · Mcbride David JN268DSDiamond Aircraft Ind DA 40 · S/N 40.1143Built 2012 · Jaw Aviation LLCN289LRDJI AIR 3 · S/N 1581F6NBA237BML3RJ9JRochester Institute Of TechnologyN289TBDJI AIR 3 · S/N 1581F6NBA237BML3PG0YRochester Institute Of TechnologyN2QWPiper PA-23-250 · S/N 27-7754126Built 1977 · Pacific Fleet Aviation LLCN305BMMelton Morgan T ZODIAC 601 HDS · S/N MM020Marciano Charles ZN305DMFouga CM 170R MAGISTER · S/N FM-32East Coast Classic Jets IncN315NYPiper PA-23-250 · S/N 27-7754031Built 1977 · Pacific Fleet Aviation LLCN320KRReeves Matthew Charles LANCAIR 320 MK II · S/N 111091Built 2008 · Reeves Jesse LN3214TCessna 177 · S/N 17700514Built 1967 · Johnson Hugh SN324CCullison James B LANCAIR 320 · S/N 374-320-129Built 1999 · Ferris Ryan P
Back to Rochester, NY