OpenAirDocs.org
Dunedin, FL

Cancelled registrations · 61

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 = 'FL' AND d.registrant_city = 'DUNEDIN'
  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.

N344TPiper PA-31-350 · S/N 31-7952013Cancelled Oct 14, 2021 · Exported to Philippines · Built 1978 · Island Bound LLCN32LUCessna 172R · S/N 17281263Cancelled Dec 22, 2020 · Exported to Ecuador · Built 2005 · Island Bound LLCN511ERCessna 172S · S/N 172S8918Cancelled May 21, 2020 · Exported to Uganda · Built 2001 · Island Bound LLCN49399Cessna 152 · S/N 15281237Cancelled Jan 6, 2020 · Exported to Philippines · Built 1978 · Island Bound LLCN68001Cessna 152 · S/N 15282131Cancelled Jan 6, 2020 · Exported to Philippines · Built 1978 · Island Bound LLCN2143XCessna 172S · S/N 172S9526Cancelled Dec 2, 2019 · Exported to Philippines · Island Bound LLCN53151Cessna 172S · S/N 172S9293Cancelled May 29, 2019 · Exported to Philippines · Built 2003 · Island Bound LLCN53210Cessna 172S · S/N 172S9309Cancelled May 29, 2019 · Exported to Philippines · Island Bound LLCN65218Cessna 172S · S/N 172S9688Cancelled May 29, 2019 · Exported to Philippines · Built 2004 · Island Bound LLCN65680Cessna 172S · S/N 172S9743Cancelled May 29, 2019 · Exported to Philippines · Built 2004 · Island Bound LLCN952FACessna 172S · S/N 172S9522Cancelled Mar 22, 2019 · Exported to Philippines · Built 2003N5204ACessna 172S · S/N 172S9101Cancelled Mar 19, 2019 · Exported to Philippines · Built 2002 · Island Bound LLCN35549Cessna 172S · S/N 172S8957Cancelled Mar 5, 2019 · Exported to Philippines · Built 2001 · Island Bound LLCN378FACessna 172S · S/N 172S9378Cancelled Mar 5, 2019 · Exported to Philippines · Built 2003 · Island Bound LLCN440ESCessna 172R · S/N 17280330Cancelled Mar 4, 2019 · Exported to Panama · Built 1998 · Island Bound LLCN21693Cessna 172S · S/N 172S9650Cancelled Feb 12, 2019 · Exported to Thailand · Built 2004 · Island Bound LLCN151CSDJI PHANTOM 3 ADVANCED · S/N P76DCD25010739Cancelled Feb 9, 2019 · Registration expired, pending cancellation · Smith Christopher AN113SFCessna 172S · S/N 172S8761Cancelled Aug 27, 2018 · Exported to Philippines · Built 2001 · Island Bound LLCN817SPCessna 172S · S/N 172S8733Cancelled Aug 24, 2018 · Exported to Philippines · Built 2001 · Island Bound LLCN64572Cessna 172P · S/N 17275584Cancelled Jul 9, 2018 · Exported to Philippines · Built 1982 · Island Bound LLCN966JACessna 172S · S/N 172S10567Cancelled May 14, 2018 · Exported to Canada · Built 2007 · Island Bound LLCN53095Cessna 172S · S/N 172S9275Cancelled Feb 26, 2018 · Exported to Philippines · Built 2002 · Island Bound LLCN75347Young Marc MX II · S/N MY0621Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Young MarcN185SQM-Squared SPRINT 1000 · S/N 0554Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 2001 · Young Mark JN2766NBell 206B · S/N 2746Cancelled Mar 6, 2017 · Registration expired, pending cancellation · World Aircraft Connection IncN150UDCessna 172R · S/N 17281187Cancelled Jul 20, 2016 · Exported to Pakistan · Built 2003 · Island Bound LLCN158SKCessna 152 · S/N 15284947Cancelled Jul 1, 2016 · Exported to Pakistan · Built 1981 · Island Bound LLCN1154DCessna 172S · S/N 172S10341Cancelled Jun 10, 2016 · Exported to Ecuador · Built 2006 · Island Bound LLCN442ESCessna 172R · S/N 17280350Cancelled Nov 19, 2015 · Exported to South Korea · Built 1998 · Island Bound LLCN1576CCessna 172R · S/N 17281388Cancelled Jul 27, 2015 · Exported to Pakistan · Built 2007 · Island Bound LLCN24339Cessna 172R · S/N 17280811Cancelled Jul 27, 2015 · Exported to Pakistan · Built 1999 · Island Bound LLCN15HCBell/Avery Rodger 206A/OH58A · S/N 7120786ACancelled May 18, 2015 · Registration expired, pending cancellation · Celler HerbertN71847Luscombe 8A · S/N 3274Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1946 · Byrd George LN5065FFairchild Hiller FH-1100 · S/N 206Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1971 · Ela Investments IncN1401TCessna 172S · S/N 172S9884Cancelled Apr 7, 2014 · Exported to Chile · Built 2005 · Island Bound LLCN426CDCessna 182T · S/N 18281959Cancelled Mar 28, 2014 · Exported to Belarus · Built 2007 · Island Bound LLCN53570Cessna 172S · S/N 172S9397Cancelled Feb 18, 2014 · Exported to Chile · Built 2003 · Island Bound LLCN1855YCessna 172S · S/N 172S9924Cancelled Dec 30, 2013 · Exported to New Zealand · Built 2005 · Island Bound LLCN2328UCessna 172S · S/N 172S9990Cancelled Dec 30, 2013 · Exported to New Zealand · Built 2005 · Island Bound LLCN39HMPiper PA-28-180 · S/N 28-1290Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1963 · Mccabe John PN3220EBell 206B · S/N 845Cancelled May 6, 2013 · Registration expired, pending cancellation · World Aircraft Connection IncN20VWKalishek Christopher J SONERAI 1 · S/N 00261Cancelled May 3, 2013 · Registration expired, pending cancellation · Kalishek Christopher JN37ACFlug & Fahrzeugwerke FFA HBV-DIAMANT 16.5 · S/N 049Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 1968 · O'Brien KevinN65357Cessna 172S · S/N 172S9705Cancelled Sep 17, 2012 · Exported to South Korea · Built 2004 · Island Bound LLCN157LLPiper PA-42 · S/N 42-8001058Cancelled Jul 31, 2012 · Exported to Mexico · Built 1981 · Island Bound LLCN1438HCessna 172S · S/N 172S10685Cancelled May 9, 2012 · Exported to Brazil · Built 2008 · Island Bound LLCN36GKCessna 172S · S/N 172S9917Cancelled Feb 9, 2012 · Exported to Indonesia · Built 2005 · Island Bound LLCN1242CCessna 172S · S/N 172S10308Cancelled Oct 28, 2011 · Exported to Indonesia · Built 2006 · Island Bound LLCN91PRCessna 172S · S/N 172S10366Cancelled Oct 28, 2011 · Exported to Indonesia · Built 2006 · Island Bound LLCN5286ACessna 172S · S/N 172S9218Cancelled Aug 23, 2011 · Exported to Mexico · Built 2002 · Island Bound LLC
Back to Dunedin, FL