Beaumont, TX

Cancelled registrations · 151

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 = 'TX' AND d.registrant_city = 'BEAUMONT'
  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.

N150WMCessna 150M · S/N 15079087Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1976 · Beaumont Wings IncN4625RPiper PA-28-140 · S/N 28-21376Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1966 · Hodge Cecil H JrN51JJohnson GYRO COPTER · S/N 1Cancelled Sep 18, 2012 · Revoked, canceled · Built 1963 · Johnson J AN8812RDowner BELLANCA 14-19-3 · S/N 4164Cancelled Sep 10, 2012 · Revoked, canceled · Built 1959 · Dorr W EN7107SHoffman Thomas R CHALLENGER I · S/N TRH0436Cancelled Aug 27, 2012 · Registration pending, canceled · Built 1996N2592MBalloon Works FIREFLY 7-15 · S/N F7-794Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1992 · Novelli William J JrN9297ACessna 170A · S/N 19058Cancelled Mar 11, 2009 · Triennial form not returned · Built 1949 · Evans Richard NN712EBeech A65 · S/N LC-241Cancelled Dec 1, 2007 · Triennial form not returned · Built 1966 · Olsen John DN761FLCessna 210M · S/N 21062221Cancelled Jul 21, 2006 · Exported to Paraguay · Built 1977 · Chenault BryanN770AJBeech C90A · S/N LJ1272Cancelled Mar 17, 2005 · Exported to Brazil · Built 1991 · Sweet Double S Ranch IncN9273TBell OH-58C · S/N 71-20495Cancelled Jan 5, 2005 · Triennial form not returned · Built 1971 · Jefferson County Sheriffs DepartmentN7038VMooney M20F · S/N 22-1385Cancelled Sep 1, 2000 · Tortorice Jay VN156SDCessna 310J · S/N 310J0156Cancelled Apr 12, 1999 · Triennial form not returned · Jefferson County Sheriffs DeptN1027TAir Tractor AT-402 · S/N 4020741Cancelled Dec 5, 1997 · Exported to Mexico · M And M Air Service Of Beaumont IncN28738Luscombe 8A · S/N 1499Cancelled May 20, 1997 · Bergeson John SN7804TCessna 172A · S/N 47404Cancelled Jul 23, 1996 · Triennial form not returned · Hart Iva TN7734ZPiper PA-25-235 · S/N 253909Cancelled Mar 15, 1996 · Exported to Canada · M And M Air Service Of Beaumont IncN4134XAero Commander 100 · S/N 233Cancelled Mar 20, 1995 · Triennial form not returned · Chenault E BryanN585DKr-1 DARST EUGENE · S/N 5444Cancelled Mar 7, 1994 · Triennial form not returned · Darst EugeneN153QBeech 95-B55 (T42A) · S/N TC761Cancelled Sep 27, 1993 · Larocca Victor TimothyN2648GCessna 182B · S/N 51948Cancelled Feb 17, 1993 · Exported to Canada · Proctor E RayN920RESatterwhite Ramon RALLY 3 · S/N 25258Cancelled Apr 1, 1991 · Triennial form not returned · Satterwhite Ramon SN2436FPiper PA-38-112 · S/N 38-79A0439Cancelled Apr 29, 1983 · Built 1979 · Professional Aviation Service CoN756WDCessna U206G · S/N U20604407Cancelled Aug 10, 1982 · Kelley Charles SN4326Grumman G-164A · S/N 1039Cancelled Mar 2, 1982 · Built 1973 · Mitchell George FN5388Grumman Acft ENG Cor-Schweizer G-164A · S/N 1146Cancelled Mar 2, 1982 · M & M Service Of Beaumont IncN2615CCessna 310 · S/N 35015Cancelled Sep 30, 1981 · Weidman Frank T & BettyN7192VMooney M20F · S/N 22-1190Cancelled Feb 9, 1976 · South Texas Mooney SalesN3238PPiper PA-23-160 · S/N 23-1183Cancelled Jun 11, 1975 · Built 1957 · Precision Control & Monitor IncN38252Piper J5A · S/N 18-7567Cancelled Jun 2, 1975 · Built 1941 · Mccormick James EN38252Piper J5A · S/N 5-924Cancelled Jun 2, 1975 · Built 1941 · Mccormick James EN84612Cessna 172K · S/N 17258547Cancelled Nov 13, 1974 · Built 1969 · Ranger Insurance CoN8262UCessna 172F · S/N 17252162Cancelled Sep 30, 1974 · Underwriters Adjustments Bureau IncN4546NBoeing E75 · S/N 75-5195Cancelled Jun 6, 1974 · Built 1947 · Mitchell George F JrN59750Boeing E75 · S/N 75-4703Cancelled May 29, 1974 · Mitchell George F JrN5223PPiper PA-24 · S/N 24-250Cancelled Jul 11, 1973 · Cap Aero Club IncN917HPPiper PA-28-140 · S/N 28-24440Cancelled Jun 25, 1973 · Matheny Michael DN6700GCessna 150L · S/N 15072200Cancelled Apr 29, 1972 · Sheffield Lee DBA Beaumont Municipal AirportN593TSmith B-7M · S/N 1Cancelled Jan 26, 1972 · M H SmithN70965Piper J3C-65 · S/N 17992Cancelled Dec 17, 1971 · York W WN5362NBoeing E75 · S/N 75-5795Cancelled Sep 16, 1971 · Built 1949 · Mitchell Geoge F JrN36342Taylorcraft DC-65 · S/N 4079Cancelled Apr 28, 1971 · Built 1941 · Beard John/Ellis J A/Lester S CN7502ZPiper PA-25-235 · S/N 25-3529Cancelled Feb 25, 1971 · Mitchell George F JrN4984YPiper PA-25-235 · S/N 25-4790Cancelled Jan 6, 1971 · Mitchell Jr George FN5350NBoeing E75 · S/N 75-5070Cancelled Aug 18, 1970 · Mitchell George FN1207BLuscombe 8A · S/N 5834Cancelled Jun 29, 1970 · Dugat Cloyd JrN9296MMooney M20E · S/N 1229Cancelled Jun 25, 1970 · Beaumont Air Taxi Service IncN28098Piper J3F-60 · S/N 4576Cancelled Jun 16, 1970 · Brown J WN3072XCessna 150F · S/N 15064472Cancelled Jun 16, 1970 · Golden Triangle Flyers IncN968QBeech 65 · S/N LC-120Cancelled Jun 28, 1968 · Service Painting Co Of Beaumont
Back to Beaumont, TX