OpenAirDocs.org
Canandaigua, NY

Registered aircraft · 53

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

N10983Bellanca 7ACA · S/N 42-72Built 1971 · Blakesley Eric RN1337RGrumman American Avn. AA-5 · S/N AA5-0737Built 1975 · Zimmerman Christopher PaulN15703Piper PA-28-180 · S/N 28-7305125First renewal noticeBuilt 1972 · Schubert Brothers Aviation IncN165LHPiper PA-28R-201 · S/N 2844144Built 2011 · Rochester Air Center LLCN18SNPiper PA-18-135 · S/N 18-3966Built 1955 · Smiley Stephen PN1928VCessna 140 · S/N 14128Built 1947 · Schubert Christopher PN196ZPParis Jeffrey J ZNITH ZODIAC CH601XL · S/N 6-4839Built 2005 · Osterman Forrest JN199EECirrus Design SR22T · S/N 1091Built 2015 · Clk Aviation LLCN214RAPiper PA-28-181 · S/N 28-7690440Built 1976 · Jw Aero Holdings IncN2174CCessna 195B · S/N 16159Built 1954 · Canandaigua Air Center LLCN225RACessna 172S · S/N 172S9803Built 2005 · Rochester Air Center LLCN2441NBaron George A EAA BIPLANE P-2 · S/N 1Bills Ricky EN2525XCessna T210M · S/N 21061803Built 1977 · Tolbert Mark AN262GMCirrus Design SR20 · S/N 1129Rochester Air Center LLCN2729UCessna 172D · S/N 17250329Built 1963 · Denair IncN292CCCub Crafters CC19-215 · S/N CC19-0074Built 2023 · Raine & Roses LLCN3032MPiper PA-12 · S/N 12-1725Built 1947 · Moore Timothy JN314RACessna 172R · S/N 17280489Built 1998 · Rochester Air Center LLCN319MCAgustawestland Philadelphia AW119MKII · S/N 15018Built 2022 · Mercy Flight Central Holding LLCN34191Cessna 177B · S/N 17701689Built 1971 · Cliff Air LLCN36647Aeronca 65-CA · S/N C17361Built 1941 · Green BenjaminN3690NBeech A36TC · S/N EA-123Built 1980 · Detraglia Michael CN3886FGodwin Bill C CONDOR III · S/N 0001Pederson Karl RN3912FDJI AGRAS T50 · S/N 1581F6BUB2481001877CFly The Farm Drone Services LLCN4352DPiper PA-28-161 · S/N 28-8416073Built 1984 · Ashdown AdrianN46525Cessna 172K · S/N 17257326Built 1968 · Yarnall Paul JN468ESCessna 650 · S/N 650-0185Built 1990 · Air Roc Group LLCN49RPPiper PA-18-150 · S/N 187909059Smiley Stephen PN50CTCessna T210M · S/N 21062937Built 1978 · Ayers Jeffrey DN511RTCirrus Design SR20 · S/N 2018Built 2009 · Rochester Air Center LLCN6006HPiper J3C-65 · S/N 19141Built 1946 · Mincer Robert BN651MCAgustawestland Philadelphia AW119MKII · S/N 15021Built 2023 · Mercy Flight Central Holding LLCN65993Boeing B75N1 · S/N 75-7273Mincer Robert BN6687FCessna 150F · S/N 15063287Blakesley Eric RN712MCAgustawestland Philadelphia AW119MKII · S/N 15008Built 2022 · Mercy Flight Central Holding LLCN7144CAerostar International RX 8 · S/N RX8-3240Built 1995 · Oliver James BN71854Luscombe 8A · S/N 3281Built 1946 · Wings N Nuts IncN7582FChampion 7ECA · S/N 738-70Cassano Graham SN787WAPiper PA-34-200T · S/N 348070057Built 1980 · Jw Aero Holdings IncN810MCAgustawestland Philadelphia AW119MKII · S/N 15022Built 2023 · Mercy Flight Central Holding LLCN8139VCirrus Design SR22 · S/N 0685Built 2003 · Ayers SamuelN816RACessna 172N · S/N 17272388Built 1979 · Rochester Air Center LLCN822EAHawker Beechcraft G58 · S/N TH-2228Built 2008 · Fields Construction & Excavating IncN86114Aeronca 11AC · S/N 11AC-542Built 1946 · Bills Ricky EN86152Aeronca 11AC · S/N 11AC-583Built 1946 · Bills Ricky EN88070Piper J3C-65 · S/N 15686Moore Paul AN88VVBeechcraft G36 · S/N E-4037Built 2014 · Grossglockner IncN904RACessna 172M · S/N 17267060Built 1976 · Jw Aero Holdings IncN909RAPiper PA-34-200T · S/N 34-7770069Built 1976 · Jw Aero Holdings IncN922RACessna 182P · S/N 18262609Built 1973 · Schubert Brothers Aviation Inc
Back to Canandaigua, NY