OpenAirDocs.org
Hurst, TX

Cancelled registrations · 91

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

N3953NBeech 35 · S/N D-1213Cancelled May 17, 2023 · Built 1947 · Weaver Clyde WN719AADJI INSPIRE 1 · S/N W130CD16030847Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Aspect Aero IncN137RDDJI INSPIRE 1 PRO · S/N W2ACI27010246Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Dauphinais Raymond KN157JSJay E Smith BD-4 · S/N 01Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Smith Jay EN136RDDJI PHANTOM 2 VISION + · S/N PV331PH645339530Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Dauphinais Raymond KN8009YSix Chuter SR7 · S/N A 10 LFBCancelled Feb 26, 2019 · Registration expired, pending cancellation · Built 2001 · Hocker Jimmie CN9203LAmerican AA-1A · S/N AA1A-0103Cancelled Dec 20, 2018 · Registration expired, pending cancellation · Built 1971 · Galindo John SN38891Piper J4A · S/N 41585Cancelled Dec 6, 2018 · Revoked, pending cancellation · Built 1941 · Smith Marvin JN5670MMooney M20J · S/N 24-1396Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1983 · Flippo Traci L TrusteeN75ABCessna 337A · S/N 337-0515Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1966 · Browning Corporation InternationalN673CRBell Helicopter Textron Canada 407 · S/N 53577Cancelled Oct 2, 2014 · Exported to Canada · Built 2003 · Bell Helicopter Textron IncN315BBBlack W R JR DRAGONFLY · S/N 315Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1987 · Black W R JrN46VMort Raymond W GEE BEE SPORTSTER E · S/N M-7Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Mort Raymond WN3256XCessna 310L · S/N 310L-0106Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1967 · Price Jesse NN14LLHead Balloons AX7-77 · S/N 110Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1984 · Thompson Kevin FN35JDBeech 35-B33 · S/N CD-627Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1963 · Parker Robert MN5901FCessna 210G · S/N 21058901Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1967 · Emmett Robert JN17GWWalters CASSUT 2-3 · S/N G.W.17Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1984N7576GCessna 172N · S/N 17273614Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1979 · Dupree DonN65531Cessna 152 · S/N 15281599Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1978 · Berlekamp Leland HN215XCessna 310C · S/N 35787Cancelled Feb 19, 2013 · Sale reported, pending cancellation · Built 1958N4496BBell UH-1H · S/N 68-15434Cancelled Dec 19, 2012 · Exported to Lebanon · Built 1968 · Bell Helicopter Textron IncN48821Cessna 152 · S/N 15280983Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1977 · Hodge Anthony WN5DEEverett VAN'S RV-3 · S/N 1Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1978 · Jackson Collin KN4534CCessna 170B · S/N 25478Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Built 1953 · Schapansky Roy L PtnrN4445CCessna 195B · S/N 16030Cancelled Nov 30, 2012 · Registration expired, pending cancellation · Built 1953 · Bechdolt Reginald WN4486TPiper PA-28-180 · S/N 28-7205170Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1972 · York Robert BN2510FChampion 7ECA · S/N 125Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Built 1965 · Hodge Anthony WN20LGBechdolt Rex W VARIEZE · S/N 1461Cancelled May 4, 2012 · Registration expired, pending cancellation · Built 1981 · Bechdolt Rex WN533Hanifan John C HANIFAN MQT CGR MA5A · S/N 018Cancelled Sep 30, 2009 · Triennial form not returned · Built 1966 · Hanifan John CN25282Cessna 152 · S/N 15280570Cancelled Jul 16, 2009 · Registration revoked · Built 1977 · D & D AviationN25EGDaniel Michael P BD-5 · S/N 341Cancelled Jun 11, 2007 · Triennial form not returned · Built 2003 · Daniel Michael PN5916ABell Helicopter Textron TR 918 · S/N 91801Cancelled May 19, 2006 · Built 2005 · Bell Helicopter Textron IncN45383Bell 412EP · S/N 36333Cancelled Jan 21, 2005 · Exported to Thailand · Built 2004 · Bell Helicopter Textron IncN45428Bell 412EP · S/N 36332Cancelled Jan 20, 2005 · Exported to Thailand · Built 2004 · Bell Helicopter Textron IncN219WBBell 407 · S/N 53219Cancelled Jan 19, 2005 · Exported to Ukraine · Built 1997 · Bell Helicopter Textron IncN270ALBell 206-L4 · S/N 52286Cancelled Nov 17, 2004 · Exported to Bangladesh · Bell Helicopter Textron IncN45371Bell 412EP · S/N 36330Cancelled Aug 19, 2004 · Exported to Mexico · Bell Helicopter Textron IncN45377Bell 412EP · S/N 36334Cancelled Aug 19, 2004 · Exported to Mexico · Bell Helicopter Textron IncN45391Bell 412EP · S/N 36335Cancelled Aug 6, 2004 · Exported to Mexico · Bell Helicopter Textron IncN8038GBell 206B · S/N 4578Cancelled Jul 15, 2004 · Exported to Mexico · Bell Helicopter Textron IncN5229NEurocopter EC120B · S/N 1054Cancelled Apr 1, 2004 · Exported to South Africa · Built 1999 · Bell Helicopter Textron IncN8067MBell 412EP · S/N 36324Cancelled Jan 22, 2004 · Exported to Mexico · Bell Helicopter Textron IncN7215JBell 430 · S/N 49027Cancelled Dec 22, 2003 · Exported to Australia · Bell Helicopter Textron IncN51335Bell 430 · S/N 49094Cancelled Jun 3, 2003 · Exported to Ukraine · Bell Helicopter TextronN24129Bell 412EP · S/N 36311Cancelled May 27, 2003 · Exported to Mexico · Built 2002 · Bell Helicopter Textron IncN40359Bell 206B · S/N 4566Cancelled May 20, 2003 · Exported to Brazil · Built 2002 · Bell Helicopter Textron IncN3063BBell 412EP · S/N 36302Cancelled Feb 26, 2003 · Exported to Thailand · Built 2002 · Bell Helicopter Textron IncN3064CBell 412EP · S/N 36303Cancelled Feb 26, 2003 · Exported to Thailand · Built 2002 · Bell Helicopter Textron IncN2412JBell 407 · S/N 53541Cancelled Jan 22, 2003 · Exported to Venezuela · Bell Helicopter Textron Inc
Back to Hurst, TX