Skip to content

Cancelled registrations · 98

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

N6213RCessna 172RG · S/N 172RG0118Cancelled Feb 4, 2026 · Exported to Australia · Built 1979 · Ronald E Nolley Jr Md Inc Pc N208YYCessna 208 · S/N 20800151Cancelled Mar 15, 2024 · Exported to Canada · Aircraft Structures International Corp N208KTCessna 208 · S/N 20800401Cancelled Nov 27, 2023 · Exported to Saudi Arabia · Built 2006 · Aircraft Structures International Corp N208BRCessna 208 · S/N 20800317Cancelled Feb 28, 2023 · Exported to Saudi Arabia · Built 2000 · Aircraft Structures International Corp N72BYHuntley David R PITTS S1-S · S/N 001Cancelled Feb 3, 2023 · Sale reported, canceled N2891UPiper PA-32-300 · S/N 32-7940184Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1979 · Peart Dana S N357LGBeech B35 · S/N D-2532Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1950 · Smith Thomas W N63891Beech C23 · S/N M-2362Cancelled Dec 27, 2019 · Registration pending, canceled N5709XCessna 320 · S/N 320-0009Cancelled Apr 5, 2018 · Revoked, canceled · Built 1961 · Chambers E E N366DSCessna 337 · S/N 337-0084Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1965 · Aircraft Structures International Corp N425NCessna 425 · S/N 425-0218Cancelled Jan 24, 2018 · Exported to Nigeria · Built 1984 · Vaughn Good Oil Co LLC N4825CCottle John PAZMANY PL1 · S/N 001JCCancelled Jan 8, 2018 · Registration expired, pending cancellation · Cottle John G N72283Cessna 140 · S/N 9460Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1946 · Veith Cary F N4239EPiper PA-38-112 · S/N 38-78A0500Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1978 · Quindt Boyd N3735YBeech A36 · S/N E-1767Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1980 · Le Grand Dale N2405LPiper PA-38-112 · S/N 38-79A0694Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1979 · Myers Gregory N6251ECessna 172 · S/N 46351Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1958 · Grafiada Rick I N65205Piper PA-31-350 · S/N 31-7405155Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1973 · Price Samuel W Dr N973PWBeech B35 · S/N D-2628Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1950 N23684Beech A36 · S/N E-1207Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1978 · Acorn Resources N6402KCessna 150M · S/N 15077683Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1975 · H And H Aviation Inc N9045HHoward DGA-15P · S/N 955Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1944 · Pair Melvin R N5167YCessna T210N · S/N 21064103Cancelled Apr 1, 2013 · Registration expired, pending cancellation · Built 1980 · Legrand Dale N640JMMckinstray Joseph L KITFOX · S/N 299Cancelled Mar 18, 2013 · Exported to Canada · Built 1990 · Jameson John M N7689JPiper PA-28R-180 · S/N 28R-31090Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1969 N51299Corvus CORONE MK I · S/N CNE002Cancelled Jan 15, 2013 · Built 2005 · Benham Aviation LLC N58947Cessna 182P · S/N 18262418Cancelled Sep 27, 2012 · Sale reported, pending cancellation · Built 1973 N3808PPiper PA-22-150 · S/N 22-3497Cancelled Sep 21, 2012 · Sale reported, canceled · Built 1955 N4178BAero Commander 520 · S/N 520-85Cancelled Aug 1, 2012 · Sale reported, pending cancellation · Built 1953 N208NNCessna 208 · S/N 20800040Cancelled Jul 6, 2012 · Exported to Denmark · Built 1985 · Aircraft Structures International Corp N100TDCessna 170B · S/N 26135Cancelled May 4, 2012 · Registration expired, pending cancellation · Built 1953 · Williams James N428FCCessna 208B · S/N 208B0967Cancelled Nov 28, 2011 · Exported to Canada · Built 2002 · Aircraft Structures International Corp N17421Douglas A-24B · S/N 17421Cancelled Jul 13, 2011 · Expired dealer · Built 1943 · Windward Aviation Inc N10785Bell 206B · S/N 2926Cancelled Dec 16, 2010 · Sale reported, pending cancellation · Built 1980 N8183QMcnamara Timothy LASER 260 · S/N TM2Cancelled Feb 5, 2008 · Triennial form not returned · Gloc Inc N1LNNitschke Lance G DOMINATOR · S/N LN01Cancelled Jan 15, 2008 · Triennial form not returned · Built 2000 · Nitschke Lance G N12MCessna T337G · S/N P3370202Cancelled May 19, 2007 · Triennial form not returned · Built 1974 · Hollrah Kenneth R N590TACessna 208B · S/N 208B0590Cancelled Dec 15, 2006 · Exported to Australia · Aircraft Structurers International Corp N7885VMooney M20C · S/N 2847Cancelled May 25, 2006 · Exported to Mexico · Built 1964 · Aircraft Structures Inc N1218PCessna 208 · S/N 20800254Cancelled Aug 18, 2003 · Exported to Peru · Built 1996 · Aircraft Structures International Corp N3966VCessna 150M · S/N 15076668Cancelled Jan 17, 1997 · Second triennial mailing, no response · Northwest Aero Svc Inc N6655BCessna T210M · S/N 21062807Cancelled Nov 6, 1996 · Exported to Namibia · Advance Meat Co Inc N8299HPiper PA-32-301 · S/N 328106014Cancelled Oct 3, 1995 · Exported to South Africa · Dinsmore Charles E N83RJHerman Robert G Q-2 · S/N 2041Cancelled May 5, 1995 · Crain James B N188RSCessna 188A · S/N 18800708Cancelled Mar 18, 1993 · Triennial form not returned · Butler Ken R N2092BPiper PA-28-181 · S/N 287990118Cancelled Mar 8, 1993 N761RPCessna T210M · S/N 21062460Cancelled Sep 3, 1991 · Triennial form not returned · Fry R Kirk N757ZCCessna 152 · S/N 15280125Cancelled Jun 10, 1986 · Exported to United Kingdom · Le Grand Dale N9897ECessna 182P · S/N 18263957Cancelled Oct 15, 1981 · Sellers Aviation Co N39LCessna 340 · S/N 340-0210Cancelled May 6, 1981 · Built 1973 · Northcutt Chevrolet Co

Back to Enid, OK