OpenAirDocs.org
Watertown, NY

Cancelled registrations · 33

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

N245Cessna T337G · S/N P3370219Cancelled Dec 5, 2019 · Exported to Canada · Built 1975 · Walter A Minaert MdpcN28PPrentiss Gregory T SR GLASAIR III · S/N 3249Cancelled Apr 29, 2019 · Exported to Canada · Built 1999 · Chan Chui SN23939Aeronca 65-LA · S/N L5989Cancelled Mar 23, 2018 · Revoked, canceled · Built 1939 · Massey G DonaldN5813LAmerican AA-5 · S/N AA5-0013Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1971 · Davis James NN9501YAirframes Unlimited BIG DAWG · S/N TLG0206Cancelled Feb 16, 2018 · Third renewal notice · Built 2006 · Warner James AN8426JCessna 150G · S/N 15066326Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1967 · Richland Solo ClubN9680KUniversal Stinson 108-2 · S/N 108-2680Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1947 · Graham Bernard CN64282Boland MAY DAY · S/N 4Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1975 · Barbour Leslie HN5555UMierek Steven S QUICKSILVER MX II · S/N 1853Cancelled Apr 1, 2013 · Sale reported, canceledN6778HCessna 172M · S/N 17265578Cancelled Oct 31, 2012 · Triennial form not returned · Built 1975 · Rowe Gary EN122DGWilless James A CGS HAWK · S/N HSSC-907-HKS-TRICancelled May 19, 2008 · Triennial form not returned · Built 2003 · Graham DamienN39366Aeronca 65-TAF · S/N F4202TACancelled Jan 23, 2007 · Triennial form not returned · Mcwayne Frederick AN5452YCessna T210N · S/N 21064210Cancelled Sep 29, 2004 · Exported to Australia · Built 1980 · Mccabes Supply IncN8184Bensen B-8 · S/N T0053882Cancelled May 14, 2001 · Davis Jeffrey DN2143WBeech C23 · S/N M-1517Cancelled Nov 6, 1998 · Second triennial mailing, no response · Built 1974 · Oconnor Donald LN9024FHughes 369HE · S/N 1190215ECancelled Apr 9, 1991 · Exported to Canada · North Country Helicopter IncN4294RPiper PA-32-300 · S/N 32-40672Cancelled Jul 3, 1980 · Exported to Canada · Built 1969 · Smoothaire IncN9953RBeech B95 · S/N TD-384Cancelled May 28, 1976 · Dunaway-Morgan Co IncN7957LBeech A23-24 · S/N MA-138Cancelled Oct 29, 1974 · Exported to Canada · Parkview Auto Sales IncN30927Piper J3C-65 · S/N 5207Cancelled May 24, 1965 · Benson Flying Service IncN63QCessna 140A · S/N 15677Cancelled May 18, 1965 · Parr Dorothy YN87899Piper J3C-65 · S/N 15517Cancelled Aug 1, 1963 · Exported to Canada · Dumas Roy EN80872Globe GC-1B · S/N 275Cancelled Oct 10, 1958 · Exported to Canada · Crenshaw Thomas TN99358Ercoupe 415-C · S/N 1981Cancelled Apr 13, 1956 · Exported to Canada · Built 1946 · Crenshaw Thomas TN23405Piper J3L-65 · S/N 3133Cancelled Mar 18, 1955 · Built 1939 · Watson FloydN99722Erco 415-C · S/N 2345Cancelled Jun 26, 1950 · Benson Colgate Flying Service IncN99655Erco 415-C · S/N 2278Cancelled Jun 16, 1950 · Colgate Flying Service IncN33563Piper J3C-65 · S/N 14040Cancelled Jul 25, 1949 · Northern Air Services IncN6436KRepublic RC-3 · S/N 686Cancelled Aug 12, 1947 · Benson Flying Service IncN15071Piper E-2 · S/N 211Cancelled Jun 1, 1941 · Ward Walter & Gene W MillerN21008Aeronca K · S/N K-315Cancelled Jun 1, 1941 · Van Epps George AN12160Stinson W · S/N 3052Cancelled Jan 1, 1935 · Taylor Airways IncN8473Stinson SM-2AB · S/N 1078Cancelled Aug 4, 1931 · Atkinson Walter S
Back to Watertown, NY