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.

N837KHThrush S2R-T660 · S/N T660P-213DCCancelled Dec 4, 2020 · Expired dealer · Thrush Aircraft IncN838KHThrush S2R-T660 · S/N T660P-214DCCancelled Dec 4, 2020 · Expired dealer · Thrush Aircraft IncN839KHThrush S2R-T660 · S/N T660P-215DCCancelled Dec 4, 2020 · Expired dealer · Thrush Aircraft IncN840KHThrush S2R-T660 · S/N T660P-216DCCancelled Dec 4, 2020 · Expired dealer · Thrush Aircraft IncN841KHThrush S2R-T660 · S/N T660P-217DCCancelled Dec 4, 2020 · Expired dealer · Thrush Aircraft IncN842KHThrush S2R-T660 · S/N T660P-218DCCancelled Dec 4, 2020 · Expired dealer · Thrush Aircraft IncN844KHThrush S2R-T660 · S/N T660P-221DCCancelled Dec 4, 2020 · Expired dealer · Thrush Aircraft IncN846KHThrush S2R-T660 · S/N T660P-219DCCancelled Dec 4, 2020 · Expired dealer · Thrush Aircraft IncN847KHThrush S2R-T660 · S/N T660P-220DCCancelled Dec 4, 2020 · Expired dealer · Thrush Aircraft IncN849KHThrush S2R-T660 · S/N T660P-222DCCancelled Dec 4, 2020 · Expired dealer · Thrush Aircraft IncN851KHThrush S2R-T660 · S/N T660P-223DCCancelled Dec 4, 2020 · Expired dealer · Thrush Aircraft IncN852KHThrush S2R-T660 · S/N T660P-224DCCancelled Dec 4, 2020 · Expired dealer · Thrush Aircraft IncN5113VThrush S2R-T660 · S/N T660-148Cancelled Nov 9, 2020 · Exported to Spain · Thrush Aircraft LLCN5114VThrush S2R-T34 · S/N T34-508Cancelled Oct 8, 2020 · Exported to Ecuador · Thrush Aircraft LLCN51051Thrush S2R-T34 · S/N T34-507Cancelled Aug 31, 2020 · Exported to Ecuador · Built 2020 · Thrush Aircraft LLCN51125Thrush S2R-T660 · S/N T660-147Cancelled Aug 12, 2020 · Exported to Spain · Thrush Aircraft LLCN5102VThrush S2R-T34 · S/N T34-504Cancelled Aug 3, 2020 · Exported to Ecuador · Built 2020 · Thrush Aircraft LLCN5111FThrush S2R-T660 · S/N T660-146DCCancelled Jul 7, 2020 · Exported to Spain · Thrush Aircraft LLCN705MCThrush S2R-T34 · S/N T34-500DCCancelled Jun 12, 2020 · Exported to Spain · Thrush Aircraft LLCN51086Thrush S2R-T660 · S/N T660-145Cancelled Jun 2, 2020 · Exported to Spain · Thrush Aircraft LLCN1006HThrush S2R-T660 · S/N T660-141Cancelled May 19, 2020 · Exported to Spain · Built 2018 · Thrush Aircraft LLCN1007HThrush S2R-H80 · S/N H80-235DCCancelled Apr 23, 2020 · Exported to Canada · Thrush Aircraft LLCN1002WThrush S2R-H80 · S/N H80-228DCCancelled Apr 16, 2020 · Built 2019 · Thrush Aircraft IncN10056Thrush S2R-H80 · S/N H80-232DCCancelled Dec 4, 2019 · Exported to Brazil · Thrush Aircraft IncN1004LThrush S2R-T34 · S/N T34-496Cancelled Dec 2, 2019 · Exported to Guatemala · Thrush Aircraft IncN28048Piper J5A · S/N 5-83Cancelled Aug 12, 2019 · Revoked, canceled · Built 1940 · Crain William LN10102Thrush S2R-T660 · S/N T660-144Cancelled Aug 7, 2019 · Exported to Spain · Built 2019 · Thrush Aircraft IncN1012DThrush S2R-T34 · S/N T34-497DCCancelled Aug 7, 2019 · Exported to Colombia · Thrush Aircraft IncN3296TCessna 177 · S/N 17700596Cancelled Jul 18, 2019 · Revoked, canceled · Built 1967 · Meldrum George JN10090Thrush S2R-T34 · S/N T34-491Cancelled May 28, 2019 · Exported to Colombia · Thrush Aircraft IncN1006XThrush S2R-T34 · S/N T34-487Cancelled May 14, 2019 · Exported to Philippines · Thrush Aircraft IncN10099Thrush S2R-H80 · S/N H80-229Cancelled May 14, 2019 · Exported to Brazil · Thrush Aircraft IncN401PTBrook Aaron D LANCAIR IV-P · S/N LIV-408Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 2002 · Art Sign CompanyN1007EThrush S2R-T34 · S/N T34-490Cancelled Apr 2, 2019 · Exported to Costa Rica · Thrush Aircraft IncN7000NThrush S2R-H80 · S/N H80-101Cancelled Mar 14, 2019 · Exported to Canada · Built 2013 · Thrush Aircraft IncN1007VThrush S2R-T34 · S/N T34-488Cancelled Mar 11, 2019 · Exported to Costa Rica · Thrush Aircraft IncN10087Thrush S2R-T34 · S/N T34-482Cancelled Feb 5, 2019 · Exported to Ecuador · Built 2018 · Thrush Aircraft IncN10047Thrush S2R-T34 · S/N T34-485Cancelled Feb 4, 2019 · Exported to Ecuador · Thrush Aircraft IncN10005Thrush S2R-H80 · S/N H80-227DCCancelled Jan 2, 2019 · Exported to Brazil · Thrush Aircraft IncN10055Thrush S2R-T34 · S/N T34-486DCCancelled Jan 2, 2019 · Exported to Brazil · Thrush Aircraft IncN55369Thrush S2R-T34 · S/N T34-468DCCancelled Dec 21, 2018 · Exported to Colombia · Built 2018 · Thrush Aircraft IncN1004CThrush S2R-H80 · S/N H80-226Cancelled Dec 14, 2018 · Exported to Brazil · Thrush Aircraft IncN1008UThrush S2R-T34 · S/N T34-483DCCancelled Dec 10, 2018 · Exported to Brazil · Thrush Aircraft IncN5533AThrush S2R-T660 · S/N T660-139Cancelled Dec 10, 2018 · Exported to Spain · Built 2018 · Thrush Aircraft IncN1002XThrush S2R-T34 · S/N T34-480Cancelled Dec 1, 2018 · Exported to Colombia · Built 2018 · Thrush Aircraft IncN1003TThrush S2R-T34 · S/N T34-481Cancelled Nov 8, 2018 · Exported to Brazil · Thrush Aircraft IncN5526WThrush S2R-H80 · S/N H80-222DCCancelled Oct 31, 2018 · Exported to South Africa · Built 2018 · Thrush Aircraft IncN1012LThrush S2R-H80 · S/N H80-225Cancelled Oct 29, 2018 · Exported to Argentina · Thrush Aircraft IncN5538MThrush S2R-H80 · S/N H80-224DCCancelled Oct 16, 2018 · Exported to Brazil · Thrush Aircraft IncN5538VThrush S2R-H80 · S/N H80-223Cancelled Oct 16, 2018 · Exported to Ecuador · Built 2018 · Thrush Aircraft Inc
Back to Albany, GA