OpenAirDocs.org
Jenks, OK

Cancelled registrations · 43

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

N28772Luscombe 8A · S/N 1533Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1940 · Dittmer Michael CN2811TBogle Loyd D CUBBY · S/N 0092041Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Bogle Loyd DN6041PPiper PA-24-250 · S/N 24-1137Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1959 · Sutliff Sherman CN4916UCessna 210E · S/N 21058616Cancelled Jan 16, 2014 · Exported to Bolivia · Built 1965 · Check 6 IncN5418LGrumman American Avn. AA-5 · S/N AA5-0398Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1973N201YAYakovlev YAK-55M · S/N 961004Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Riverside Red Star LlpN25157Kirchner PIETENPOL AIRCAMPER · S/N 113EHKCancelled Aug 6, 2013 · Sale reported, canceled · Built 1978N7178YPiper PA-30 · S/N 30-198Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1963N140MGMike Garrett Building FALCON XP · S/N 600185Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1986 · Smith Eugene CN95408Piper PA-28-140 · S/N 28-25927Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1969 · Cypert Gerald DBAN135RSSchweizer SGS 1-35C · S/N 68Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1976N55230Bell H-13 · S/N 51-14175Cancelled Jan 31, 2013 · Sale reported, canceled · Built 1951N221VAPiper PA-24-260 · S/N 24-4375Cancelled Mar 18, 2011 · Expired dealer · Built 1966 · Stevenson Red DBAN1094CMooney M20A · S/N 1365Cancelled Jan 3, 2011 · Expired dealer · Built 1959 · Cypert Gerald DBAN1589UCessna U206F · S/N U20602267Cancelled Jan 3, 2011 · Expired dealer · Built 1973 · Cypert Gerald DBAN47GYBell 47G-2 · S/N 2207Cancelled Jan 3, 2011 · Expired dealer · Built 1958 · Cypert Gerald DBAN29057Cessna TU206C · S/N U206-1041Cancelled Sep 3, 2003 · Built 1968 · Stevenson Red DBAN5393QPiper PA-23-250 · S/N 27-7305009Cancelled Sep 3, 2003 · Built 1973 · Stevenson Red DBAN732CKCessna T210L · S/N 21061408Cancelled Sep 3, 2003 · Built 1976 · Stevenson Red DBAN759XSCessna 182Q · S/N 18266346Cancelled Sep 3, 2003 · Second triennial mailing, no response · Built 1978 · Stevenson Red DBAN8716QCessna TU206F · S/N U20603469Cancelled Sep 3, 2003 · Second triennial mailing, no response · Built 1976 · Stevenson Red DBAN951ECessna 210A · S/N 21057832Cancelled Sep 3, 2003 · Built 1961 · Stevenson Red DBAN128BBell 47B · S/N 48Cancelled Aug 19, 2003 · Second triennial mailing, no response · Built 1947 · Stevenson Red DBAN4538PPiper PA-23-250 · S/N 27-42Cancelled Aug 19, 2003 · Built 1960 · Stevenson Red DBAN6497KCessna 172P · S/N 17274203Cancelled May 9, 2000 · Robertson James RN8314ZPiper PA-34-200T · S/N 34-8170070Cancelled Jul 21, 1999 · Exported to Canada · Cypert Gerald DBAN24PSBeech C24R · S/N MC681Cancelled May 29, 1998 · Triennial form not returned · Robertson James RN57ARCessna 182L · S/N 18259210Cancelled Aug 19, 1996 · Exported to Mexico · Cypert GeraldN3809QBeech C24R · S/N MC748Cancelled Jun 22, 1994 · Triennial form not returned · Robertson James RN6284DCessna 172N · S/N 17272691Cancelled Jan 7, 1994 · Exported to Turkey · Cypert Gerald DBAN5347DCessna 172N · S/N 17272535Cancelled Nov 12, 1992 · Exported to Germany · Cypert Gerald DBAN45458Cessna 150M · S/N 15076933Cancelled Oct 16, 1992 · Triennial form not returned · Robertson James RN3536WPiper PA-32-260 · S/N 32423Cancelled May 28, 1992 · Exported to Aruba · Cypert Gerald DBAN4329KPiper PA-28-181 · S/N 288490020Cancelled Mar 25, 1992 · Exported to Sweden · Cypert Gerald DBAN758TECessna R172K · S/N R1723341Cancelled Jul 24, 1991 · Exported to Chile · Cypert Gerald DBAN2778PDiehl Dan DIEHL ECSTACY · S/N 001Cancelled Mar 25, 1991 · Triennial form not returned · Diehl Daniel RN3011QPiper PA-28R-201T · S/N 28R7703086Cancelled Dec 18, 1990 · Exported to United Kingdom · Cypert Gerald DBAN759GSCessna 182Q · S/N 18265988Cancelled Mar 21, 1986 · Exported to Iceland · Stevenson RedN272FCColt Balloons 21A · S/N 469Cancelled Jun 29, 1983 · Capps Frank FN66389Cessna 150M · S/N 15076013Cancelled Apr 18, 1983 · Robertson James RN993PKPiper PA-28-140 · S/N 28-22698Cancelled May 6, 1975 · Richardson B JN6575QAlon A2 · S/N A-75Cancelled Feb 1, 1972 · Doyle Nancy A RN1609VCessna 140 · S/N 13781Cancelled Jan 29, 1953 · Freeman Louis F
Back to Jenks, OK