OpenAirDocs.org
Niagara Falls, NY

Cancelled registrations · 56

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 = 'NIAGARA FALLS'
  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.

N919LJUav Factory PENGUIN C · S/N PNC0008Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Calspan CorpN617LELong-Ez No 617 LONG-EZE · S/N 617Cancelled Apr 13, 2021 · Non-citizen corporation, flight hours not reported · Built 1986 · Dreams Come Through IncN86202Aeronca 11AC · S/N 11AC7Cancelled Jan 16, 2021 · Revoked, canceled · Built 1946 · Niagara Airways IncN456NWNorth Wing Uum SPORT X2 · S/N LS7028Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Built 2014 · Operation Migration IncN38736Piper J3F-65 · S/N 7207Cancelled Jan 17, 2020 · Revoked, canceled · Built 1941 · Niagara Airways IncN503LCosmos PHASE II · S/N 8375Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Operation Migration USA IncN46038Aeronca 0-58B · S/N 058B11753Cancelled Jan 24, 2019 · Revoked, canceled · Built 1943 · Binkley WillisN37894Rearwin 8135 · S/N 913Cancelled Jul 19, 2018 · Revoked, canceled · Built 1942 · Hansen Jerald EN343REEdwards James R ASTRA · S/N A0500605HCancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 2008 · Edwards James RN3217LRaytheon 58 · S/N TH-1927Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1999 · Everair LLCN3586RBeech A23 · S/N M-767Cancelled May 3, 2017 · Revoked, pending cancellation · Built 1965 · Niagara Airways IncN588DBMcdonnell Douglas Helicopter 369E · S/N 0462ECancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1991 · Rainbow Helicopters IncN1589RLepczyk Kenneth M AIR COMMAND · S/N 1Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Lepczyk Kenneth MN6178KDowner REPUBLIC RC-3 · S/N 369Cancelled Aug 5, 2013 · Revoked, canceled · Built 1947 · Mehoff Aviation IncN6551KDowner REPUBLIC RC-3 · S/N 817Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1947 · Whitworth AviationN2662QCessna 150K · S/N 15071662Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1969N4926KRyan NAVION · S/N NAV41926Cancelled Aug 9, 2012 · Revoked, canceled · Built 1949 · Swimley Duane A LtN1088ZHughes 269C · S/N 511057Cancelled May 24, 2012 · Registration expired, pending cancellation · Built 1981 · Niagara Aviation Services IncN34681Stinson 10A · S/N 7981Cancelled May 24, 2012 · Revoked, canceled · Built 1941 · Hansen Jerald EN118MJBeech F90 · S/N LA-199Cancelled Apr 5, 2011 · Exported to Canada · Built 1982 · Everair LLCN2818BBell 47H-1 · S/N 1370Cancelled Jan 6, 2011 · Triennial form not returned · Built 1956 · Niagara Aerospace MuseumN50PLZaklady Lotnicze 3xtrim Spzoo 3XLS NAVIGATOR 600 · S/N E68.USCancelled Oct 26, 2009 · Exported to Canada · Built 2009 · 3xtrim IncN4268ABeech C-45H · S/N AF-762Cancelled Jul 27, 2009 · Registration revoked · Built 1952 · Dotterweich Frank JN221RVDinieri Steven DINIERI RV-6A · S/N 25459Cancelled Aug 20, 2008 · Exported to Australia · Built 2001 · Dinieri Georgena LN32287Raytheon B200 · S/N BB-1698Cancelled Dec 7, 2004 · Exported to France · Built 1999 · Everair LLCN7541JPiper PA-28R-180 · S/N 28R-30914Cancelled Nov 3, 2003 · Exported to Canada · Built 1968 · Niagara Air Parts IncN8026Pitts Aerobatics S-2B · S/N 5030Cancelled Mar 16, 2000 · Exported to South Africa · Volker Aviation IncN421RWCessna 421B · S/N 421B0397Cancelled Nov 4, 1998 · Exported to Canada · Contessa Leasing CorpN34660Stinson 10A · S/N 7960Cancelled Sep 22, 1987 · Exported to Canada · Chapman Bob CN46273Taylorcraft DCO-65 · S/N L-5546Cancelled Feb 5, 1987 · Aquino Richard Et AlN54713Raven S-50A · S/N S50A166Cancelled Feb 16, 1977 · Exported to Canada · Extrufix IncN46034Aeronca 0-58B · S/N 058B-9753Cancelled Aug 6, 1974 · 136th Aero ClubN8545Blake BENSEN B-8 · S/N BWB1Cancelled May 20, 1974 · Exported to Canada · Blake Wallace WN3940EAeronca 7BCM · S/N 7AC-7126Cancelled Dec 14, 1971 · Exported to Canada · T Dean Johnson JrN55250Cessna T-50 · S/N 5981Cancelled Dec 6, 1971 · Niagara Airways IncN3306PPiper PA-23-160 · S/N 23-1256Cancelled Dec 1, 1971 · Built 1958 · Airlanes Of Niagara IncN32620Piper J3C-65 · S/N 5496Cancelled Jul 3, 1967 · Exported to Canada · Bryant E MoxhamN97193Aeronca 0-58B · S/N 058B-6072Cancelled Jul 12, 1965 · Hafs Flying ClubN453WMonocoupe 90 · S/N 630Cancelled May 18, 1965 · Oscar A BowinN6021MStinson 108-3 · S/N 108-4021Cancelled Jul 8, 1960 · Exported to Canada · Built 1947 · Toohill T WN22672Taylorcraft BL-65 · S/N 1319Cancelled Oct 28, 1958 · Exported to Canada · Built 1939 · Stark Donald E JrN54084Consolidated Vultee BT-13A · S/N 5837Cancelled Nov 30, 1955 · Deramo WilliamN2388VCessna 140 · S/N 14628Cancelled Sep 5, 1951 · Sky Roamers IncN24963Piper J4A · S/N 4-772Cancelled Apr 25, 1951 · Built 1939 · Bowser AliceN2256KLuscombe 8A · S/N 4983Cancelled Mar 9, 1950 · Frontier Flyers IncN3556VCessna 140 · S/N 14831Cancelled Jun 16, 1949 · Sky Harbor Airways IncN9272HFairchild M-62A-3 · S/N FV-246Cancelled May 26, 1949 · Sky Harbor Airways IncN99943Ercoupe 415-C · S/N 2566Cancelled May 25, 1949 · Niagara Falls Aeronautical CorpN36884Aeronca 65-TAF · S/N F1951TACancelled Aug 30, 1948 · Built 1941 · Falls View Airways IncN24615Piper J4A · S/N 4-663Cancelled Jun 24, 1948 · R & H Flying Club Inc
Back to Niagara Falls, NY