Okc, OK

Cancelled registrations · 209

Query with SQL
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 = 'OKC'
  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.

N402AFCessna 402B · S/N 402B1337Cancelled Feb 1, 2018 · Sale reported, pending cancellation · Built 1978N147MPMooney M20L · S/N 26-0027Cancelled Jan 30, 2018 · Sale reported, pending cancellationN3523LCessna 182T · S/N 18280964Cancelled Sep 18, 2017 · Exported to Paraguay · Built 2001N9960PPiper PA-36-285 · S/N 36-7560071Cancelled Feb 19, 2016 · Exported to Uruguay · Built 1975N759VCCessna 182Q · S/N 18266285Cancelled Jun 15, 2015 · Exported to Lithuania · Built 1978N345VHRobinson Helicopter R22 BETA · S/N 2314Cancelled May 11, 2015 · Sale reported, canceled · Built 1993N684RACessna 150H · S/N 15068698Cancelled Sep 25, 2014 · Sale reported, pending cancellation · Built 1968N2196PPiper PA-23 · S/N 23-805Cancelled Sep 16, 2014 · Sale reported, pending cancellation · Built 1956N125DHHawker Siddeley BH.125-400A · S/N NA762Cancelled Aug 28, 2014 · Sale reported, pending cancellation · Built 1971N7133RSmith Jeffrey M ROBERTSON ACFT B1-RD · S/N 103Cancelled Sep 26, 2013 · Sale reportedN99VJSchempp-Hirth CIRRUS · S/N 5Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1967N86500Fokker D-7 · S/N 524Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1971N179SBBeech 65 · S/N LC-222Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1966N811RBeech C90A · S/N LJ-1131Cancelled Jun 14, 2013 · Exported to ParaguayN794MSix Chuter SKR II · S/N 2428Cancelled May 2, 2013 · Sale reported, pending cancellationN6551FCessna 150F · S/N 15063151Cancelled May 1, 2013 · Sale reported, pending cancellation · Built 1966N4018GHoover Todd CHALLENGER II STD · S/N CH2-0102-2184Cancelled Apr 30, 2013 · Sale reported, pending cancellation · Built 2002N83BHPiper PA-23-250 · S/N 27-3384Cancelled Apr 29, 2013 · Sale reported, pending cancellation · Built 1966N186JBBrecher John L BD-4 · S/N 361Cancelled Apr 26, 2013 · Sale reported, pending cancellation · Built 1986N1251RBellanca 14-19-3 · S/N 4340Cancelled Apr 18, 2013 · Sale reported, pending cancellation · Built 1967N2409NBoeing 737-242C · S/N 20496Cancelled Apr 17, 2013 · Sale reported, pending cancellationN4684RPiper PA-28-140 · S/N 28-21445Cancelled Apr 17, 2013 · Sale reported, pending cancellation · Built 1966N969VJDouglas DC-9-31 · S/N 47421Cancelled Apr 17, 2013 · Sale reported, pending cancellation · Built 1969N81AEClark Randolph L AMAX EAGLE · S/N 81AECancelled Apr 16, 2013 · Sale reported, pending cancellationN80480Carey Dennis EXEC · S/N 3007Cancelled Apr 12, 2013 · Sale reported, pending cancellationN511WQWright Ross W Q2 · S/N 2610Cancelled Apr 11, 2013 · Sale reported, pending cancellation · Built 1983N532PKWurzel Parsons-Keir ELITE LW RG · S/N 3RE057Cancelled Apr 11, 2013 · Sale reported, pending cancellationN83796Aeronca 7AC · S/N 7AC-2473Cancelled Apr 10, 2013 · Sale reported, pending cancellation · Built 1946N59NDCessna 152 · S/N 15285984Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1985N96DDPiper PA-23-250 · S/N 27-2057Cancelled Apr 9, 2013 · Sale reported, pending cancellation · Built 1962N6255YPiper PA-23-250 · S/N 27-3493Cancelled Apr 8, 2013 · Sale reported, pending cancellation · Built 1966N310NTNorth American NA-265-40 · S/N 282-77Cancelled Apr 2, 2013 · Sale reported, pending cancellation · Built 1966N4444XCessna 172L · S/N 17259490Cancelled Apr 2, 2013 · Sale reported, pending cancellation · Built 1970N7083DAntonov AN-2 · S/N 1G17602Cancelled Mar 26, 2013 · Sale reported, pending cancellation · Built 1977N7083EAntonov AN-2 · S/N 1G17344Cancelled Mar 26, 2013 · Sale reported, pending cancellation · Built 1977N72846Cessna 140 · S/N 10033Cancelled Mar 25, 2013 · Sale reported, pending cancellation · Built 1946N91SDChalmers / Grove CG-1 SUNDANCER · S/N GR-12Cancelled Mar 20, 2013 · Sale reported, pending cancellationN94813Engineering & Research ERCOUPE 415-E · S/N 4926Cancelled Mar 11, 2013 · Sale reported, pending cancellation · Built 1948N311VCessna 310C · S/N 35933Cancelled Mar 7, 2013 · Sale reported, pending cancellation · Built 1959N6978YPiper PA-23-250 · S/N 27-4346Cancelled Feb 26, 2013 · Sale reported, pending cancellation · Built 1969N395DSSteeves Davis W KR-2 · S/N 1394Cancelled Feb 21, 2013 · Sale reported, pending cancellation · Built 1988N65264Boeing A75N1(PT17) · S/N 75-381Cancelled Feb 20, 2013 · Sale reported, pending cancellation · Built 1942N219ERRolando Emil RANS CO S-7 COURIER · S/N S786002Cancelled Feb 11, 2013 · Sale reported, pending cancellationN61103Cessna 150J · S/N 15070802Cancelled Feb 8, 2013 · Sale reported, pending cancellation · Built 1969N321HSShehane Harold L SHA-GLASAIR · S/N 359Cancelled Jan 30, 2013 · Sale reported, canceledN4391CPiper PA-46-310P · S/N 46-8508053Cancelled Dec 7, 2012 · Sale reported, pending cancellation · Built 1985N265SHBell 206L-3 · S/N 51447Cancelled Nov 27, 2012 · Sale reported, canceledN9377DPiper PA-28-161 · S/N 28-7916319Cancelled Nov 20, 2012 · Sale reported, pending cancellation · Built 1979N80954Globe GC-1B · S/N 1147Cancelled Nov 9, 2012 · Sale reported, pending cancellation · Built 1946N8113TCessna 175B · S/N 17556813Cancelled Nov 9, 2012 · Sale reported, pending cancellation · Built 1960
Back to Okc, OK