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.

N186PCBeech H35 · S/N D-5270Cancelled Aug 1, 2012 · Sale reported, canceled · Built 1957N7699VAero Commander CALLAIR A-9B · S/N 1440Cancelled Aug 1, 2012 · Registration pending, canceled · Built 1969N3055DThrush S2R-T34 · S/N T34-384DCCancelled Jul 11, 2012 · Exported to Australia · Thrush Aircraft IncN3048DThrush S2R-T34 · S/N T34-377DCCancelled Jun 13, 2012 · Exported to South Africa · Built 2012 · Thrush Aircraft IncN510KWThrush S2R-H80 · S/N H80-104Cancelled May 15, 2012 · Thrush Aircraft IncN3047LThrush S2R-T34 · S/N T34-376Cancelled Apr 27, 2012 · Exported to Brazil · Thrush Aircraft IncN7015KThrush S2R-T34 · S/N T34-352Cancelled Mar 7, 2012 · Exported to Brazil · Thrush Aircraft IncN7012GThrush S2R-T34 · S/N T34-370Cancelled Mar 5, 2012 · Exported to Côte d’Ivoire · Built 2012 · Thrush Aircraft IncN7007CThrush S2R-T34 · S/N T34-367Cancelled Feb 14, 2012 · Exported to Ecuador · Thrush Aircraft IncN70134Thrush S2R-T34 · S/N T34-371Cancelled Feb 7, 2012 · Exported to Ecuador · Thrush Aircraft IncN7007QThrush S2R-T34 · S/N T34-363DCCancelled Jan 12, 2012 · Exported to Brazil · Thrush Aircraft IncN70068Thrush S2R-T34 · S/N T34-365Cancelled Jan 9, 2012 · Exported to Ecuador · Built 2011 · Thrush Aircraft IncN70158Thrush S2R-T34 · S/N T34-360Cancelled Jan 9, 2012 · Exported to Argentina · Thrush Aircraft IncN7015XThrush S2R-T34 · S/N T34-358DCCancelled Jan 6, 2012 · Exported to Kenya · Thrush Aircraft IncN70188Thrush S2R-T34 · S/N T34-351DCCancelled Dec 23, 2011 · Exported to Brazil · Built 2011 · Thrush Aircraft IncN7007YThrush S2R-T34 · S/N T34-355Cancelled Dec 21, 2011 · Exported to Ecuador · Thrush Aircraft IncN7007HThrush S2R-T34 · S/N T34-354Cancelled Nov 23, 2011 · Exported to Brazil · Thrush Aircraft IncN7015QThrush S2R-T660 · S/N T660-126Cancelled Oct 19, 2011 · Exported to Australia · Thrush Aircraft IncN7016EThrush S2R-T34 · S/N T34-356DCCancelled Oct 18, 2011 · Exported to Argentina · Thrush Aircraft IncN7015AThrush S2R-T34 · S/N T34-348Cancelled Aug 25, 2011 · Exported to Argentina · Thrush Aircraft IncN70144Thrush S2R-T34 · S/N T34-357Cancelled Aug 8, 2011 · Exported to Ecuador · Thrush Aircraft IncN7004ZThrush S2R-G10 · S/N G10-171Cancelled Aug 5, 2011 · Exported to Australia · Thrush Aircraft IncN70191Thrush S2R-T34 · S/N T34-350Cancelled Jul 15, 2011 · Exported to Australia · Thrush Aircraft IncN70167Thrush S2R-T34 · S/N T34-346Cancelled Jun 10, 2011 · Exported to Australia · Thrush Aircraft IncN70169Thrush S2R-T34 · S/N T34-349Cancelled May 25, 2011 · Exported to Ecuador · Thrush Aircraft IncN121GEThrush S2RHG-T65 · S/N T65HG-024Cancelled Apr 8, 2011 · Built 2009 · Thrush Aircraft IncN5307FThrush S2R-T34 · S/N T34-340Cancelled Apr 6, 2011 · Exported to Indonesia · Built 2010 · Thrush Aircraft IncN5307VThrush S2R-T34 · S/N T34-331DCCancelled Apr 6, 2011 · Exported to Indonesia · Thrush Aircraft IncN8809QAero Commander S2R · S/N 1509RCancelled Mar 29, 2011 · Expired dealer · Built 1969 · Ag Aero Distributors IncN70239Thrush S2R-T34 · S/N T34-345DCCancelled Mar 24, 2011 · Exported to Ecuador · Thrush Aircraft IncN53001Thrush S2R-T34 · S/N T34-318DCCancelled Jan 24, 2011 · Exported to Kenya · Built 2009 · Thrush Aircraft IncN16FCBeech C23 · S/N M-2069Cancelled Jan 7, 2011 · Expired dealer · Built 1978 · Sid Hall Enterprises Inc DBAN22514Cessna 150H · S/N 15068328Cancelled Jan 7, 2011 · Expired dealer · Built 1968 · Sid Hall Enterprises Inc DBAN3726QBeech 77 · S/N WA-165Cancelled Jan 7, 2011 · Expired dealer · Built 1980 · Sid Hall Enterprises Inc DBAN38031Beech 77 · S/N WA-209Cancelled Jan 7, 2011 · Expired dealer · Built 1980 · Sid Hall Enterprises Inc DBAN38482Beech 77 · S/N WA-245Cancelled Jan 7, 2011 · Expired dealer · Built 1981 · Sid Hall Enterprises Inc DBAN38671Beech 77 · S/N WA-255Cancelled Jan 7, 2011 · Expired dealer · Built 1981 · Sid Hall Enterprises Inc DBAN48756Cessna 152 · S/N 15280955Cancelled Jan 7, 2011 · Expired dealer · Built 1977 · Sid Hall Enterprises Inc DBAN5119RBeech B19 · S/N MB-654Cancelled Jan 7, 2011 · Expired dealer · Built 1974 · Sid Hall Enterprises Inc DBAN6457LCessna 152 · S/N 15284399Cancelled Jan 7, 2011 · Expired dealer · Built 1980 · Sid Hall Enterprises Inc DBAN64822Cessna 152 · S/N 15281437Cancelled Jan 7, 2011 · Expired dealer · Built 1978 · Sid Hall Enterprises Inc DBAN65412Cessna 152 · S/N 15281535Cancelled Jan 7, 2011 · Expired dealer · Built 1978 · Sid Hall Enterprises Inc DBAN67645Cessna 152 · S/N 15285304Cancelled Jan 7, 2011 · Expired dealer · Built 1981 · Sid Hall Enterprises Inc DBAN7140GCessna 172K · S/N 17258840Cancelled Jan 7, 2011 · Expired dealer · Built 1969 · Sid Hall Enterprises Inc DBAN9592HCessna 172M · S/N 17266251Cancelled Jan 7, 2011 · Expired dealer · Built 1975 · Sid Hall Enterprises Inc DBAN94133Cessna 152 · S/N 15285604Cancelled Jan 4, 2011 · Expired dealer · Built 1982 · Southern Aircraft International LLCN3099PAyres S2R-T65 · S/N T65-4XCancelled Jan 3, 2011 · Expired dealer · Ayres CorpN3099TAyres S2R-T65 · S/N T65-5XCancelled Jan 3, 2011 · Expired dealer · Ayres CorpN3729ZBeech 77 · S/N WA-146Cancelled Jan 3, 2011 · Expired dealer · Southern Aircraft International LLCN4612PPiper PA-23-250 · S/N 27-125Cancelled Jan 3, 2011 · Expired dealer · Built 1960 · Southern Aircraft International LLC
Back to Albany, GA