Skip to content

Cancelled registrations · 146

Query with SQL

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 = 'AUGUSTA' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'AUGUSTA'
  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 = 'AUGUSTA'
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.

N16063Cessna 150L · S/N 15073450Cancelled Sep 5, 2026 · Sale reported, canceled · Built 1972 N743PRDJI PHANTOM 3 PROFESSION · S/N P76DCH29A20724Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Rw Allen LLC N948BCPiper PA-23-250 · S/N 27-3169Cancelled May 9, 2022 · Registration expired, pending cancellation · Howard William C N691CDCirrus Design SR20 · S/N 1610Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 2006 · Augusta Technical College N112AGPiper PA-31-310 · S/N 31-698Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1970 · Augusta Technical College N284JTStinson L-5 · S/N 76-802Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Jatho Jim W N7529TCessna 172A · S/N 47129Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Rhodes Douglas P N61454Piper PA-31-350 · S/N 31-7405479Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1974 · Augusta Aviation Inc N5320EBeech K35 · S/N D-5815Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Built 1959 · Howard Stephen R N4160YCameron Balloons US N-90 · S/N 5722Cancelled Jan 31, 2019 · Registration expired, pending cancellation · Built 1991 · Norton Charles L N27236Piper PA-31-350 · S/N 31-7752111Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Built 1977 · Augusta Aviation Inc N3381Bensen B-8M · S/N WSB-1Cancelled Jan 14, 2019 · Revoked, canceled · Brown O B Co Ow N45DCReilly Charles W ESCAPADE · S/N JAESC0116Cancelled Oct 27, 2018 · Built 2007 · Putt Larry F N2057WBeech 95-C55 · S/N TE-24Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1965 · Ballard Truck & Tire N725KJGabor Richard L ULTRA ACE · S/N 002Cancelled May 31, 2018 · Sale reported, canceled · Built 2010 N93293Rearwin 185 · S/N 1798Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Skyranger Flying Club N7128FBalloon Works FIREFLY 8 · S/N F8-430Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Built 1999 · Fields David N266SBButler William S THATCHER CX4 · S/N 40Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 2008 · Nothdurft Michael S N3627PPiper PA-22-150 · S/N 22-3360Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1955 · Rhodes George P N1708Bensen B-8M · S/N 002Cancelled Oct 28, 2017 · Revoked, canceled · Guy V A N3269BPiper PA-22-135 · S/N 22-2090Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1954 · Boone C Foster Jr N24346Cessna 152 · S/N 15280228Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1977 · Augusta Aviation Inc N2711PChilds/Aerodesigns PULSAR · S/N 271Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Childs Charles B Jr N6158QVargo Mj/Quicksilver 1994 SPORT 2 · S/N 600Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1994 · Nothdurft Michael S N25721Balloon Works FIREFLY 8B-15 · S/N F8B-463Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Southtrust Bank Georgia N66670Cessna 150M · S/N 15076197Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1974 · Singletary Leo N7121RPiper PA-28-140 · S/N 28-21821Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1966 · Rhodes Robert L N63786Bell OH-58A · S/N 68-16899Cancelled May 12, 2015 · Registration expired, pending cancellation · Seco Aviation Inc N34382Meyers Industries 200B · S/N 264Cancelled Dec 22, 2014 · Revoked, canceled · Built 1961 · Smith George Williams N355PTMoffitt Oscar/ Kit Prostar A/C PT2 · S/N 1072Cancelled Dec 10, 2014 · Built 1994 · Putt Larry F N15DDDemonstoy Dennis B-8-M · S/N DD-1Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Demonstoy Dennis N389CPCirrus Design SR20 · S/N 1881Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 2007 · Atg-Ga Leasing LLC N105RSPiper PA-31-310 · S/N 31-754Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1970 · Fuller Ronald A N787WBLockheed 1329-25 JETSTAR II · S/N 5210Cancelled Aug 21, 2013 · Sale reported, canceled N3502Eaa Chapter 172-Thorp T-18 · S/N 82Cancelled Aug 14, 2013 · Registration pending, canceled · Built 1969 N725TCThunder & Colt Airborne Amer AX7-77 S1 · S/N 2494Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1993 · Boyd Gerald N8693CPiper PA-22-135 · S/N 22-1329Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1953 · Evans Steven L N3945YMitchell Stephen A PTEROD ASCEN 2+2 · S/N 28218Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Mitchell Stephen A N7237JBell 206A-1 · S/N 44032Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Southeastern Equipment Co Services Inc N600MMRockwell International 695 · S/N 95029Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Bush Field Aircraft Company N155TJLockheed 1329 · S/N 5104Cancelled May 22, 2013 · Sale reported, pending cancellation · Built 1967 N62352Sikorsky CH-54A · S/N 68-18453Cancelled May 14, 2013 · Registration expired, pending cancellation · Seco Aviation Company N290JMMaxwell James F AIR BIKE · S/N AB4582595Cancelled May 9, 2013 · Sale reported, canceled N3240ADouglas C-47A · S/N 42-100828Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Seco Aviation Company Inc N577FSPiper PA-31P · S/N 31P-7730008Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1977 N8102JPatton AL PATTON APL-1 · S/N 14ACancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1989 · Patton Al N47785Cessna 152 · S/N 15283247Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1979 · Augusta Technical College N62023North American T-2B · S/N 152444Cancelled Nov 14, 2012 · Sale reported, canceled N61995North American T-2B · S/N 152443Cancelled Nov 9, 2012 · Sale reported, canceled N6199ZNorth American T-2B · S/N 152446Cancelled Nov 9, 2012 · Sale reported, canceled

Back to Augusta, GA