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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N79112Cessna 172K · S/N 17257888N25813Cessna 152 · S/N 15280797N31231Thrush S2R-T34 · S/N T34-296N5271DCessna 172S · S/N 172S9188N714XZCessna 152 · S/N 15279526N102XLCessna 152 · S/N 15285068N3163AThrush S2R-T34 · S/N T34-289N49221Cessna 152 · S/N 15281201N8447MCessna A150K · S/N A15000147N5334PCessna 152 · S/N 15284918N285ACCessna 152 · S/N 15281536N69144Cessna 152 · S/N 15282511N5121BCessna 152 · S/N 15283758N23436Piper PA-38-112 · S/N 38-81A0141N68739Cessna 152 · S/N 15285335N2547NPiper PA-38-112 · S/N 38-79A0909N94611Cessna 152 · S/N 15285743N96625Cessna 152 · S/N 15286015N94239Cessna 152 · S/N 15285629N94555Cessna 152 · S/N 15285720N24495Cessna 152 · S/N 15280287N47281Cessna 152 · S/N 15283208N89253Cessna 152 · S/N 15282689N4658PCessna 152 · S/N 15284795N25290Cessna 152 · S/N 15280574N48827Cessna 152 · S/N 15280987N3110SThrush S2R-T34 · S/N T34-282DCN95501Cessna 152 · S/N 15285908N95895Cessna 152 · S/N 15285981N4761PCessna 152 · S/N 15284811N96846Cessna 152 · S/N 15286025N49486Cessna 152 · S/N 15283462N94703Cessna 152 · S/N 15285768N89373Cessna 152 · S/N 15282730N3093KThrush S2R-T34 · S/N T34-287N89926Cessna 152 · S/N 15282917N49415Cessna 152 · S/N 15281246N30886Thrush S2R-T34 · S/N T34-283N6513LCessna 152 · S/N 15284426N43MZCessna 152 · S/N 15282659N4766PCessna 152 · S/N 15284812N67327Cessna 152 · S/N 15281757N4735BCessna 152 · S/N 15283607N25834Cessna 152 · S/N 15280807N65493Cessna 152 · S/N 15281586N4869PCessna 152 · S/N 15284833N68487Cessna 152 · S/N 15282314N6550HCessna 152 · S/N 15284178N94902Cessna 152 · S/N 15285808N6386MCessna 152 · S/N 15284703
Back to Albany, GA