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.
N5530PThrush S2R-H80 · S/N H80-189DCN6215UThrush S2R-T34 · S/N T34-444DCN55201Thrush S2R-T34 · S/N T34-449N62161Thrush S2R-H80 · S/N H80-187N62162Thrush S2R-T34 · S/N T34-445N6217GThrush S2R-T34 · S/N T34-446N62166Thrush S2R-H80 · S/N H80-186N6216BThrush S2R-T34 · S/N T34-442N62164Thrush S2R-T34 · S/N T34-443N2913GCallair A-6 · S/N 268N62152Thrush S2R-T34 · S/N T34-437DCN6214QThrush S2R-T34 · S/N T34-441N62150Thrush S2R-T34 · S/N T34-440N62156Thrush S2R-H80 · S/N H80-174N6214TThrush S2R-T34 · S/N T34-439N62155Thrush S2R-H80 · S/N H80-171DCN6213TThrush S2R-H80 · S/N H80-169N6215CThrush S2R-H80 · S/N H80-173N6215LThrush S2R-T34 · S/N T34-436N6214EThrush S2R-T34 · S/N T34-431N6211CThrush S2R-T34 · S/N T34-435N6209HThrush S2R-H80 · S/N H80-166DCN6213XThrush S2R-H80 · S/N H80-164N62137Thrush S2R-T34 · S/N T34-430N6209YThrush S2R-T34 · S/N T34-429N6213DThrush S2R-T34 · S/N T34-433N62091Thrush S2R-H80 · S/N H80-162N6211EThrush S2R-H80 · S/N H80-159N6208RThrush S2R-H80 · S/N H80-172N62129Thrush S2R-H80 · S/N H80-152N62076Thrush S2R-H80 · S/N H80-157N62120Thrush S2R-T34 · S/N T34-427N6485ZPiper PA-25-235 · S/N 25-2004N62068Thrush S2R-H80 · S/N H80-163DCN62078Thrush S2R-H80 · S/N H80-160DCN6206YThrush S2R-H80 · S/N H80-158N9820BSchleicher Alexander K 7 · S/N 7082N6207ZThrush S2R-T34 · S/N T34-409N62082Thrush S2R-H80 · S/N H80-161DCN62036Thrush S2R-T34 · S/N T34-417N62038Thrush S2R-T34 · S/N T34-418N6214PThrush S2R-T34 · S/N T34-419N6206GThrush S2R-T34 · S/N T34-425N62080Thrush S2R-H80 · S/N H80-156DCN6207LThrush S2R-H80 · S/N H80-147N30449Thrush S2R-H80 · S/N H80-126DCN6203VThrush S2R-H80 · S/N H80-141DCN62042Thrush S2R-H80 · S/N H80-148DCN6204QThrush S2R-H80 · S/N H80-153DCN6204UThrush S2R-H80 · S/N H80-154DC
Back to Albany, GA