Amarillo, TX

Cancelled registrations · 230

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

N7083BPiper PA-18A 150 · S/N 18-5165Cancelled Mar 28, 2011 · Registration pending, pending cancellation · Built 1956N5237WGalaxy Balloons GALAXY 7 · S/N GLX-1287Cancelled Jan 7, 2011 · Exported to Poland · Wills Paul LN2691ACessna 414A · S/N 414A0409Cancelled Aug 26, 2010 · Exported to Mexico · C S Air LLCN356TWCessna 172S · S/N 172S9761Cancelled Oct 19, 2009 · Exported to Germany · Built 2004 · Amarillo Aircraft Leasing LLCN9447RSnow S2A · S/N 1078ACancelled Sep 17, 2009 · Registration revoked · Built 1960 · Early Wayne DBAN19998Cessna 172M · S/N 17260921Cancelled Aug 12, 2009 · Triennial form not returned · Built 1972 · Mckinney Willard EN8064VBeech F33A · S/N CE-1672Cancelled Sep 23, 2008 · Exported to Australia · Built 1992 · Cox Sammy LaneN226HCCarpenter Hal G BD-4 · S/N 226Cancelled Aug 10, 2006 · Triennial form not returned · Carpenter Hal GN718LGCessna 210 · S/N 57031Cancelled Feb 20, 2004 · Triennial form not returned · Built 1959 · Cole 1st Family Ltd PartnershipN974DCPiper PA-31T · S/N 31T-8120027Cancelled Dec 10, 2003 · Triennial form not returned · Built 1981 · Ocaas LLCN4002MRobinson Helicopter R22 BETA · S/N 1444Cancelled Mar 11, 2003 · Triennial form not returned · Built 1990 · Webb GeneN40PCKirkland Freddy D KIRKLAND POLY COUPE · S/N 01ACancelled Jan 15, 2002 · Triennial form not returned · Kirkland Freddy DN17SSShaughnessy SWACO-STAGGERWING · S/N D3Cancelled Mar 1, 2001 · Triennial form not returned · Shaughnessy JackN2526LCessna 172H · S/N 17255726Cancelled Nov 2, 2000 · Dodson Paul GregoryN888HGBeech B200 · S/N BB-891Cancelled Sep 22, 2000 · Exported to Canada · Manana International LLCN3965KPiper PA-28-140 · S/N 28-23848Cancelled Apr 12, 2000 · King Henry H JrN313VAero Commander 560 · S/N 193Cancelled Mar 30, 2000 · Registration revoked · Early WayneN7086SKennedy Mermon Joe MODIFIED PA-18 · S/N 1Cancelled Sep 28, 1999 · Triennial form not returned · Kennedy Mermon JoeN42JJAlbert Norman R POLLIWAGEN · S/N 0378NCancelled Dec 4, 1998 · Kirkland Freddy DN218JWCessna 310Q · S/N 310Q1023Cancelled Nov 18, 1998 · Second triennial mailing, no response · Oppel Ray JN7923QCessna 401B · S/N 401B0023Cancelled Oct 9, 1998 · Triennial form not returned · Nelson Walter Levelle DBAN201YYMooney M20J · S/N 240532Cancelled Aug 3, 1998 · Second triennial mailing, no response · Wynn Doyce DBAN24GDRaven S55A · S/N S55A877Cancelled Jan 22, 1996 · Triennial form not returned · Dodson Paul GregoryN36VPiper PA-31P · S/N 31P7530018Cancelled Mar 22, 1994 · Exported to Brazil · Brown Dean P Do TrusteeN469RJCessna 421B · S/N 421B0444Cancelled Oct 13, 1993 · Triennial form not returned · Nelson Walter LN42845Benningfield Johnnie L RUF-TAIL · S/N 1Cancelled Jun 15, 1993 · Benningfield Johnnie LN4300ZPiper PA-28-181 · S/N 288390054Cancelled Feb 26, 1993 · Exported to Germany · Wolf Wings Aircharter IncN131RCPiper PA-42 · S/N 428001006Cancelled Jun 10, 1992 · Exported to Canada · West Air IncN6231GCessna 421C · S/N 421C0262Cancelled Aug 15, 1991 · Triennial form not returned · Brister Beryle DN5351MCessna 152 · S/N 15284554Cancelled Jun 11, 1991 · Triennial form not returned · Amarillo Flying Service IncN3956UCessna 150E · S/N 15061356Cancelled Dec 7, 1990 · Registration expired, pending cancellation · Built 1965 · Conley CharlesN5414VCessna 172RG · S/N 172RG0525Cancelled Jun 6, 1984 · Davis Clarence T IIIN31379Bell UH-1B · S/N 62-2043Cancelled Dec 12, 1983 · Amarillo-Potter CountyN49845Cessna 152 · S/N 15281356Cancelled Apr 13, 1983 · Brown Kenneth V DBA Amarillo Flying ServiceN2316SCessna 337B · S/N 3370616Cancelled Oct 21, 1982 · Built 1967 · Puckett Hunter & Holt Robert GN51957Reed TEENIE II · S/N 151660Cancelled Apr 15, 1982 · Reed James RN8007HAero Commander 685 · S/N 12048Cancelled Dec 17, 1981 · Bunnett William WN4153QCessna 310N · S/N 310N-0053Cancelled Aug 24, 1977 · Wilkins H T JrN6476XCessna 180D · S/N 18050976Cancelled Jun 21, 1977 · Exported to Canada · Fields O P JrN17602Beech A36 · S/N E-994Cancelled Apr 28, 1977 · Exported to Belgium · Built 1977 · Tradewind Airport CorpN93363Cessna A185F · S/N 18503226Cancelled Apr 21, 1977 · Exported to Canada · Ray C Crane Farm LtdN4027BBellanca 17-30A · S/N 75-30764Cancelled Mar 21, 1977 · Church Financial Services IncN41818Bellanca 8KCAB · S/N 121-74Cancelled Oct 21, 1976 · Built 1974 · Tradewind Airport IncN997YPiper PA-23-160 · S/N 31241Cancelled Jul 21, 1976 · Built 1958 · Mehegan Charles MN8293RBellanca 17-30A · S/N 30478Cancelled Aug 12, 1975 · Built 1972 · Nichols Carl T/Harris Lee MN123BCCessna 320 · S/N 320-0022Cancelled Jul 29, 1975 · Peat Clinton LN7963RBeech V35A · S/N D-8965Cancelled Nov 2, 1974 · Nichols Carl TN6128NBeech B23 · S/N M-1213Cancelled Aug 29, 1974 · Exported to Canada · Flying IncN2108HEngineering & Research 415-C · S/N 2731Cancelled Jul 15, 1974 · Solomon O MN87EStinson SR-9E · S/N 5452Cancelled Jul 9, 1974 · True Dan
Back to Amarillo, TX