Skip to content

Cancelled registrations · 335

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

N882KCRobinson Helicopter R22 BETA · S/N 4301Cancelled Sep 25, 2025 · Exported to Argentina · Built 2008 · Interstate Helicopters Inc N321KDKodiak KODIAK 100 · S/N 100-0313Cancelled Oct 15, 2024 · Exported to New Zealand · Built 2022 · Southern Wings Aircraft Sales Ltd N282KQKodiak KODIAK 100 · S/N 100-0282Cancelled Sep 28, 2023 · Exported to New Zealand · Built 2020 · Southern Wings Aircraft Sales Ltd N838TJJohnson Thomas J III WAIEX · S/N 0013Cancelled Jun 3, 2021 · Built 2014 · Johnson Thomas J III Trustee N47688Taylorcraft DC-65 · S/N 4384Cancelled Aug 28, 2018 · Revoked, canceled · Built 1942 · Pittman L R N807ACRockwell International 500-S · S/N 3281Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Bills John Stephen N594BMCessna 421B · S/N 421B0206Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1971 · Midwest Jet Sales Inc N7TWBeech B90 · S/N LJ-478Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1969 · Airspeed Aviation Of Oklahoma LLC N7590QCessna 310Q · S/N 310Q0607Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Built 1972 · Thomasjets LLC N262BColonial C-1 · S/N 22Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Price Art D N5036TPiper PA-34-200 · S/N 34-7250204Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1972 · Business Air Corporate Aviation Ltd N38PTPiper PA-38-112 · S/N 38-78A0042Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1978 · Business Air Corporate Aviation Ltd N66367Boeing A75N1(PT17) · S/N 75-1968Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Mary Woods Enterprises N29125Cessna TU206C · S/N U206-1095Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1968 · Jet Away Management Inc N1010UAero Commander 500-U · S/N 1725-28Cancelled Sep 8, 2014 · Registration expired, pending cancellation · Built 1967 · Bills John Stephen N9626TCessna 210 · S/N 57426Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1960 N2362NPiper PA-38-112 · S/N 38-79A0808Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1979 N44357Taylorcraft BC12-D1 · S/N 10157Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1946 N4964UCessna 210 · S/N 21058664Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1965 N2248SCessna 210L · S/N 21061192Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1976 · Global Aircraft Inc N69CWPiper PA-28-140 · S/N 28-7125078Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1970 · C&W Aircraft Incorporated N4635PPiper PA-23-250 · S/N 27-154Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1960 · Aaa Aircraft Sales Inc N161XIsrael Aircraft Industries 1124 · S/N 234Cancelled Apr 4, 2013 · Built 1979 · Romar Aviation N4741WRockwell International 114 · S/N 14071Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1976 N7749VAero Commander CALLAIR A-9B · S/N 1377Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1968 N191SAGrumman G-159 · S/N 61Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1961 N4470RCessna 172M · S/N 17263212Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1974 · Gemc Aviation Inc N84UCessna 421C · S/N 421C0326Cancelled Nov 20, 2012 · Registration expired, pending cancellation · Built 1977 · Air Consult Inc N5752JCessna 210K · S/N 21059452Cancelled Sep 25, 2012 · Sale reported, pending cancellation · Built 1971 N9253UCessna 150M · S/N 15078203Cancelled Sep 10, 2012 · Registration pending, canceled · Built 1976 N2981XCessna 177 · S/N 17700381Cancelled Aug 30, 2012 · Sale reported, canceled · Built 1967 N532TMBeech 58 · S/N TH-1769Cancelled Aug 30, 2012 · Exported to Australia · Southern Wings Aircraft Sales Ltd N2228XCessna 337 · S/N 337-0128Cancelled Aug 10, 2012 · Sale reported, canceled · Built 1965 N7241XCessna 150A · S/N 15059341Cancelled Jul 9, 2012 · Registration pending, canceled · Built 1961 N1434XPiper PA-28R-200 · S/N 28R-7535281Cancelled Jun 21, 2012 · Sale reported, canceled · Built 1975 N4482VRobinson Helicopter R44 II · S/N 13171Cancelled Dec 20, 2011 · Exported to Turkey · Built 2011 N777DBeech C35 · S/N D-2839Cancelled Sep 20, 2011 · Second renewal notice · Built 1951 · Starzacher Michael J N110CPBell UH-1F · S/N 65-7955Cancelled Jul 19, 2011 · Sale reported, canceled N1347UBell 206B · S/N 1089Cancelled Mar 22, 2011 · Expired dealer · Waggoner Aircraft Inc N45QCAero Commander 680T · S/N 1542-7Cancelled Mar 8, 2011 · Expired dealer · Built 1965 · Waggoner Aircraft Inc N4456QRobinson Helicopter R44 II · S/N 12960Cancelled Feb 23, 2011 · Expired dealer · Built 2009 · Interstate Helicopters Inc N237ATBeech 95-B55 (T42A) · S/N TC-1502Cancelled Aug 25, 2010 · Exported to Brazil · Built 1972 · Interstate Helicopters Inc N226EBHawker Beechcraft G58 · S/N TH-2222Cancelled Dec 16, 2009 · Exported to Brazil · Built 2008 · Interstate Helicopters Inc N45272Robinson Helicopter R22 BETA · S/N 4418Cancelled Nov 16, 2009 · Exported to Brazil · Built 2009 · Interstate Helicopters Inc N99314Cessna 337 · S/N 3370798Cancelled Sep 17, 2009 · Registration revoked · Hurley Aircraft Corp N11198Beech C18S · S/N 6425Cancelled Jun 25, 2009 · Registration revoked · Built 1944 · Oklahoma Electronics N9335PPiper PA-24-260 · S/N 24-4833Cancelled Jun 27, 2008 · Exported to New Zealand · Built 1969 · Southern Wings Aircraft Sales Ltd N741SPCessna 172S · S/N 172S8673Cancelled Jun 16, 2008 · Exported to New Zealand · Built 2000 · Southern Wings Aircraft Sales Ltd N48DDHawker Siddeley DH.125-3A · S/N 25115Cancelled Jun 10, 2008 · Triennial form not returned · Built 1966 · Jet Service Enterprises Inc N50SXCessna 152 · S/N 15285147Cancelled Jun 2, 2008 · Exported to Argentina · Built 1981 · Southern Wings Aircraft Sales Ltd

Back to Bethany, OK