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.

N12GXLee G R/Robertson R A 7/8 NIEUPORT-12 · S/N 001Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1987 · American Air Power Heritage MuseumN23702Air Tractor AT-301 · S/N 301-0419Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1982 · Stc Aircraft Conversions LLCN1022PPiper PA-28-180 · S/N 28-5060Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Built 1968 · White Danny LN7773CPrue Irving O PRUE SUPER STANDARD · S/N 1Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1963 · Auburg George RN600AXDehavilland DHC-2 MK 1 · S/N 815Cancelled Feb 1, 2018 · Exported to Canada · Built 1955 · Trace Engines LpN7529FChampion 7KCAB · S/N 268-70Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1969 · Swain James MN8086WInfinity INFINITY 582 · S/N IPP3-183Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 2004 · Swain James MN432HBeech 65-A80 · S/N LD-206Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1964 · Nyerges James RN243WCessna A185F · S/N 18503820Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1979 · Richardson KyleN1753NCessna 120 · S/N 11997Cancelled Oct 28, 2017 · Revoked, canceled · Built 1946 · Apache Flying ClubN322FSDiamond Aircraft Ind DA20-C1 · S/N C0279Cancelled Oct 25, 2017 · Registration expired, pending cancellation · Built 2004 · Pilot Coach Aviation IncN65WNKitfox/Barnes Dwaine XL · S/N DB01ATCancelled Oct 20, 2017 · Registration expired, pending cancellation · Barnes Dwaine RN30NPBeech 65-B80 · S/N LD-407Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1969 · Nygeres JimN99EKLet BLANIK L-13 · S/N 026117Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1974 · Permian Soaring Assoc IncN20NPBeech 65-B80 · S/N LD-433Cancelled Jul 19, 2017 · Built 1970 · Armstrong Paul WN5376MBeech 65-B80 · S/N LD-301Cancelled Jul 19, 2017 · Built 1966 · Armstrong Paul WN8071RBeech 65-B80 · S/N LD-420Cancelled Jul 19, 2017 · Built 1969 · Armstrong Paul WN24196Rans S-4 COYOTE I · S/N 037Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Brown JimN275DBeech 95-B55 (T42A) · S/N TC-589Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1964 · Midland CollegeN8265YBell OH-58C · S/N 68-16859Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Midland County Sheriffs DepartmentN182ESCessna 182P · S/N 18261041Cancelled Jun 20, 2017 · Exported to Russia · Built 1972 · White T AlanN78954Mooney M20C · S/N 1988Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1961 · Glenn Michael HN761DJCessna T210M · S/N 21062171Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1977 · Smith Jeffrey SN16HECrocker TAILWIND W-8 · S/N 289Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1977 · Mercer Larry MN66373Consolidated Vultee L-13 · S/N 47376Cancelled Feb 4, 2017 · Revoked, canceled · Nugent C W Assoc LtdN5679GCessna 150K · S/N 15071179Cancelled Nov 4, 2016 · Built 1969 · Lm Air Patrol Service IncN3649SAir Tractor AT-301 · S/N 301-0235Cancelled Nov 2, 2016 · Exported to Mexico · Built 1979 · Friesen JuanN9922VCessna 172M · S/N 17264557Cancelled Sep 1, 2016 · First renewal notice · Built 1974 · American Patrols IncN5855Beech UC-45J · S/N 29558Cancelled Oct 7, 2015 · Built 1944 · American Airpower Heritage Flying MuseumN59649Boeing PT-17 · S/N 75-4223Cancelled Oct 7, 2015 · Third renewal notice · American Airpower Heritage Flying MuseumN46337Interstate S-1B1 · S/N 163Cancelled Aug 24, 2015 · Third renewal notice · Built 1945 · American Airpower Heritage Fly MusmN5148ZReno Gordon E P-5151 · S/N 140H7198Cancelled Aug 24, 2015 · Third renewal notice · Built 1993 · American Airpower Heritage Flying MuseumuN4249ALockheed 12A · S/N 1292Cancelled May 21, 2015 · Sale reported, canceled · Built 1960N72825Destiny Powered Parachute DESTINY 2000 · S/N 1B0117Cancelled May 21, 2015 · Sale reported, canceled · Built 2001N45159Naval Aircraft Factory N3N-3 · S/N 2994Cancelled May 20, 2015 · Registration pending, canceledN65404Cessna 152 · S/N 15281530Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1978 · Gay Jerry LN29318Piper PA-28RT-201T · S/N 28R-7931196Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1979 · Midland Big Chief Supply IncN2SQBellanca 17-31ATC · S/N 31038Cancelled Apr 2, 2015 · Registration expired, pending cancellation · Built 1972 · Alpha Sun IncN5038DCessna 182A · S/N 51138Cancelled Feb 3, 2015 · First renewal notice · Built 1958 · Watts David EN7022TLutker-Dittmer-Sturm DAVIS DA-5A · S/N 3Cancelled Dec 2, 2014 · Revoked, canceled · Built 1979 · Lutker Robert DN135LAPiper PA-23-250 · S/N 27-7305084Cancelled Oct 24, 2014 · Registration expired, pending cancellation · Built 1973 · Cowboy Church Of The American WestN29271Culver LCA · S/N 140Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1940 · Stone Betty JN6060XMooney M20A · S/N 1686Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1960 · Piearcy David AN56014Buckeye DREAM MACHINE · S/N 16375Cancelled Aug 28, 2013 · Sale reported, canceled · Built 2003N449RBellanca 17-31ATC · S/N 74-31076Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1973N481MCIsrael Aircraft Industries 1123 · S/N 184Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1975N566CABeech 58 · S/N TH-1632Cancelled Jul 2, 2013 · Exported to Paraguay · Built 1991 · Chivoair LLCN917MBCessna 310K · S/N 310K0201Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1966 · Mitchell S MN8785VBellanca 17-30A · S/N 30333Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1970 · Henley Gary SN7864TCessna 172A · S/N 47464Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1960 · Heyroth Paul D
Back to Midland, TX