Skip to content

Cancelled registrations · 70

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

N200RPBeech B95 · S/N TD-444Cancelled May 18, 2026 · Registration pending, canceled N722EJodel D-11S · S/N 2Cancelled Dec 14, 2024 · Registration pending, canceled · Built 1958 N7555XLambert Franklin D THATCHER CX4 · S/N 162Cancelled Jun 22, 2024 · Registration pending, canceled N162JMT-Bird T-BIRD 2 PLACE · S/N 4017197Cancelled Feb 17, 2024 · Sale reported, canceled N2250NCessna 140 · S/N 12486Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1947 · Davis Terry K N7555Schweizer SGS 2-33A · S/N 185Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1970 · Closson Luke E Jr N714QTCessna 150M · S/N 15079357Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 1977 · Brooks Trudykim G N7736TMacias Richard SR RV8A · S/N 81302Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Ervin Nicholas J N80998Hughes 369HS · S/N 1090203SCancelled Jul 22, 2020 · Exported to Philippines · Vanguard Aviation Inc N9119FHughes 369HS · S/N 720392SCancelled Jul 22, 2020 · Exported to Philippines · Built 1972 · Vanguard Aviation Inc N485XMMichael R Mcclellan WINDRIDER · S/N 112013Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Mcclellan Michael R N43377Austin Howard RANS S-12XL · S/N 07040989Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 2004 · Austin Howard D N7732UCessna 172E · S/N 17251732Cancelled Nov 21, 2017 · Revoked, canceled · Built 1964 · Rentz T B N7737ZPiper PA-25-235 · S/N 25-3861Cancelled Nov 21, 2017 · Revoked, canceled · Built 1966 · Powers Gene N34408Aeronca 65-CA · S/N C14381Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1941 · Johnson Donaldson W III N70271Cessna 185E · S/N 18502088Cancelled May 15, 2017 · Registration expired, pending cancellation · Dave Mcdaniel International Aircraft N74829Piper PA-25-235 · S/N 25-02Cancelled Feb 4, 2017 · Revoked, canceled · Built 1962 · Powers Gene N3723UBalloon Works FIREFLY 7-B · S/N F7B-088Cancelled May 11, 2015 · Sale reported, canceled · Built 1984 N500YHughes Helicopters HUGHES 369D · S/N 370099DCancelled May 6, 2015 · Registration expired, pending cancellation · Flordia Rotorcraft Inc N52YJSordo Oscar MONI · S/N 00376TCancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1987 · Sordo Oscar N739VWCessna 172N · S/N 17270850Cancelled Dec 17, 2014 · Exported to Chile · Tucker William M Jr N89365Cessna 140 · S/N 8397Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Wright Newell O N39SHSchweizer 269C · S/N S1287Cancelled Oct 31, 2014 · Built 1987 · Trafficopters Inc N2933TAero Commander 100 · S/N 049Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1966 · Closson Luke E N1498BLuscombe 8F · S/N 6125Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1948 · Johnston Jeremy A N75406Darsey BENSEN B-8M · S/N N-1Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1977 · Webb William N90670Balloon Works FIREFLY 8B · S/N F8B-328Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1990 · Sineath William T N363RDGreco BUSHBY MUSTANG II · S/N M-II-363Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1975 · Dawson Richard E N39LKKoutz Larry P Q200 · S/N 2577Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Koutz Larry P N337KPCessna 337 · S/N 337-0231Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1965 · Waltco Inc N84FPCessna 172N · S/N 17271392Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1978 · Unger Wolfgang N7416FHughes 269C · S/N 670605Cancelled Jun 5, 2013 · Sale reported, canceled N9762LBeech C23 · S/N M-1382Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1972 · Harper Benny Jess N8270FCessna 150F · S/N 15064370Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1966 · Oconnor Tim DBA N249ECCessna T210L · S/N 21059636Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1972 N5819NBoeing A75N1(PT17) · S/N 75-8258Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1943 N32RHHardeman MUSTANG II · S/N 96Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1975 · Bowman John K N4576APiper PA-18-150 · S/N 18-4882Cancelled Jul 24, 2012 · Revoked, canceled · Built 1956 · Powers Gene N55052Boeing A75N1(PT17) · S/N 75-1876Cancelled Jun 14, 2012 · Registration pending, canceled · Built 1941 N4890NBoeing E75 · S/N 75-5662Cancelled Jun 12, 2012 · Registration pending, canceled · Built 1943 N7118YBalloon Works FIREFLY 8B · S/N F8B-137Cancelled Mar 24, 2010 · Triennial form not returned · Built 1988 · Sineath William T DBA N90JBPiper PA-32-300 · S/N 32-40172Cancelled Sep 15, 2009 · Registration revoked · Built 1967 · Lawless Frederick W N8954FHughes 269C · S/N 1120167Cancelled Jul 28, 2009 · Triennial form not returned · Built 1971 · Trafficopters Inc N101BABirdman BIRDMAN TL-1 · S/N 1-01Cancelled Oct 14, 2008 · Triennial form not returned · Built 1975 · New Rangoon Museum Inc N15194Balloon Works FIREFLY 7 · S/N 10971Cancelled Mar 22, 2006 · Second triennial mailing, no response · Built 1981 · Sineath William T N30197Piper PA-34-200T · S/N 34-7870227Cancelled Dec 14, 2005 · Triennial form not returned · Built 1978 · Everett Stephen A N5142RCessna 172M · S/N 17263359Cancelled Jun 2, 2004 · Sale reported · Built 1974 N21511Piper PA-32RT-300 · S/N 32R-7885211Cancelled Nov 10, 2003 · Triennial form not returned · Built 1978 · Blake Ellis & Associates Inc N90548Balloon Works FIREFLY 8B · S/N F8B-325Cancelled Mar 2, 2001 · Triennial form not returned · Bosch Olds Buick Gmc Inc N6956FCessna 150F · S/N 15063556Cancelled May 5, 1999 · Triennial form not returned · Hough Charles A

Back to Valdosta, GA