Skip to content

Cancelled registrations · 414

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 = 'OK' AND d.registrant_city = 'NONE' 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 = 'OK' AND d.registrant_city = 'NONE'
  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 = 'OK' AND d.registrant_city = 'NONE'
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.

N972BWMcdonnell Douglas Heli 369FF · S/N 0105FFCancelled Aug 17, 2021 · Exported to South Africa · Built 1994 N401KPCessna 210 · S/N 57039Cancelled May 8, 2021 · Sale reported, canceled · Built 1959 N587TJEurocopter Deutschland MBB BK-117 A4 · S/N 7047Cancelled Mar 22, 2021 · Sale reported, pending cancellation · Built 1986 N238XSteffens Richard E STEFFENS-PITTS S111B · S/N 6246Cancelled Jan 11, 2021 · Exported to Australia · Built 2002 N101JDPiper PA-23-250 · S/N 27-3588Cancelled Dec 21, 2020 · Exported to Bahamas · Built 1966 N184AKCessna 152 · S/N 152-80189Cancelled Dec 5, 2020 · Exported to Poland · Built 1977 N6958NCessna T210N · S/N 21063168Cancelled Nov 27, 2020 · Sale reported, canceled · Built 1979 N66952Cessna 152 · S/N 15281687Cancelled Oct 2, 2020 · Sale reported, pending cancellation · Built 1978 N1647LFirefly Balloons FIREFLY 8 · S/N F8-2021Cancelled Sep 1, 2020 · Exported to Poland · Built 2007 N69KARobinson Helicopter R44 · S/N 1182Cancelled May 13, 2020 · Exported to Mexico · Built 2002 N7322ECessna 210 · S/N 57022Cancelled Mar 13, 2020 · Exported to Russia · Built 1959 N2748DCessna 170B · S/N 25290Cancelled Mar 10, 2020 · Exported to Russia · Built 1952 N8613ZFlightstar FORMULA · S/N 810Cancelled Mar 2, 2020 · Sale reported, pending cancellation · Built 2001 N2067NAir Tractor AT-802 · S/N 802-0502Cancelled Jan 14, 2020 · Exported to Canada · Built 2013 N1228YCessna 172R · S/N 17281250Cancelled Dec 26, 2019 · Exported to China · Built 2005 N822UWAirborne Windsports PTY EDGE XT-912-L · S/N XT-912-0522Cancelled Dec 3, 2019 · Exported to Israel · Built 2017 N25220Cessna 152 · S/N 15280537Cancelled Nov 20, 2019 · Exported to Peru · Built 1977 N304STSaab-Fairchild 340A · S/N 340A-102Cancelled Nov 15, 2019 · Sale reported, canceled · Built 1987 N7001QEagle Balloons C-7 · S/N E81713Cancelled Aug 12, 2019 · Sale reported, canceled · Built 1981 N94KSCessna 172S · S/N 172S8217Cancelled Jul 23, 2019 · Exported to Canada · Built 1999 N3557QCessna A188 · S/N 188-0507Cancelled May 4, 2019 · Sale reported, canceled · Built 1969 N5863QMooney M20E · S/N 796Cancelled Nov 30, 2018 · Sale reported, canceled · Built 1965 N19KNSlepcev Nestor STORCH · S/N 138Cancelled Sep 4, 2018 · Exported to Mexico · Built 2007 N345AMCessna 150F · S/N 15062646Cancelled Aug 31, 2018 · Exported to Argentina · Built 1965 N20893Cessna 182P · S/N 18261292Cancelled Jul 16, 2018 · Exported to Canada · Built 1972 N628BAThrush S2R-T34 · S/N T34-428Cancelled May 30, 2018 · Exported to Canada · Built 2015 N9758LBeech C23 · S/N M-1379Cancelled May 1, 2018 · Sale reported, pending cancellation · Built 1972 N2337VAir Tractor AT-301 · S/N 301-0383Cancelled Apr 16, 2018 · Exported to Mexico N800RHSiai-Marchetti F.260B · S/N 11-02Cancelled Apr 16, 2018 · Sale reported, pending cancellation N420MBMBB BK 117 A-3 · S/N 7077Cancelled Apr 9, 2018 · Exported to Canada N231QKQuest KODIAK 100 · S/N 100-0231Cancelled Mar 19, 2018 · Exported to China · Built 2017 N7644CTopdog Ultralights TOPDOG · S/N UTA13TDACancelled Feb 6, 2018 · Sale reported, pending cancellation N45BKLearjet 25 · S/N 036Cancelled Feb 5, 2018 · Sale reported, pending cancellation N603MEEurocopter Deutschland EC 135 P2 · S/N 0284Cancelled Feb 2, 2018 · Sale reported, pending cancellation · Built 2003 N3290Carter-Great Lakes 2T-1L · S/N 6830D-369Cancelled Feb 1, 2018 · Sale reported, pending cancellation · Built 1970 N42031Piper J3C-65 · S/N 9083Cancelled Feb 1, 2018 · Sale reported, pending cancellation · Built 1942 N356AMEurocopter EC 130 B4 · S/N 7006Cancelled Jan 31, 2018 · Sale reported, pending cancellation · Built 2010 N2511DJI PHANTOM 3 PROFESSION · S/N CG082107302464Cancelled Jan 30, 2018 · Sale reported, pending cancellation N104ANCessna 208B · S/N 208B0918Cancelled Dec 19, 2017 · Exported to Brazil · Built 2001 N653YCAscending Technologies ASCTEC HUMMINGBIRD · S/N 20407Cancelled Jun 15, 2017 · Exported to Austria N654CXAscending Technologies ASCTEC HUMMINGBIRD · S/N 20922Cancelled Jun 15, 2017 · Exported to Austria N654YCAscending Technologies ASCTEC HUMMINGBIRD · S/N 20912Cancelled Jun 15, 2017 · Exported to Austria N655HXAscending Technologies ASCTEC HUMMINGBIRD · S/N 20556Cancelled Jun 15, 2017 · Exported to Austria N655RCAscending Technologies ASCTEC HUMMINGBIRD · S/N 20558Cancelled Jun 15, 2017 · Exported to Austria N655VCAscending Technologies ASCTEC HUMMINGBIRD · S/N 21040Cancelled Jun 15, 2017 · Exported to Austria N655YCAscending Technologies ASCTEC HUMMINGBIRD · S/N 20578Cancelled Jun 15, 2017 · Exported to Austria N6563XAscending Technologies ASCTEC HUMMINGBIRD · S/N 21072Cancelled Jun 15, 2017 · Exported to Austria N656RNAscending Technologies ASCTEC HUMMINGBIRD · S/N 20543Cancelled Jun 15, 2017 · Exported to Austria N654AXAscending Technologies ASCTEC HUMMINGBIRD · S/N 20923Cancelled Jun 14, 2017 · Exported to Austria N6559CAscending Technologies ASCTEC HUMMINGBIRD · S/N 21039Cancelled Jun 14, 2017 · Exported to Austria

Back to None, OK