Skip to content

Cancelled registrations · 42

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

N6714FCessna 150F · S/N 15063314Cancelled Jul 1, 2023 · Registration pending, canceled · Built 1966 N119SSCessna 150M · S/N 15077934Cancelled Mar 9, 2022 · Built 1976 · Southeastern Oklahoma State University N484GRDJI PHANTOM 3 PROFESSION · S/N P76DCF15016849Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Ray Gary W Jr N2789GCessna 182B · S/N 52089Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Collins Jaime D N192ECPiper PA-32RT-300T · S/N 32R-7887109Cancelled May 29, 2020 · Registration expired, pending cancellation · White Nathan S N6852TDJI PHANTOM 3 PROFESSION · S/N P76DCF18010137Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Texoma Aerial Solutions LLC N67976Bell 206B · S/N 5236Cancelled Dec 17, 2018 · Registration expired, pending cancellation · Built 1995 · Bryan County Sheriffs Office N20717Bell OH-58A · S/N 71-20717Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Bryan County Sheriffs Office N7364TCessna R182 · S/N R18200032Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1977 · Southeastern Oklahoma State University N3648CCessna R182 · S/N R18200294Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1978 · Southeastern Oklahoma State University N73828Cessna 172N · S/N 17267704Cancelled Feb 4, 2017 · Revoked, canceled · Built 1976 · Big E Industries Inc N158BRBell OH-58C · S/N 68-16982Cancelled Jul 15, 2015 · Bryan County Sherriffs Office N502AFAero Falcon Intl KNIGHT FALCON · S/N 600501Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Aero Falcon International Inc N5757KBeech V35 · S/N D-8090Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1966 · Lewis Russell R N4514PPiper PA-23-250 · S/N 27-17Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1960 · Rivera Joe N29662Taylorcraft BC-65 · S/N 2506Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1940 · Smith Ronald B N650JXBritish Aerospace BAE JETSTREAM 3101 · S/N 650Cancelled Sep 29, 2011 · First United Bank N653JXBritish Aerospace BAE JETSTREAM 3101 · S/N 653Cancelled Aug 30, 2011 · Built 1985 · First United Bank N541SBAmerican Champion 7ECA · S/N 1403-2009Cancelled Mar 8, 2011 · Exported to Canada · Built 2009 · Owens Aviation Inc N1244PPiper PA-23 · S/N 23-266Cancelled Jun 22, 2009 · Registration revoked · Built 1955 · Southeastern Oklahoma State University N7227LPiper PA-31-350 · S/N 31-8152008Cancelled Mar 15, 2006 · Exported to Canada · Built 1980 · Staff One Inc N116SSCessna 152 · S/N 15282334Cancelled Nov 21, 2005 · Triennial form not returned · Built 1978 · Southeastern University N114SSCessna 152 · S/N 15283663Cancelled Jul 30, 2001 · Triennial form not returned · Southeastern University N900DLLearjet 24 · S/N 24109Cancelled Nov 21, 1997 · Exported to Mexico · Wings Sales Inc N69008Cessna 152 · S/N 15282428Cancelled Aug 20, 1992 · Triennial form not returned · Southeastern University N139BTBritten-Norman BN-2A-8 · S/N 139Cancelled Nov 6, 1991 · Exported to Israel · I A Aviation Co N1019MCessna 150J · S/N 15070999Cancelled Sep 20, 1991 · Bestway Aviation 2 N6582YPiper PA-23-250 · S/N 273882Cancelled Jun 14, 1991 · Exported to Israel · Carrington John DBA N33473Hiller H-23D · S/N 61-3211Cancelled May 20, 1976 · Southeastern Oklahoma State University N50109Cessna 150H · S/N 15069067Cancelled Apr 27, 1972 · Exported to Canada · Built 1968 · Sam Turner Flying Service Inc N7347Bowers Fly Baby 1-A · S/N 65-6Cancelled Aug 3, 1971 · Edwards William S N2122DBeech D35 · S/N D-3467Cancelled Dec 4, 1970 · R C Dohe N1702EAeronca 7AC · S/N 7AC-5267Cancelled Apr 17, 1959 · Built 1946 · Truby Wilbur J/Riddle Oliver T N70120Piper J3C-65 · S/N 17098Cancelled Feb 21, 1955 · John L Bates N95455Consolidated Vultee BT-13A · S/N 6477Cancelled Apr 15, 1953 · Maxey Cecil N88093Piper J3C-65 · S/N 15710Cancelled Nov 6, 1951 · Bates John L N59481Consolidated Vultee BT-13A · S/N 5399Cancelled Oct 23, 1951 · W M Carter N75580Consolidated Vultee BT-13A · S/N 10330Cancelled Dec 22, 1949 · Built 1943 · Campbell James C N80790Globe GC-1A · S/N 193Cancelled Mar 23, 1949 · Built 1946 · Kee William H DBA N75571Consolidated Vultee SNV-1 · S/N 5937Cancelled Aug 13, 1948 · Built 1942 · Creamer Phillip Dan N75515Fairchild PT-26 M62A3 · S/N FZ342Cancelled Oct 9, 1947 · Built 1943 · Durant Flying Club N19759Aeronca K · S/N K-275Cancelled Mar 15, 1941 · National Airways Inc

Back to Durant, OK