Atlanta, GA
Cancelled registrations · 1,436
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 = 'ATLANTA' 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 = 'ATLANTA' 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.
N1980KBeech A36 · S/N E1758N259KMaule M-7-235B · S/N 23016CN7030Sikorsky CH-19E · S/N 130160N79BJAero Commander 680T · S/N 1610-46N4074APiper L-18C · S/N 18-2118N1738DLockheed L-1011-385-1-15 · S/N 193C-1234N467DABoeing 727-232 · S/N 20744N474DABoeing 727-232 · S/N 20751N237ASEmbraer EMB-120RT · S/N 120.051N240ASEmbraer EMB-120RT · S/N 120.060N22807Cessna 150H · S/N 15068529N960CTDiamond Aircraft Ind DA20-C1 · S/N C0120N239ASEmbraer EMB-120RT · S/N 120.057N704WZCessna 150M · S/N 15078944N308BXCanadair CL-600-2B16 · S/N 5110N767DALockheed L-1011-385-3 · S/N 193H1209N90AGBombardier CL-600-2B16 · S/N 5414N740DALockheed L-1011-385-1-15 · S/N 193C-1244N1509FBalloon Works FIREFLY 8-24 · S/N F8-073N142DDAerospatiale/Aeritalia ATR 42-300 · S/N 040N8253EPiper PA-28-161 · S/N 28-8216183N784DALockheed L-1011-385-1 · S/N 193A-1038N6116HFuller Stuart HOMBUILT 101 · S/N GRH 2749N765DALockheed L-1011-385-3 · S/N 193H-1206N1542CBalloon Works FIREFLY 7-B · S/N 10286N2814WBoeing 727-247 · S/N 20870N1734DLockheed L-1011-385-1 · S/N 193C-1225N414DABoeing 727-232 · S/N 21256N497DABoeing 727-232 · S/N 21077N404DABoeing 727-232 · S/N 21148N406DABoeing 727-232 · S/N 21150N409DABoeing 727-232 · S/N 21153N411DABoeing 727-232 · S/N 21223N420DABoeing 727-232 · S/N 21273N490DABoeing 727-232 · S/N 21020N495DABoeing 727-232 · S/N 21075N496DABoeing 727-232 · S/N 21076N1731DLockheed L-1011-385-1 · S/N 193C-1200N407DABoeing 727-232 · S/N 21151N408DABoeing 727-232 · S/N 21152N736DYLockheed L-1011-385-1-15 · S/N 193C-1227N412DABoeing 727-232 · S/N 21232N4001HMooney M20K · S/N 25-0452N8447YPiper PA-28-161 · S/N 28-8216026N415DABoeing 727-232 · S/N 21257N179DZBoeing 767-332 · S/N 30597N4072HMooney M20J · S/N 24-1051N94GSBoeing 727-44 · S/N 18892N315KBeech 95-B55 (T42A) · S/N TC-865N2807WBoeing 727-247 · S/N 20579
Back to Atlanta, GA