Skip to content

Cancelled registrations · 52

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

N9414RSnow S2B · S/N 1044Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1960 · Dickenson M J N3053KCulver V · S/N V272Cancelled Jan 6, 2020 · Revoked, canceled · Built 1946 · Moore Ernest W N9336NPiper PA-28R-200 · S/N 28R-35036Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1969 · Bruhn Gloria F N4064TBalloon Works FIREFLY 7 · S/N 10004Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 1979 · Claypole David C N9492RSnow S2C · S/N 1132CCancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1962 · Dickenson Rollo U N1774SAero Commander 600 S-2D · S/N 600-1412DCancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1967 · Dickenson Rollo V N8319PPiper PA-24-250 · S/N 24-3570Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1963 · Schlecht James C N4876KRyan NAVION A · S/N NAV-4-1876Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1949 · Phillips Steven A N5155ECessna 172N · S/N 17271741Cancelled Nov 13, 2013 · Registration expired, pending cancellation · Built 1978 · Chickasha Aviation Center Inc N1384VBoeing E75 · S/N 75-8464Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1943 · De Dickenson Gabriela Arroyo N7236TCessna 172A · S/N 46836Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1959 · Stallion Trailer Kits Inc N66DBBrooks BUSHBY MUSTANG II · S/N 205Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1972 · Baley Judy S N90488Balloon Works FIREFLY 8B · S/N B838-3-SCancelled May 8, 2007 · Triennial form not returned · Built 1989 · Claypole David C N8225KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 619-BCancelled Aug 7, 2006 · Triennial form not returned · American Dusting Co Inc N4608QCessna 152 · S/N 15285041Cancelled Sep 19, 2001 · Triennial form not returned · Hector George H Jr N6364ECessna 172 · S/N 46464Cancelled Nov 26, 1997 · Triennial form not returned · Johnson Tracy L N5188NBoeing E75 · S/N 755728Cancelled Aug 9, 1991 · Triennial form not returned · John W David Unit 6 Inc N53394Boeing E75 · S/N 755464Cancelled Jul 30, 1985 · Chickasha Flying Service N5189NBoeing E75 · S/N 755610Cancelled Jan 23, 1979 · Frye King & Erwin N55217Boeing E75 · S/N 75072Cancelled Jan 23, 1979 · Chickasha Flying Service N59853Boeing A75N1 · S/N 75-3456Cancelled Jan 23, 1979 · Chickasha Flying Service N1680MBoeing B75N1 · S/N 75-7857Cancelled Jan 19, 1979 · Amdco Inc N5216NBoeing E75 · S/N 755839Cancelled Jan 17, 1979 · Amdco Inc N64631Boeing A75N1 · S/N 75-3513Cancelled Jan 17, 1979 · Amdco Inc N6688ZPiper PA-25-235 · S/N 252301Cancelled Jan 31, 1977 · Amdco Inc N9771VCessna A188 · S/N 188-0221Cancelled Jan 31, 1977 · Amdco Inc N3502QCessna A188 · S/N 188-0452Cancelled Nov 15, 1976 · Amdco Inc N90045Cessna 140 · S/N 9103Cancelled Sep 25, 1974 · Saxon Luther W N7508Boeing E75 · S/N 75-5837Cancelled Sep 5, 1974 · Exported to Mexico · Chickasha Flying Service N7509Boeing E75 · S/N 75-5959Cancelled Sep 5, 1974 · Exported to Mexico · Chickasha Flying Service N7512Boeing E75 · S/N 75-5870Cancelled Sep 5, 1974 · Chickasha Flying Service N7513Boeing E75 · S/N 75-5977Cancelled Sep 5, 1974 · Chickasha Flying Service N5177NBoeing PT-13D · S/N 755910Cancelled Aug 5, 1974 · Frye King And Erwin N5650JCessna A188A · S/N 18800600Cancelled Oct 24, 1972 · Exported to Mexico · Amdco Inc N5185NBoeing E75 · S/N 75-5950Cancelled May 2, 1972 · Frye King & Erwin N2117EAeronca 7AC · S/N 7AC5688Cancelled Dec 20, 1970 · Hector George N31827Aeronca 65-CA · S/N CA-11160Cancelled Aug 31, 1970 · Robert J Bitsche N9870YChampion 7GCB · S/N 7GCB-80Cancelled Jun 26, 1970 · Amdco Inc N5184NBoeing E75 · S/N 75-5724Cancelled Dec 26, 1968 · Frye King & Erwin N7500Boeing E75 · S/N 75-5817Cancelled Dec 26, 1968 · Exported to Mexico · Chichasha Flying Service N7502Boeing E75 · S/N 75-5971Cancelled Dec 26, 1968 · Exported to Mexico · Chiackasha Flying Service N7504Boeing E75 · S/N 75-5979Cancelled Dec 26, 1968 · Exported to Mexico · Chickasha Flying Service N7506Boeing E75 · S/N 75-5871Cancelled Dec 26, 1968 · Exported to Mexico · Chickasha Flying Service N38829Piper J3L-65 · S/N 7316Cancelled May 20, 1965 · Thompson Clayton E N5192NBoeing E75 · S/N 75-5739Cancelled Mar 17, 1958 · Frye King N77178Cessna 140 · S/N 11640Cancelled Apr 18, 1955 · Story Dewey N47735Taylorcraft DCO-65 · S/N L-4859Cancelled Nov 6, 1951 · Built 1943 · Boles J W Et Al N5272MTaylorcraft BC12-D · S/N 10572Cancelled Mar 9, 1951 · Built 1948 · Griffin Travis W N86710Bellanca 14-13 · S/N 1071Cancelled Mar 25, 1949 · Roy E Emanuel N292Dayton Wright STANDARD J-1 · S/N I-292Cancelled Mar 26, 1928 · Built 1917 · Chickasha Aero Corporation

Back to Chickasha, OK