Savannah, GA
Cancelled registrations · 748
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 = 'SAVANNAH' 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 = 'SAVANNAH' 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.
N230GAIai GULFSTREAM G280 · S/N 2330N724GDGulfstream Aerospace GVIII-G700 · S/N 87124N598GAGulfstream Aerospace GVII-G500 · S/N 72198N617GDGulfstream Aerospace GVII-G600 · S/N 73217N923GAGulfstream Aerospace GVIII-G700 · S/N 87123N727GDGulfstream Aerospace GVIII-G700 · S/N 87127N701GAGulfstream Aerospace GVIII-G700 · S/N 87101N838GAGulfstream Aerospace GVIII-G800 · S/N 88038N725GDGulfstream Aerospace GVIII-G700 · S/N 87125N614GDGulfstream Aerospace GVII-G600 · S/N 73214N611GAGulfstream Aerospace GVII-G600 · S/N 73211N706GDGulfstream Aerospace GVIII-G700 · S/N 87006N720GSGulfstream Aerospace GVIII-G700 · S/N 87120N226GAIai GULFSTREAM G280 · S/N 2326N592GAGulfstream Aerospace GVII-G500 · S/N 72192N833GAGulfstream Aerospace GVIII-G800 · S/N 88033N925GAIai GULFSTREAM G280 · S/N 2325N609GAGulfstream Aerospace GVII-G600 · S/N 73209N591GDGulfstream Aerospace GVII-G500 · S/N 72191N100GAGulfstream Aerospace GVIII-G700 · S/N 87100N710GAGulfstream Aerospace GVIII-G700 · S/N 87107N604GAGulfstream Aerospace GVII-G600 · S/N 73204N713GDGulfstream Aerospace GVIII-G700 · S/N 87113N608GAGulfstream Aerospace GVII-G600 · S/N 73208N221GAIai GULFSTREAM G280 · S/N 2321N587GAGulfstream Aerospace GVII-G500 · S/N 72187N110GAGulfstream Aerospace GVIII-G700 · S/N 87110N828GAGulfstream Aerospace GVIII-G800 · S/N 88028N583GAGulfstream Aerospace GVII-G500 · S/N 72183N348APGulfstream Aerospace GVIII-G800 · S/N 88022N601GDGulfstream Aerospace GVII-G600 · S/N 73201N705GAGulfstream Aerospace GVIII-G700 · S/N 87105N799GDGulfstream Aerospace GVIII-G700 · S/N 87099N579GAGulfstream Aerospace GVII-G500 · S/N 72179N103GAGulfstream Aerospace GVIII-G700 · S/N 87103N880GAGulfstream Aerospace GVIII-G800 · S/N 88012N796GAGulfstream Aerospace GVIII-G700 · S/N 87096N995GAGulfstream Aerospace GVIII-G700 · S/N 87095N704GAGulfstream Aerospace GVIII-G700 · S/N 87004N702GAGulfstream Aerospace GVIII-G700 · S/N 87102N798GAGulfstream Aerospace GVIII-G700 · S/N 87098N699GAGulfstream Aerospace GVII-G600 · S/N 73199N677GAGulfstream Aerospace GVII-G600 · S/N 73177N821GAGulfstream Aerospace GVIII-G800 · S/N 88021N794GAGulfstream Aerospace GVIII-G700 · S/N 87094N763GDGulfstream Aerospace GVIII-G700 · S/N 87063N702GDGulfstream Aerospace GVIII-G700 · S/N 87002N774GDGulfstream Aerospace GVIII-G700 · S/N 87074N213GAIai GULFSTREAM G280 · S/N 2313N786GDGulfstream Aerospace GVIII-G700 · S/N 87086
Back to Savannah, GA