OpenAirDocs.org
Ithaca, NY

Cancelled registrations · 48

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

N6082XSharretts Fred A II · S/N 513Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Binder Douglas BN1881QDassault-Breguet FALCON 20 · S/N 414Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1979 · Taughannock Aviation CorporationN954HRaytheon Corporate Jets HAWKER 800 · S/N 258259Cancelled Feb 4, 2022 · Second renewal notice · Built 1994 · Brbf IncN541XCPrecision Hawk USA LANCASTER MK III · S/N 14HE03041Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Corell Cooperative ExtensionN541YCPrecision Hawk USA LANCASTER MK III · S/N 14HE03020Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Cornell Cooperative ExtensionN8617CPiper PA-22-135 · S/N 22-1299Cancelled Jan 16, 2021 · Revoked, canceled · Built 1953 · Besemer Irene JoyceN205VADJI PHANTOM 4 PRO · S/N 07DDD4N0B10077Cancelled Apr 2, 2020 · Third renewal notice · Vertical Access LLCN579CUDJI PHANTOM 2 · S/N PH646018367 V2.0Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Cornell UniversityN788UCDJI PHANTOM 2 VISION + · S/N PH645359270 V2.0Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Cornell UniversityN788VCDJI PHANTOM 2 VISION + · S/N PH645319809 V2.0Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Cornell UniversityN3044EAeronca 7AC · S/N 7AC-6630Cancelled Nov 4, 2019 · Revoked, pending cancellation · Built 1946 · Sonn William LN687XG3D Robotics X8+ · S/N X815032390010Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Gore Michael AN543XG3D Robotics IRIS+ · S/N IRS1433700007Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Gore Michael AN4344KRyan NAVION · S/N NAV-4-1344Cancelled Jun 19, 2018 · Exported to Guatemala · Built 1948 · Llarena Carlos AN2060XCessna 182H · S/N 18256160Cancelled Aug 2, 2017 · Exported to Guatemala · Built 1965 · Llarena Carlos AntonioN8097UJuber Jeff RAF 2000 · S/N H2-94-5-145Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Juber Jeff JN7537DPiper PA-22-150 · S/N 22-5267Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Hayes Allen WN9450QBeech C90 · S/N LJ-550Cancelled May 7, 2015 · Exported to Guatemala · Built 1972 · Llarena CarlosN143SGSoko GALEB G-2 · S/N FVS-G23-143Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1967 · Recycled Rimu IncN28687Fairchild M-62A · S/N T40-416Cancelled Dec 22, 2014 · Revoked, canceled · Built 1941 · Ithaca Flg Svc IncN6898ZPiper PA-60-602P · S/N 60-8265011Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Syme James WN42093Piper J3C-65 · S/N 14320Cancelled Jun 12, 2012 · Revoked, canceled · Built 1945 · Mason EugeneN10958Cessna 150L · S/N 15075168Cancelled Jul 19, 2011 · Sale reported, canceled · Built 1973N8175YPiper PA-30 · S/N 30-1290Cancelled Jul 28, 2009 · Exported to Canada · Built 1966 · Barney John CN3124TIverson-Clayton THORP T-18 · S/N 1051Cancelled Jun 14, 2006 · Exported to South Africa · Built 1979N80235Cessna 152 · S/N 15285358Cancelled May 29, 1997 · Triennial form not returned · East Hill Flying Club IncN85820Aeronca 11AC · S/N 11AC-232Cancelled Dec 17, 1981 · Lange William A JrN27535Piper PA-31-350 · S/N 31-7852051Cancelled Dec 20, 1978 · Exported to United Kingdom · Chartair IncN9296YPiper PA-31-310 · S/N 31-392Cancelled Mar 25, 1977 · Exported to Morocco · Cayuga RealtyN1355HAeronca 15AC · S/N 15AC-402Cancelled Dec 1, 1976 · Exported to Canada · Madison Deane FN3342RCessna 182L · S/N 18258642Cancelled May 12, 1975 · East Hill Flying Club IncN7345YPiper PA-30 · S/N 30-396Cancelled Feb 19, 1974 · Barney John CN98073Piper J3C-65 · S/N 18224Cancelled Jun 30, 1970 · Graduate Aero School PilotsN22518Stinson HW75 · S/N 7089Cancelled Jun 8, 1970 · Raymond F GrundN83924Aeronca 7AC · S/N 7AC-2607Cancelled Jun 5, 1965 · East Hill Flying Club IncN30739Piper J3F-65 · S/N 5078Cancelled May 26, 1965 · Built 1940 · Ithaca Flying Service IncN41092Piper J3F-65 · S/N 7745Cancelled May 26, 1965 · Built 1941 · Ithaca Flying Service IncN41564Piper J3F-65 · S/N 9056Cancelled May 26, 1965 · Ithaca Flying Svc IncN41832Fairchild M-62A · S/N T41-1153Cancelled May 25, 1965 · Ithaca Flying Service IncN1103VGrumman F6F-5 · S/N 70-911Cancelled Sep 24, 1959 · Cornell UniversityN4028KNorth American NAVION A · S/N NAV-4-1028Cancelled Oct 4, 1955 · Ithaca Flying Service IncN18936Douglas DC3-G103A · S/N 2011Cancelled Oct 31, 1950 · Built 1937 · Robinson Airlines CorpN23337Piper J3F-60 · S/N 3083Cancelled Jun 14, 1949 · Donald Craston Van Pelt JrN80384Beech D18S · S/N A-284Cancelled Nov 12, 1948 · Exported to Mexico · Built 1946 · Robinson Airlines CorpN606YWaco RNF · S/N 3330Cancelled Jul 12, 1948 · Ithaca Flying Service IncN12134Stinson R-3 · S/N 669Cancelled Jun 1, 1941 · Ithaca Flying Service IncN198KMonocoupe 90 · S/N 532Cancelled Sep 2, 1935 · Alan AustenN97Morse Thomas SCOUT · S/N 2Cancelled Oct 24, 1933 · Built 1917 · Thomas-Morse Aircraft Corp
Back to Ithaca, NY