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.
N186PCBeech H35 · S/N D-5270N7699VAero Commander CALLAIR A-9B · S/N 1440N3055DThrush S2R-T34 · S/N T34-384DCN3048DThrush S2R-T34 · S/N T34-377DCN510KWThrush S2R-H80 · S/N H80-104N3047LThrush S2R-T34 · S/N T34-376N7015KThrush S2R-T34 · S/N T34-352N7012GThrush S2R-T34 · S/N T34-370N7007CThrush S2R-T34 · S/N T34-367N70134Thrush S2R-T34 · S/N T34-371N7007QThrush S2R-T34 · S/N T34-363DCN70068Thrush S2R-T34 · S/N T34-365N70158Thrush S2R-T34 · S/N T34-360N7015XThrush S2R-T34 · S/N T34-358DCN70188Thrush S2R-T34 · S/N T34-351DCN7007YThrush S2R-T34 · S/N T34-355N7007HThrush S2R-T34 · S/N T34-354N7015QThrush S2R-T660 · S/N T660-126N7016EThrush S2R-T34 · S/N T34-356DCN7015AThrush S2R-T34 · S/N T34-348N70144Thrush S2R-T34 · S/N T34-357N7004ZThrush S2R-G10 · S/N G10-171N70191Thrush S2R-T34 · S/N T34-350N70167Thrush S2R-T34 · S/N T34-346N70169Thrush S2R-T34 · S/N T34-349N121GEThrush S2RHG-T65 · S/N T65HG-024N5307FThrush S2R-T34 · S/N T34-340N5307VThrush S2R-T34 · S/N T34-331DCN8809QAero Commander S2R · S/N 1509RN70239Thrush S2R-T34 · S/N T34-345DCN53001Thrush S2R-T34 · S/N T34-318DCN16FCBeech C23 · S/N M-2069N22514Cessna 150H · S/N 15068328N3726QBeech 77 · S/N WA-165N38031Beech 77 · S/N WA-209N38482Beech 77 · S/N WA-245N38671Beech 77 · S/N WA-255N48756Cessna 152 · S/N 15280955N5119RBeech B19 · S/N MB-654N6457LCessna 152 · S/N 15284399N64822Cessna 152 · S/N 15281437N65412Cessna 152 · S/N 15281535N67645Cessna 152 · S/N 15285304N7140GCessna 172K · S/N 17258840N9592HCessna 172M · S/N 17266251N94133Cessna 152 · S/N 15285604N3099PAyres S2R-T65 · S/N T65-4XN3099TAyres S2R-T65 · S/N T65-5XN3729ZBeech 77 · S/N WA-146N4612PPiper PA-23-250 · S/N 27-125
Back to Albany, GA