OpenAirDocs.org
Lawton, OK

Cancelled registrations · 78

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

N1747KLuscombe 8E · S/N 4474Cancelled Jul 18, 2023 · Expired dealer · Farley Joe DBAN38978Boeing A75N1(PT17) · S/N 75-3756Cancelled May 10, 2023 · Assigned, pending cancellation · Farley Joe DBAN6751ACessna 172 · S/N 28851Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1956 · Walker Fred L JrN9855KStinson 108 · S/N 1082855Cancelled Jan 14, 2019 · Revoked, canceled · Built 1947 · Leonard Everett RN15MDBeech 58 · S/N TH-441Cancelled Jun 15, 2018 · Second renewal notice · Built 1974 · Cobra Kai IncN855TBeech E-55 · S/N TE-928Cancelled Jun 15, 2018 · Second renewal notice · Built 1973 · Cobra Kai IncN4284XFarmer Robert F RANS S7 COURIER · S/N 0294131Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Farmer Robert FN777TBPiper PA-23-160 · S/N 23-1286Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1958 · Dawes JamesN8460UCessna 172F · S/N 17252360Cancelled Feb 4, 2017 · Revoked, canceled · Built 1965 · Hilltop Aviation IncN5118RBeech B19 · S/N MB-653Cancelled Feb 18, 2016 · Second renewal notice · Built 1974 · Steinbroner Daniel JN1975RRaven S55A · S/N S55A-103Cancelled May 12, 2015 · Registration expired, pending cancellation · Built 1972 · Holden PhilipN81004Commonwealth REARWIN 185 · S/N 1800Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1946 · Jewett Gary EN662PLSocata TB 10 · S/N 0165Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1980 · Driggers David JN95971Taylorcraft BC12-D · S/N 8271Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1946 · Sexton Rick PN90709Fairchild F-27 · S/N 04406-86Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1960 · Land Air Sales And Leasing IncN74030Cameron Balloons US O-84 · S/N 5119Cancelled May 10, 2013 · Sale reported, canceledN6685LLake LA-4-200 · S/N 448Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1970 · Wilkerson TomN6281KCessna 150M · S/N 15077623Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1975 · Gunter Cecil TN3570WPiper PA-32-260 · S/N 32-462Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1966 · Wilkerson TomN54376Ryan Aeronautical ST3KR · S/N 1289Cancelled Mar 25, 2013 · Sale reported, pending cancellation · Built 1941N8735KStinson 108-1 · S/N 108-1735Cancelled Nov 15, 2012 · Sale reported, pending cancellation · Built 1947N3265RPiper PA-28R-180 · S/N 28R-31256Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1970 · Dossey Clifford CN332BBeech D50A · S/N DH-178Cancelled Sep 11, 2012 · Sale reported, canceled · Built 1958N53173Ryan Aeronautical ST3KR · S/N 2149Cancelled Aug 14, 2012 · Revoked, canceled · Built 1942 · Reed Robert SN4435UCessna 150D · S/N 15060435Cancelled Jul 9, 2012 · Revoked, canceled · Built 1964 · Hilltop Aviation IncN4853FPiper PA-28-151 · S/N 28-7715073Cancelled Sep 12, 2011 · Revoked, canceled · Built 1976 · American Technical Institute IncN36JSan Antonio MIDGET MUSTANG · S/N 552Cancelled Jan 5, 2011 · Revoked, pending cancellation · Northern Earnest AN12614Cessna 172M · S/N 17262114Cancelled Aug 2, 2010 · Triennial form not returned · Built 1973 · Ross Donald MN101BHConsolidated Vultee L-13 · S/N 47-405Cancelled Jun 25, 2009 · Registration revoked · Built 1951 · Land Air Sales And Leasing IncN7303ECessna 210 · S/N 57003Cancelled May 22, 2007 · Built 1959 · Steinbroner Daniel JN4883RCessna A188B · S/N 18802402TCancelled Dec 17, 2004 · Exported to Brazil · Built 1975N1087HPiper PA-28R-201T · S/N 28R-7703013Cancelled Dec 8, 2003 · Blount James J JrN63438Cessna 150M · S/N 15077314Cancelled Jan 26, 1998 · Triennial form not returned · Dossey Clifford CN7099ACessna 172 · S/N 29199Cancelled Jun 7, 1996 · Triennial form not returned · Sanders George PN7314VBellanca 17-30 · S/N 30169Cancelled Jun 6, 1984 · Buick Cecil LawsonN38487Piper PA-32R-300 · S/N 32R7780434Cancelled Aug 12, 1983 · Built 1977 · Trey Investments IncN8NWCessna 421C · S/N 421C0479Cancelled Jan 19, 1983 · Northrop Worldwide Aircraft Services IncN7NWCessna 421C · S/N 421C0350Cancelled Jan 18, 1983 · Northrop Worldwide Aviation Services IncN3955UCessna 150E · S/N 15016355Cancelled May 7, 1981 · Built 1965 · Hilltop Aviation IncN86547Cessna A188B · S/N 18802017TCancelled Apr 10, 1981 · Holcomb Charles NN38140Piper PA-28R-201 · S/N 28R-7737080Cancelled Jan 13, 1978 · Built 1977 · Air American Aviation IncN8822LPiper PA-25-235 · S/N 25-5329Cancelled Jun 21, 1977 · Dennis Leatherbury IncN2939BBeech E18S · S/N BA-82Cancelled Nov 11, 1975 · Southern Aviation IncN9578ZBeech C-45H · S/N AF-296Cancelled Sep 27, 1974 · Southern Aviation IncN14424Beech 18S · S/N CA-155Cancelled May 20, 1974 · Southern Aviation IncN40225Piper PA-23-250 · S/N 27-7305024Cancelled Apr 12, 1974 · Exported to United Kingdom · Southern Aviation IncN5224XChampion 7KCAB · S/N 202Cancelled Aug 31, 1973 · Exported to Canada · Southern Aviation IncN7539GCessna 172L · S/N 1725239Cancelled Apr 19, 1973 · Built 1970 · Throckmorton Richard LN5168SPiper PA-28-180 · S/N 28-7105022Cancelled Feb 2, 1973 · Exported to United Kingdom · Southern Aviation IncN742FLPiper PA-28-140 · S/N 28-7225587Cancelled Jan 11, 1973 · Exported to United Kingdom · Built 1972 · Southern Aviation Inc
Back to Lawton, OK