Midland, TX

Cancelled registrations · 265

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

N58123Fairchild M-62A · S/N T42-3230Cancelled Dec 10, 2001 · Built 1942 · American Airpower Heritage Flying MuseumN206TTCessna TU206G · S/N U20605283Cancelled Oct 24, 2001 · Exported to Mexico · Built 1979 · Stroman Ronnie WN9055TCessna 182C · S/N 52955Cancelled Sep 19, 2001 · Triennial form not returned · American Patrols IncN56336Convair BT-13A · S/N 6656Cancelled Aug 23, 2000 · Triennial form not returned · American Airpower Heritage Flight MuseumN732BGCessna U206G · S/N U20604651Cancelled Jul 7, 2000 · Exported to Mexico · Three W EnterprisesN182FECessna 182P · S/N 18264925Cancelled May 5, 2000 · Triennial form not returned · Bozzell James TrusteeN32180Ragan Joe KELEHER JK1-A · S/N 001Cancelled Apr 19, 2000 · Triennial form not returned · Ragan JoeN2274Vroman Harold R VROMAN CACTUS V · S/N 1Cancelled Jul 26, 1999 · Triennial form not returned · Vroman Harold RN5946SBeech 95-C55 · S/N TE126Cancelled Nov 2, 1998 · Triennial form not returned · Grover Oil CompanyN1639QCessna 150L · S/N 15072939Cancelled Jun 15, 1998 · Second triennial mailing, no response · Radtke James EN9BLVickers SPITFIRE MARK IX · S/N MH434SM43Cancelled Jan 13, 1998 · Triennial form not returned · American Airpower Heritage Fly MuseuN44867Naval Aircraft Factory N3N-3 · S/N 4486Cancelled Oct 16, 1997 · Triennial form not returned · American Airpower Hertg Flg MuseumN9938Messerschmitt ME 109 C4K · S/N 172Cancelled Jun 6, 1997 · Exported to New Zealand · American Airpower Heritage Fly MusmN5546NMartin B-26C · S/N 22534135071Cancelled Mar 10, 1997 · Triennial form not returned · American Airpower Heritage Flying MuN2161DBeech D35 · S/N D3508Cancelled Jan 21, 1997 · Rush Maurice EN9NPBeech 65-B80 · S/N LD428Cancelled Oct 24, 1996 · Triennial form not returned · Nyerges JamesN3570Extra Walter EA 230 · S/N 008Cancelled Feb 14, 1996 · Exported to Brazil · Olsen OleN351WBCessna T210M · S/N 21062517Cancelled Apr 29, 1995 · Triennial form not returned · Wagner And BrownN4674LCessna 152 · S/N 15284213Cancelled Aug 3, 1994 · Triennial form not returned · West Texas Gas Inc DBAN532JJSitzman J J AIR COMMAND ELITE532 · S/N 461138652Cancelled Jul 22, 1994 · Triennial form not returned · Sitzman J JN81592Barrick Rickey Lee AIR COMMAND 532 · S/N 031256Cancelled Feb 15, 1994 · Triennial form not returned · Haynes DennisN84102Piper PA-28-161 · S/N 288116265Cancelled Feb 2, 1993 · Triennial form not returned · West Texas Gas Inc DBA Basin AvnN3570Oakes CVJETKOVIC-CA-65 · S/N 478249029Cancelled Nov 30, 1992 · Triennial form undeliverable · Olsen OleN3601Breigleb BG-12B · S/N 126Cancelled Jun 19, 1992 · Triennial form not returned · Dollahite Thomas HN96220Taylorcraft BC12-D · S/N 8520Cancelled Dec 6, 1991 · Triennial form not returned · Curry Daroyl RN3470VCessna 150M · S/N 15076511Cancelled Sep 13, 1991 · Petro Jet Sales And Leasing IncN7GNBeech A45 · S/N G146Cancelled Mar 26, 1991 · Triennial form not returned · Hawkins & Hawkins IncN976JGoertz BUSHBY MUSTANG M-II · S/N 185Cancelled Feb 14, 1990 · Second triennial mailing, no response · Hampton JimN177GACessna 210M · S/N 21062131Cancelled Mar 20, 1985 · Administratively canceled · Aaron Glen D SrN88KCBeech 65-88 · S/N LP-40Cancelled Mar 3, 1983 · Administratively canceled · Basin Flying Service IncN21592Cessna 182P · S/N 18261738Cancelled Mar 2, 1982 · Built 1973 · Cavenaugh Herbert RN6282FCessna 337A · S/N 337-0282Cancelled Dec 3, 1981 · Jones Johnny GN747AWPiper PA-31-350 · S/N 31-7552107Cancelled Oct 14, 1981 · Browne R WN6091PPiper PA-24-250 · S/N 24-1191Cancelled May 7, 1981 · Kyser Don K And Mewhorter W JN6902JPiper PA-28-181 · S/N 28-7690424Cancelled Jan 12, 1979 · Hanks Flite Center IncN894KBeech 100 · S/N B-85Cancelled Dec 7, 1978 · Exported to Norway · Rich Air CoN801WRWindecker AC-7 · S/N 1Cancelled Jul 21, 1977 · Windecker Research IncN7413XCessna 172B · S/N 17247913Cancelled Jul 18, 1977 · Potter Horace WayneN6325GCessna 150K · S/N 15071825Cancelled Jul 13, 1977 · Newman IncN5634RCessna 172F · S/N 17253255Cancelled Jun 14, 1977 · Exported to Canada · Built 1965 · Touch & Go Flying Club Co-OpN34SMSwearingen SA-226T · S/N T263Cancelled Jun 1, 1977 · Built 1976 · Aquila IncN333JVBeech E50 · S/N EH-15Cancelled Apr 4, 1977 · The Levens CorpN2886GNorth American T-6G · S/N 168-32Cancelled Feb 11, 1977 · H&W Spraying IncN5817RCessna 172G · S/N 17253486Cancelled Feb 8, 1977 · Exported to Canada · Norris FarnellN9981ACessna 170A · S/N 19341Cancelled Feb 2, 1977 · Exported to Canada · Bowerman James FN61930Cessna 172M · S/N 17264893Cancelled Aug 11, 1976 · Exported to Canada · Aquila IncN2053RCessna 182G · S/N 18255253Cancelled Apr 2, 1975 · Exported to Mexico · E M HughesN88EMBeech D50E · S/N DH-336Cancelled Mar 21, 1975 · Estoril Producing CorpN30234Cessna 210L · S/N 21059893Cancelled Feb 14, 1975 · Exported to Mexico · Built 1973 · Aquila IncN6035BCessna 182A · S/N 34035Cancelled Apr 24, 1974 · Chastain Joe
Back to Midland, TX