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.
N960DNBoeing MD-90-30 · S/N 53530N982DLMcdonnell Douglas MD-88 · S/N 53273N986DLMcdonnell Douglas MD-88 · S/N 53313N989DLMcdonnell Douglas MD-88 · S/N 53341N993DLMcdonnell Douglas MD-88 · S/N 53345N996DLMcdonnell Douglas MD-88 · S/N 53363N435GTDJI PHANTOM 2 · S/N PH645400540V2.0N604GTHorizon Hobby 1/4 SCALE J-3 CUB · S/N J3-01N605GTHorizon Hobby 1/4 SCALE J-3 CUB · S/N J3-02N606GTHorizon Hobby 1/4 SCALE J-3 CUB · S/N J3-03N117LCMesserschmitt BK 117 · S/N S-7027N440SLMesserschmitt BK 117 B-1 · S/N 7158N4608ZPiper PA-22-108 · S/N 22-8122N41129Piper J3C-65 · S/N 7778N222TVDJI Innovations INSPIRE 1 · S/N W13DCD25030897N591QVDJI Innovations PHANTOM 3 PROFESSION · S/N P76DCG17016681N306DQBoeing 737-732 · S/N 29633N302DQBoeing 737-732 · S/N 29648N113LBLindstrand Balloons 60X · S/N 5246N921DSSullivan Dwight A AVID FLYER · S/N 1060DN10RCNord STAMPE SV4C · S/N 612N975DLMcdonnell Douglas MD-88 · S/N 53243N906DLMcdonnell Douglas MD-88 · S/N 49537N552LSDJI PHANTOM 2 VISION + · S/N PH645180129 V2.0N552MG3D Robotics IRIS+ · S/N 3DR#021ID#240N552RFDJI PHANTOM 2 VISION + · S/N PH645243568 V2.0N602GTGriffon Aerospace OUTLAW ER · S/N 0150281N9591TCessna 210 · S/N 57391N609GTGeorgia Institute Of Tech SKYWALKER X-8 · S/N 001N610GTGeorgia Institute Of Tech SKYWALKER X-8 · S/N 002N307DQBoeing 737-732 · S/N 29679N301DQBoeing 737-732 · S/N 29687N303DQBoeing 737-732 · S/N 29688N304DQBoeing 737-732 · S/N 29683N958DNMcdonnell Douglas MD-90-30 · S/N 53528N811DBAerospatiale AS 355F1 · S/N 5143N724CBBowser Charles COZY MARK IV · S/N 947N953DLMcdonnell Douglas MD-88 · S/N 49884N901DAMcdonnell Douglas MD-90-30 · S/N 53381N906DAMcdonnell Douglas MD-90-30 · S/N 53386N910DLMcdonnell Douglas MD-88 · S/N 49541N915DLMcdonnell Douglas MD-88 · S/N 49546N936DLMcdonnell Douglas MD-88 · S/N 49723N947DNMcdonnell Douglas MD-90-30 · S/N 53355N957DLMcdonnell Douglas MD-88 · S/N 49976N988DLMcdonnell Douglas MD-88 · S/N 53339N159PSDiamond Aircraft Ind DA 40 · S/N 40.487N155TBSocata TB 30 EPSILON · S/N 155N140LLBoeing 767-332 · S/N 25988N314USAirbus Industrie A320-211 · S/N 160
Back to Atlanta, GA