OpenAirDocs.org
Staten Island, NY

Cancelled registrations · 62

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 = 'STATEN ISLAND'
  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.

N915ZZParadise USA PARADISE P-1 SLSA · S/N 0074Cancelled Apr 2, 2025 · Exported to Chile · Built 2009 · Kite Air LLCN250BXTextron G58 · S/N TH-2486Cancelled Aug 25, 2023 · Exported to Kyrgyzstan · Built 2017 · Kite Air LLCN4565WRockwell International 112TC · S/N 13055Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Abdelmalek George MN78308Cessna 172K · S/N 17257564Cancelled Jan 26, 2022 · Exported to Russia · Built 1968N734JFCessna 172N · S/N 17268884Cancelled Dec 29, 2021 · Sale reported · Built 1977N698ECDJI INSPIRE 1 · S/N W13DCK11051340Cancelled Jun 19, 2021 · Sale reported, canceledN111MECessna 500 · S/N 500-0146Cancelled May 11, 2021 · Exported to Russia · Built 1974 · Alpha Mike Bravo LLCN7150Draganfly Innovations GUARDIAN · S/N ECB17DCancelled Mar 6, 2021 · Registration expired, pending cancellation · Richmond County District Attorneys OfficeN3042WYakovlev YAK 52 · S/N 822209Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1982 · Svoysky SergeN37KCCessna 337D · S/N 337-1026Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1968 · Alpha & Omega Unlimited CorpN70477Piper J3C-65 · S/N 17479Cancelled Jan 24, 2020 · Revoked, canceled · Built 1946 · Staten Island Flg Svc IncN36756Stinson 10A · S/N 8167Cancelled Dec 27, 2019 · Revoked, canceled · Built 1941 · Saberg Frederick TN761KMDJI PHANTOM 2 · S/N PH636140738Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Milkie JosephN42665Piper J3C-65 · S/N 14959Cancelled Sep 5, 2019 · Revoked, canceled · Built 1945 · Staten Island Flg Svc IncN9725HHoward DGA-15P · S/N 743Cancelled Nov 20, 2018 · Revoked, canceled · Built 1943 · Patterson ArthurN3829KTemco GC-1B · S/N 3518Cancelled Sep 20, 2018 · Revoked, canceled · Built 1948 · Williams Irwin SN2229VCessna 140 · S/N 14460Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1948 · Spinner Christopher FN1849CCGS Hawk ARROW II · S/N H-AII-314-R503-TR1Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 2000 · Maiorani Gerald CN962SPCessna 172S · S/N 172S8164Cancelled Sep 14, 2017 · Third renewal notice · Built 1999 · Richmond Pilots CorpN89RGGreeley Ronald V KOLB TWINSTAR · S/N TS0028Cancelled May 11, 2015 · Sale reported, canceledN77DLMooney M20B · S/N 1839Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1961 · Cahill Francis JN57022Raven S55A · S/N S55A-605Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1979 · Murphy Richard JN314TMCessna 172N · S/N 17270052Cancelled Dec 30, 2013 · Third renewal notice · Built 1977 · Richmond Pilots Association IncN82YACessna T182T · S/N T18209044Cancelled Dec 3, 2013 · Exported to Turkey · Built 2011 · Danoks-Avia IncN3417ZPiper PA-22-150 · S/N 22-7329Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1960 · Norton Michael JN91711Bell 47G · S/N 1402Cancelled Jan 14, 2013 · Exported to Russia · Built 1953 · Spm Components & Support IncN7SGGarrett TAYLOR COOT · S/N L7Cancelled Oct 15, 2012 · Sale reported, pending cancellation · Built 1975N2730Bensen B-8m GYRO-COPTER · S/N 273Cancelled Sep 20, 2012 · Registration expired, pending cancellation · Built 1969 · Anastos GusN44395Taylorcraft BC12D-85 · S/N 10195Cancelled Jul 9, 2012 · Revoked, canceled · Built 1955 · Almerigotti John FN3487Bensen B-8M · S/N 11222Cancelled Aug 19, 2011 · Revoked, pending cancellation · Ledwon Werner JN1839EAeronca 7AC · S/N 7AC-5406Cancelled Jul 9, 2009 · Registration revoked · Built 1946 · Myerwold Arnold FN6214FCessna 172N · S/N 17273168Cancelled May 18, 2001 · Triennial form not returned · Harrington JohnN714KVCessna 150M · S/N 15079242Cancelled Apr 9, 1998 · Triennial form not returned · Richmond Pilots Assoicates IncN6553WPiper PA-28-140 · S/N 28-20633Cancelled May 9, 1975 · Richmond Pilots Associates IncN999DCBede BD-5 · S/N 1999Cancelled Feb 21, 1975 · Donald C ConhagenN6186Kowell JEANIE TEENIE 2 · S/N 5-10154Cancelled Oct 1, 1973 · Kowell PaulN1849Benson B-8D · S/N DC-1944Cancelled May 29, 1973 · Built 1971 · Coston DavidN1232VFairchild M-62A-3 · S/N FT-719Cancelled Nov 30, 1970 · Gerardi JosephN46000Aeronca 0-58B · S/N 2252Cancelled Jun 30, 1970 · Built 1945 · Civil Air Patrol IncN60295Stinson L-5 · S/N 42-98208Cancelled Jun 30, 1970 · Civil Air Patrol New York WingN6527DCessna 195 · S/N 7817Cancelled Jun 22, 1970 · U S ArmyN1384EAeronca 7AC · S/N 7AC-4945Cancelled May 25, 1965 · Frank V PuliaficoN6037KRepublic RC-3 · S/N 212Cancelled May 22, 1965 · Schwab Arthur LN4378BCessna 170B · S/N 26722Cancelled Jan 29, 1962 · Exported to Germany · Jaegar RodneyN87377Ercoupe 415-C · S/N 550Cancelled Mar 20, 1956 · Richmond Flying ServiceN72211Cessna 140 · S/N 9384Cancelled Mar 16, 1956 · Richmond Flying Service IncN18875Aeronca K · S/N K-135Cancelled Feb 20, 1956 · Edward SchaafN60479Cessna T-50 · S/N 5082Cancelled Feb 15, 1956 · Richmond Flying Service IncN46440Piper J3C-65 · S/N 10604Cancelled Nov 22, 1955 · Built 1943 · Richmond Flying Service IncN80742Globe GC-1A · S/N 145Cancelled Oct 25, 1955 · Built 1946 · Prignoli John
Back to Staten Island, NY