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.
N80063Thrush S2R-510 · S/N 510-501N8001SThrush S2R-510 · S/N 510-110N5127JThrush S2R-T660 · S/N T660-154DCN8005LThrush S2R-510 · S/N 510-505N5161HThrush S2R-510 · S/N 510-109N51596Thrush S2R-510 · S/N 510-108N51738Thrush S2R-T34 · S/N T34-524N5158SThrush S2R-510 · S/N 510-106N51552Thrush S2R-510 · S/N 510-105N826KHThrush S2R-T660 · S/N T660P-202DCN827KHThrush S2R-T660 · S/N T660P-203DCN51672Thrush S2R-T660 · S/N T660-167DCN5119FThrush S2R-T660 · S/N T660-153N28469Luscombe 8A · S/N 1336N5152BThrush S2R-T660 · S/N T660-163DCN5154NThrush S2R-T34 · S/N T34-523N5152CThrush S2R-T34 · S/N T34-522N5148WThrush S2R-H80 · S/N H80-237N5150JThrush S2R-T34 · S/N T34-521N51504Thrush S2R-T34 · S/N T34-520DCN5137SThrush S2R-T660 · S/N T660-161N333BLCessna 340A · S/N 340A0352N5131BThrush S2R-T34 · S/N T34-517N5137FThrush S2R-T660 · S/N T660-160DCN5134YThrush S2R-T34 · S/N T34-518N5104WThrush S2R-T34 · S/N T34-506DCN610MRTextron 208B · S/N 208B5545N5119AThrush S2R-T660 · S/N T660-152N5115WThrush S2R-T34 · S/N T34-515DCN51184Thrush S2R-T660 · S/N T660-151N5124AThrush S2R-T34 · S/N T34-512N5115LThrush S2R-T34 · S/N T34-510DCN5124YThrush S2R-T34 · S/N T34-513N5117YThrush S2R-T660 · S/N T660-150N5115KThrush S2R-T34 · S/N T34-509N5102RThrush S2R-H80 · S/N H80-234N51063Thrush S2R-H80 · S/N H80-236DCN5115JThrush S2R-T660 · S/N T660-149N1003YThrush S2R-T34 · S/N T34-492N41022Thrush S2R-T660 · S/N T660-119N5532GThrush S2R-T34 · S/N T34-447N828KHThrush S2R-T660 · S/N T660P-204DCN829KHThrush S2R-T660 · S/N T660P-205DCN830KHThrush S2R-T660 · S/N T660P-206DCN831KHThrush S2R-T660 · S/N T660P-207DCN832KHThrush S2R-T660 · S/N T660P-208DCN833KHThrush S2R-T660 · S/N T660P-209DCN834KHThrush S2R-T660 · S/N T660P-210DCN835KHThrush S2R-T660 · S/N T660P-211DCN836KHThrush S2R-T660 · S/N T660P-212DC
Back to Albany, GA