Enid, OK

Cancelled registrations · 98

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

N3735VWheeler PAZMANY PL-2 · S/N 86Cancelled May 5, 1981 · Wheller Norris GN11150Cessna 150L · S/N 15075226Cancelled Dec 20, 1979 · Sanders Lee MN38187Great Lakes 2T-1A-2 · S/N 0786Cancelled Dec 5, 1977 · Exported to Germany · Great Lakes Aircraft CompanyN28RBPiper PA-23 · S/N 23-490Cancelled Sep 29, 1977 · Exported to Canada · Cooper PressleyN4657KCessna 182P · S/N 18263659Cancelled Jul 8, 1977 · Built 1975 · Legrand DaleN4474VBeech 35 · S/N D-1292Cancelled Jul 7, 1977 · Built 1948 · Pressley Cooper DBA Dek HandN55481Piper PA-28-140 · S/N 287325413Cancelled Nov 8, 1976 · Enid Air IncN1KGHill TINY HAWK P6E · S/N 1Cancelled Jul 1, 1976 · Hill John SN66438Cessna 150M · S/N 15076050Cancelled Feb 17, 1976 · Exported to Canada · Sellers Aviation CoN66130Cessna 150M · S/N 15075858Cancelled Feb 13, 1976 · Exported to Canada · Sellers Aviation CoN215PBBeech D18S · S/N A-190Cancelled Sep 12, 1975 · Built 1946 · Cooper Pressley Cooper DBA DekhandN41763Piper PA-28-140 · S/N 28-7425282Cancelled Mar 27, 1975 · Sale reported · Built 1974N56068Piper PA-34-200 · S/N 34-7350279Cancelled May 6, 1974 · Transcontinental Steel IncN5241QCessna 150L · S/N 150-73141Cancelled Jul 20, 1973 · Built 1972 · Sellers Aviation CompanyN3776PPiper PA-18A 150 · S/N 18-4664Cancelled Feb 25, 1972 · Hirst Flying ServiceN34472Aeronca 65-CA · S/N C14911Cancelled Aug 27, 1971 · Riesen Fred LN3735VWheeler PAZMANY PL-1 · S/N 202Cancelled Mar 31, 1971 · Wheeler Norris GN6208BAero Commander 680 · S/N 680-601-236Cancelled Sep 3, 1970 · Oven Helen CN4706APiper PA-18-150 · S/N 18-4923Cancelled Jul 10, 1970 · Dickson Flying Service IncN1344ZBeech 95-55 · S/N TC117Cancelled Jun 29, 1970 · Clay Northcutt Chevrolet IncN1053BMooney M20A · S/N 1280Cancelled Feb 21, 1968 · Exported to Thailand · Clothier Jim CN43520Taylorcraft BC12-D · S/N 7179Cancelled Jul 25, 1966 · Flood Donald And Trenton Dwain LN8265HCallair A-9 · S/N 1138Cancelled Sep 29, 1965 · Mcginnis Carl EN50863Taylorcraft DCO-65 · S/N 4606Cancelled Aug 5, 1965 · Atrc Aero Club IncN2528BPiper PA-18 · S/N 18-911Cancelled May 25, 1965 · U S Air ForceN83867Champion AERONCA 7AC · S/N 7AC-2548Cancelled May 22, 1965 · Lentz Flying ServiceN33782Aeronca 65-TL · S/N 9541TCancelled May 21, 1965 · Cunningham WilliamN6039ZPiper PA-25 · S/N 25-46Cancelled Sep 29, 1960 · Hirst CharlesN3383KGlobe GC-1B · S/N 1376Cancelled Oct 5, 1955 · Shuman M SN39628Fleet 16B · S/N 508Cancelled Jun 9, 1954 · Exported to Mexico · Clarence LeachmanN92460Piper J3C-65 · S/N 16930Cancelled Aug 14, 1951 · Hirst Charley MN26699Taylorcraft BL-65 · S/N 2041Cancelled Apr 27, 1951 · Board Of EducationN1622KLuscombe 8A · S/N 4349Cancelled Mar 9, 1951 · Vacin-Hirst Flying ServiceN3125EAeronca 7AC · S/N 7AC-6722Cancelled May 22, 1950 · Shuman Ruby AN74660Cessna T-50 · S/N 2592Cancelled May 1, 1950 · Built 1943 · Hirst Charley MN21489Piper J3C-50 · S/N 2340Cancelled Jan 16, 1950 · Built 1938 · Nordman Harold O And Downing William LeviN96647Taylorcraft BC12-D · S/N 8947Cancelled Aug 3, 1949 · Whitbeck William BN3126EAeronca 7AC · S/N 7AC-6723Cancelled Jun 3, 1949 · Loren Carlberg Flying ServiceN92147Piper J3C-65 · S/N 16589Cancelled Apr 29, 1949 · Hirst Charley MN39199Taylorcraft BC12-D · S/N 6453Cancelled Sep 16, 1948 · Vacin Hurst Flying ServiceN39376Aeronca 65-TAL · S/N L4442TACancelled Sep 3, 1948 · Built 1942 · Hirst Charley WN33560Piper J3C-65 · S/N 14037Cancelled Aug 26, 1948 · Vacin-Hirst Flying ServiceN18787Beech E17B · S/N 212Cancelled May 12, 1948 · Built 1938 · Dillingham Tom GN72175Cessna 140 · S/N 9344Cancelled Sep 2, 1947 · Pratt Roy ON400Thomas Morse S4C · S/N 4488Cancelled Jan 7, 1933 · Quilling L JN2226Curtiss Aeroplane & Motor CURTISS JN-4D · S/N 10-AL SUBCancelled Dec 28, 1932 · Built 1917 · Kessner WilbertN999NNorthrop Glider NORTHROP ONE · S/N PT-1 SUBCancelled Oct 4, 1932 · Richard J MeisN327Lincoln STANDARD 5 · S/N 111Cancelled Mar 20, 1930 · Ross T Martin & Paul M Cozier
Back to Enid, OK