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.

N79112Cessna 172K · S/N 17257888Cancelled Dec 4, 2008 · Exported to Kenya · Built 1969 · Sid Hall Enterprises Inc DBAN25813Cessna 152 · S/N 15280797Cancelled Nov 12, 2008 · Exported to Canada · Built 1977 · Southern Aircraft International LLCN31231Thrush S2R-T34 · S/N T34-296Cancelled Nov 4, 2008 · Exported to Ecuador · Thrush Aircraft IncN5271DCessna 172S · S/N 172S9188Cancelled Oct 21, 2008 · Exported to New Zealand · Built 2002 · Sid Hall Enterprises Inc DBAN714XZCessna 152 · S/N 15279526Cancelled Oct 21, 2008 · Exported to New Zealand · Built 1977 · Sid Hall Enterprises Inc DBAN102XLCessna 152 · S/N 15285068Cancelled Oct 14, 2008 · Exported to Canada · Built 1981 · Sid Hall Enterprises Inc DBAN3163AThrush S2R-T34 · S/N T34-289Cancelled Oct 1, 2008 · Exported to Côte d’Ivoire · Thrush Aircraft IncN49221Cessna 152 · S/N 15281201Cancelled Sep 29, 2008 · Exported to New Zealand · Built 1977 · Southern Aircraft International LLCN8447MCessna A150K · S/N A15000147Cancelled Sep 24, 2008 · Exported to New Zealand · Built 1969 · Sid Hall Enterprises Inc DBAN5334PCessna 152 · S/N 15284918Cancelled Sep 19, 2008 · Exported to India · Built 1981 · Sid Hall Enterprises Inc DBAN285ACCessna 152 · S/N 15281536Cancelled Sep 9, 2008 · Exported to New Zealand · Built 1978 · Southern Aircraft International LLCN69144Cessna 152 · S/N 15282511Cancelled Sep 9, 2008 · Exported to Canada · Built 1978 · Southern Aircraft International LLCN5121BCessna 152 · S/N 15283758Cancelled Aug 27, 2008 · Exported to Canada · Built 1979 · Sid Hall Enterprises Inc DBAN23436Piper PA-38-112 · S/N 38-81A0141Cancelled Aug 21, 2008 · Exported to New Zealand · Built 1981 · Sid Hall Enterprises Inc DBAN68739Cessna 152 · S/N 15285335Cancelled Apr 25, 2008 · Exported to New Zealand · Built 1981 · Sid Hall Enterprises Inc DBAN2547NPiper PA-38-112 · S/N 38-79A0909Cancelled Apr 22, 2008 · Exported to New Zealand · Built 1979 · Sid Hall Enterprises Inc DBAN94611Cessna 152 · S/N 15285743Cancelled Apr 22, 2008 · Exported to India · Built 1983 · Southern Aircraft International LLCN96625Cessna 152 · S/N 15286015Cancelled Apr 15, 2008 · Exported to New Zealand · Built 1985 · Sid Hall Enterprises Inc DBAN94239Cessna 152 · S/N 15285629Cancelled Apr 10, 2008 · Exported to India · Built 1982 · Sid Hall Enterprises Inc DBAN94555Cessna 152 · S/N 15285720Cancelled Apr 10, 2008 · Exported to India · Built 1983 · Sid Hall Enterprises Inc DBAN24495Cessna 152 · S/N 15280287Cancelled Apr 9, 2008 · Exported to United Kingdom · Built 1977 · Sid Hall Enterprises Inc DBAN47281Cessna 152 · S/N 15283208Cancelled Apr 9, 2008 · Exported to United Kingdom · Built 1979 · Sid Hall Enterprises Inc DBAN89253Cessna 152 · S/N 15282689Cancelled Apr 9, 2008 · Exported to United Kingdom · Built 1978 · Southern Aircraft International LLCN4658PCessna 152 · S/N 15284795Cancelled Apr 8, 2008 · Exported to Canada · Built 1980 · Southern Aircraft International LLCN25290Cessna 152 · S/N 15280574Cancelled Mar 18, 2008 · Exported to Mexico · Built 1977 · Sid Hall Enterprises Inc DBAN48827Cessna 152 · S/N 15280987Cancelled Mar 17, 2008 · Exported to Mexico · Built 1978 · Southern Aircraft International LLCN3110SThrush S2R-T34 · S/N T34-282DCCancelled Feb 1, 2008 · Exported to Guatemala · Thrush Aircraft IncN95501Cessna 152 · S/N 15285908Cancelled Jan 29, 2008 · Exported to India · Built 1984 · Sid Hall Enterprises Inc DBAN95895Cessna 152 · S/N 15285981Cancelled Jan 29, 2008 · Exported to India · Built 1985 · Sid Hall Enterprises Inc DBAN4761PCessna 152 · S/N 15284811Cancelled Jan 9, 2008 · Exported to Portugal · Built 1980 · Sid Hall Enterprises Inc DBAN96846Cessna 152 · S/N 15286025Cancelled Jan 9, 2008 · Exported to Portugal · Built 1985 · Sid Hall Enterprises Inc DBAN49486Cessna 152 · S/N 15283462Cancelled Dec 26, 2007 · Exported to Canada · Built 1979N94703Cessna 152 · S/N 15285768Cancelled Dec 21, 2007 · Exported to Canada · Built 1983 · Sid Hall Enterprises Inc DBAN89373Cessna 152 · S/N 15282730Cancelled Nov 19, 2007 · Exported to Portugal · Built 1978 · Southern Aircraft International LLCN3093KThrush S2R-T34 · S/N T34-287Cancelled Oct 31, 2007 · Exported to Philippines · Built 2007 · Thrush Aircraft IncN89926Cessna 152 · S/N 15282917Cancelled Oct 24, 2007 · Exported to Canada · Built 1978 · Sid Hall Enterprises Inc DBAN49415Cessna 152 · S/N 15281246Cancelled Aug 15, 2007 · Exported to Philippines · Built 1978 · American Aviation Academy IncN30886Thrush S2R-T34 · S/N T34-283Cancelled Aug 9, 2007 · Exported to Honduras · Built 2007 · Thrush Aircraft IncN6513LCessna 152 · S/N 15284426Cancelled Jul 2, 2007 · Exported to Mexico · Built 1980 · Sid Hall Enterprises Inc DBAN43MZCessna 152 · S/N 15282659Cancelled May 1, 2007 · Exported to Canada · Built 1978 · Sid Hall Enterprises Inc DBAN4766PCessna 152 · S/N 15284812Cancelled Apr 30, 2007 · Exported to India · Built 1980 · Sid Hall Enterprises Inc DBAN67327Cessna 152 · S/N 15281757Cancelled Apr 25, 2007 · Exported to Canada · Built 1978 · Sid Hall Enterprises Inc DBAN4735BCessna 152 · S/N 15283607Cancelled Apr 23, 2007 · Exported to Mexico · Built 1979 · Sid Hall Enterprises Inc DBAN25834Cessna 152 · S/N 15280807Cancelled Apr 19, 2007 · Exported to India · Sid Hall Enterprises Inc DBAN65493Cessna 152 · S/N 15281586Cancelled Apr 19, 2007 · Exported to India · Built 1978 · Sid Hall Enterprises Inc DBAN4869PCessna 152 · S/N 15284833Cancelled Apr 18, 2007 · Exported to India · Built 1980N68487Cessna 152 · S/N 15282314Cancelled Apr 11, 2007 · Exported to Canada · Built 1978 · Sid Hall Enterprises Inc DBAN6550HCessna 152 · S/N 15284178Cancelled Apr 9, 2007 · Exported to India · Built 1979 · Southern Aircraft International LLCN94902Cessna 152 · S/N 15285808Cancelled Apr 2, 2007 · Exported to Mexico · Built 1983 · Sid Hall Enterprises Inc DBAN6386MCessna 152 · S/N 15284703Cancelled Mar 19, 2007 · Exported to Mexico · Built 1980 · Sid Hall Enterprises Inc DBA
Back to Albany, GA