OpenAirDocs.org
Utica, NY

Cancelled registrations · 50

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'NY' AND d.registrant_city = 'UTICA'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N690CSYuneec International TYPHOON Q500+ · S/N YU15141205B02B01Cancelled Mar 26, 2019 · Third renewal notice · City Of Utica Police DepartmentN22290Cessna 150H · S/N 15068196Cancelled Mar 16, 2019 · Registration pending, canceled · Built 1968N602EFDJI PHANTOM 2 VISION + · S/N PH645338075 V2.0Cancelled May 30, 2018 · Sale reported, canceledN69XWCessna 500 · S/N 500-0142Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1974 · Ritter Michael J DBAN658CFCanadair CL-600 CHALLENGER · S/N 1058Cancelled Mar 3, 2016 · Sale reported · Built 1982N5934YPiper PA-23-250 · S/N 27-3099Cancelled Mar 12, 2015 · Third renewal notice · Built 1965 · Uni Aire Aviation CorporationN59728Piper PA-31-350 · S/N 31-7652007Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1975 · Seco Leasing CorporationN88996Schempp-Hirth SHK1 · S/N 9Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1965 · Vescera RalphN44550Beech C18S · S/N 5862Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1944 · New Air Service IncN761MCCessna 210M · S/N 21062355Cancelled Feb 27, 2013 · Sale reported, pending cancellation · Built 1977N136FEBoeing 727-25C · S/N 19855Cancelled Aug 6, 2012 · Registration pending, canceled · Built 1968N930PPlungis Henry SNAPPY 1 · S/N 101Cancelled Aug 4, 2011 · Third renewal notice · Plungis Henry PN12726Kibiuk Theodore QUICKIE · S/N 508Cancelled Nov 23, 2004 · Sale reported · Built 1989N50302Fairchild M-62A · S/N T423196Cancelled Apr 17, 1991 · Triennial form not returned · New Air Service Inc DBAN7818MFairchild FH-227B · S/N 541Cancelled Jan 23, 1987 · Mohawk Airlines IncN46037Cessna 172I · S/N 17257005Cancelled Sep 16, 1985 · Administratively canceled · Marks FrankN2595XCessna P206 · S/N P206-0095Cancelled Aug 18, 1983 · Exported to Canada · Morse Aero IncN20ADBell 206A · S/N 347Cancelled Jun 12, 1980 · Exported to Canada · Built 1969 · Bob Morse Inc And Bratt Joseph F JrN8107TCessna 175B · S/N 17556807Cancelled Apr 21, 1980 · Exported to Canada · Polce Joseph JN7710KPiper PA-20 · S/N 20-531Cancelled May 27, 1975 · Exported to Canada · Tracy John AN51109Cessna 150J · S/N 15069773Cancelled Apr 8, 1974 · Pratt Thomas EN4067CStinson 108-3 · S/N 108-5067Cancelled Mar 20, 1972 · Exported to Canada · Johnson Roy MN96573Taylorcraft BC12-D · S/N 8873Cancelled Mar 30, 1971 · Exported to Canada · New-Air Service IncN1116JBritish BAC 1-11 204/AF · S/N 098Cancelled Mar 15, 1971 · Mohawk Airlines IncN92580Piper PA-12 · S/N 12-110Cancelled Jan 4, 1971 · Woch Edwin AlbinN1024CConvair 240 · S/N 16Cancelled Sep 18, 1970 · Mohawk Airlines IncN7811MFairchild FH-227 · S/N 531Cancelled Jun 25, 1970 · Mohawk Airlines IncN7530KPiper PA-18 · S/N 18-246Cancelled Nov 22, 1967 · Exported to Canada · Malara Patsy JrN92698Piper J3C-65 · S/N 17095Cancelled Mar 22, 1966 · Utica Aviation School IncN60225Cessna T-50 · S/N 5663Cancelled Jun 30, 1959 · Utica Aviation School IncN60470Consolidated Vultee BT-13A · S/N 6581Cancelled Mar 8, 1956 · Built 1942 · De Zee Jacque EN60046Consolidated Vultee BT-13 · S/N 79-1576Cancelled Feb 15, 1956 · Tocci LeeN51991Fairchild M-62A · S/N 42-3938Cancelled Dec 6, 1955 · Built 1943 · Bocchino Fred JN46172Fairchild M-62A · S/N T41-660Cancelled Nov 17, 1955 · Utica Aviation School IncN51388Cessna UC-78 · S/N 5033Cancelled Oct 20, 1955 · Dezee JacqueN2276HEngineering & Research ERCOUPE 415-C · S/N 2901Cancelled Oct 18, 1950 · Built 1946 · Edmund C. Richards & Son IncN88600Piper J3C-65 · S/N 16226Cancelled Apr 7, 1949 · Utica Aviation School IncN51672Fairchild M-62A · S/N T-42-1581Cancelled Feb 10, 1949 · Built 1942 · Utica Aviation School IncN2247MPiper J-3 · S/N 21037Cancelled Oct 5, 1948 · Utica Aviation School IncN27508Taylorcraft BL-65 · S/N 2150Cancelled Oct 5, 1948 · Utica Aviation School IncN88692Piper J3C-65 · S/N 16320Cancelled Oct 5, 1948 · Utica Aviation School IncN838VWaco RNF · S/N 3254Cancelled Feb 26, 1948 · Panella AlbertN2597KLuscombe 8A · S/N 5324Cancelled Sep 22, 1947 · Hughes Gwilym RN25832Piper J3C-65 · S/N 3787Cancelled Feb 22, 1943 · Marcy Flying Service IncN23498Piper J4A · S/N 4-628Cancelled Aug 1, 1941 · Cook Forrest LN12144Stinson W · S/N 3053Cancelled May 1, 1940 · Built 1931 · Argyle Tutwiler WrightN536VWedell - Williams 92 · S/N 104Cancelled Mar 1, 1939 · Wright John HN587MMoth 60-GM · S/N 88Cancelled Jul 1, 1931 · Built 1929 · Utica Flying Service IncN417KFleet 2 · S/N 140Cancelled Sep 26, 1930 · Wright John HN6709Alexander COMBINATION EAGLEROC · S/N 542Cancelled Mar 5, 1929 · Built 1928 · Utica Flying Service Inc
Back to Utica, NY