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.
N87930Piper J3C-65 · S/N 15548N18426Consolidated Vultee PBY-5A · S/N 71N41364Consolidated PBY-5A · S/N 86N54819Consolidated Vultee BT-13A · S/N 1221N95403Consolidated Vultee PBY-5A · S/N 121N96455Taylorcraft BC12-D · S/N 8755N74693Consolidated Vultee PBY-5A · S/N 482N88755Cessna T-50 · S/N 5470N91657North American NAVION · S/N NAV-4-407N55780Cessna T-50 · S/N 6323N79046Cessna AT-17 · S/N 3473N50625Fairchild M-62A · S/N T43-7011N36743Stinson 10A · S/N 8143N4690MPiper PA-11 · S/N 11-199N46742Ryan Aeronautical ST3KR · S/N 1550N55145Cessna T-50 · S/N 5079N51761Cessna T-50 · S/N 5702N46754Ryan Aeronautical ST3KR · S/N 1958N38805Piper J3L-65 · S/N 7282N41101Piper J3L-65 · S/N 7748N22663Taylorcraft BL · S/N 1310N36706Stinson 10A · S/N 8106N36708Stinson 10A · S/N 8108N32406Porterfield LP-65 · S/N 836N21564Piper J3C-50 · S/N 2412N21089Aeronca KCA · S/N KCA-61N19368Waco AVN-8 · S/N 5106N16230Waco YKS-6 · S/N 4455N15868Porterfield 35-70 · S/N 168N16125Stinson SR-7B · S/N 9687N10843Stinson SM-6000-B · S/N 5042N10017Bellanca CH300 PACEMAKER · S/N 112N400NTravel Air E-4000 · S/N 1330N2574MPiper PA-12 · S/N 12-943N49822Cessna T-50 · S/N 5998N53552Ryan Aeronautical ST3KR · S/N 2081N2848VBeech 35 · S/N D-253N3285NPiper J3C-65 · S/N 22481N39274Taylorcraft BC12-D · S/N 6258N49657Douglas DC3C-S1C3G · S/N 9066N19362Waco ZVN-8 · S/N 5103N34860Culver LFA · S/N 270N14594Stinson SR-5A · S/N 9346AN39458Stinson 10A · S/N 8258N39493Stinson 10A · S/N 8193N2577Waco 9 · S/N A-879N16253Aeronautical AERONCA LA · S/N 2013N29289Culver LCA · S/N 158N17224Taylor J-2 · S/N 890N9353Southern AIR BOSS · S/N 3
Back to Atlanta, GA