Albany, GA

Cancelled registrations · 695

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 = 'GA' AND d.registrant_city = 'ALBANY'
  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.

N5530PThrush S2R-H80 · S/N H80-189DCCancelled Jan 3, 2017 · Exported to Australia · Built 2016 · Thrush Aircraft IncN6215UThrush S2R-T34 · S/N T34-444DCCancelled Jan 3, 2017 · Exported to Brazil · Built 2016 · Thrush Aircraft IncN55201Thrush S2R-T34 · S/N T34-449Cancelled Dec 21, 2016 · Exported to Argentina · Thrush Aircraft IncN62161Thrush S2R-H80 · S/N H80-187Cancelled Dec 15, 2016 · Exported to Argentina · Built 2016 · Thrush Aircraft IncN62162Thrush S2R-T34 · S/N T34-445Cancelled Nov 18, 2016 · Exported to Brazil · Built 2016 · Thrush Aircraft IncN6217GThrush S2R-T34 · S/N T34-446Cancelled Nov 10, 2016 · Exported to Guatemala · Thrush Aircraft IncN62166Thrush S2R-H80 · S/N H80-186Cancelled Nov 2, 2016 · Exported to Brazil · Built 2016 · Thrush Aircraft IncN6216BThrush S2R-T34 · S/N T34-442Cancelled Oct 6, 2016 · Exported to Brazil · Built 2016 · Thrush Aircraft IncN62164Thrush S2R-T34 · S/N T34-443Cancelled Sep 26, 2016 · Exported to Ecuador · Built 2016 · Thrush Aircraft IncN2913GCallair A-6 · S/N 268Cancelled Sep 14, 2016 · Sale reported, canceled · Built 1959N62152Thrush S2R-T34 · S/N T34-437DCCancelled Apr 7, 2016 · Exported to Philippines · Thrush Aircraft IncN6214QThrush S2R-T34 · S/N T34-441Cancelled Jan 27, 2016 · Exported to Brazil · Built 2015 · Thrush Aircraft IncN62150Thrush S2R-T34 · S/N T34-440Cancelled Jan 12, 2016 · Exported to Colombia · Built 2015 · Thrush Aircraft IncN62156Thrush S2R-H80 · S/N H80-174Cancelled Jan 5, 2016 · Exported to Brazil · Built 2015 · Thrush Aircraft IncN6214TThrush S2R-T34 · S/N T34-439Cancelled Jan 4, 2016 · Exported to Ecuador · Built 2015 · Thrush Aircraft IncN62155Thrush S2R-H80 · S/N H80-171DCCancelled Nov 18, 2015 · Exported to Brazil · Thrush Aircraft IncN6213TThrush S2R-H80 · S/N H80-169Cancelled Nov 13, 2015 · Exported to Argentina · Built 2015 · Thrush Aircraft IncN6215CThrush S2R-H80 · S/N H80-173Cancelled Nov 13, 2015 · Exported to Argentina · Built 2015 · Thrush Aircraft IncN6215LThrush S2R-T34 · S/N T34-436Cancelled Aug 3, 2015 · Exported to Guatemala · Built 2015 · Thrush Aircraft IncN6214EThrush S2R-T34 · S/N T34-431Cancelled Jul 31, 2015 · Exported to South Africa · Built 2015 · Thrush Aircraft IncN6211CThrush S2R-T34 · S/N T34-435Cancelled Jun 4, 2015 · Exported to Cameroon · Thrush Aircraft IncN6209HThrush S2R-H80 · S/N H80-166DCCancelled Mar 23, 2015 · Exported to Brazil · Built 2014 · Thrush Aircraft IncN6213XThrush S2R-H80 · S/N H80-164Cancelled Mar 12, 2015 · Exported to Ecuador · Built 2014 · Thrush Aircraft IncN62137Thrush S2R-T34 · S/N T34-430Cancelled Feb 11, 2015 · Exported to Ecuador · Thrush Aircraft IncN6209YThrush S2R-T34 · S/N T34-429Cancelled Feb 9, 2015 · Exported to Canada · Thrush Aircraft IncN6213DThrush S2R-T34 · S/N T34-433Cancelled Jan 30, 2015 · Exported to Panama · Thrush Aircraft IncN62091Thrush S2R-H80 · S/N H80-162Cancelled Jan 12, 2015 · Exported to Canada · Thrush Aircraft IncN6211EThrush S2R-H80 · S/N H80-159Cancelled Jan 9, 2015 · Exported to South Africa · Built 2014 · Thrush Aircraft IncN6208RThrush S2R-H80 · S/N H80-172Cancelled Dec 18, 2014 · Exported to Brazil · Built 2014 · Thrush Aircraft IncN62129Thrush S2R-H80 · S/N H80-152Cancelled Nov 21, 2014 · Exported to Brazil · Thrush Aircraft IncN62076Thrush S2R-H80 · S/N H80-157Cancelled Nov 17, 2014 · Exported to South Africa · Thrush Aircraft IncN62120Thrush S2R-T34 · S/N T34-427Cancelled Nov 17, 2014 · Exported to Argentina · Built 2014 · Thrush Aircraft IncN6485ZPiper PA-25-235 · S/N 25-2004Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1962 · Hailey Rodney J DBAN62068Thrush S2R-H80 · S/N H80-163DCCancelled Oct 10, 2014 · Exported to Brazil · Thrush Aircraft IncN62078Thrush S2R-H80 · S/N H80-160DCCancelled Oct 6, 2014 · Exported to Brazil · Built 2014 · Thrush Aircraft IncN6206YThrush S2R-H80 · S/N H80-158Cancelled Oct 2, 2014 · Exported to Uruguay · Built 2014 · Thrush Aircraft IncN9820BSchleicher Alexander K 7 · S/N 7082Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1963 · Sowega Soaring SocietyN6207ZThrush S2R-T34 · S/N T34-409Cancelled Sep 22, 2014 · Exported to Ecuador · Thrush Aircraft IncN62082Thrush S2R-H80 · S/N H80-161DCCancelled Jun 23, 2014 · Exported to San Marino · Thrush Aircraft IncN62036Thrush S2R-T34 · S/N T34-417Cancelled May 29, 2014 · Exported to Indonesia · Built 2013 · Thrush Aircraft IncN62038Thrush S2R-T34 · S/N T34-418Cancelled May 29, 2014 · Exported to Indonesia · Built 2013 · Thrush Aircraft IncN6214PThrush S2R-T34 · S/N T34-419Cancelled May 29, 2014 · Exported to Indonesia · Built 2013 · Thrush Aircraft IncN6206GThrush S2R-T34 · S/N T34-425Cancelled May 19, 2014 · Exported to Belize · Built 2014 · Thrush Aircraft IncN62080Thrush S2R-H80 · S/N H80-156DCCancelled May 16, 2014 · Exported to San Marino · Thrush Aircraft IncN6207LThrush S2R-H80 · S/N H80-147Cancelled May 9, 2014 · Exported to Brazil · Thrush Aircraft IncN30449Thrush S2R-H80 · S/N H80-126DCCancelled Apr 15, 2014 · Exported to China · Built 2013 · Thrush Aircraft IncN6203VThrush S2R-H80 · S/N H80-141DCCancelled Apr 15, 2014 · Exported to China · Built 2014 · Thrush Aircraft IncN62042Thrush S2R-H80 · S/N H80-148DCCancelled Apr 15, 2014 · Exported to China · Built 2014 · Thrush Aircraft IncN6204QThrush S2R-H80 · S/N H80-153DCCancelled Apr 11, 2014 · Exported to China · Thrush Aircraft IncN6204UThrush S2R-H80 · S/N H80-154DCCancelled Apr 11, 2014 · Exported to China · Thrush Aircraft Inc
Back to Albany, GA