Lubbock, TX

Cancelled registrations · 276

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

N61216Fairchild M-62A · S/N T43-5906Cancelled May 20, 1975 · Spurrier Donald VmN17999Reeves-Williams STEEN SKYBOLT · S/N RW-1Cancelled Mar 25, 1975 · Reeves Jack S John B WilliamsN8491Paulicks B-8M · S/N 1Cancelled Jan 10, 1975 · Ibe Robert DN19553Cessna 150L · S/N 15074482Cancelled Oct 25, 1974 · Built 1973 · Lubbock Aero-Serv IncN2274GCessna 182B · S/N 51574Cancelled Jul 18, 1974 · Abdon F HoltN95435Piper PA-28-140 · S/N 28-25950Cancelled Feb 7, 1973 · Exported to Canada · Wes-Tex Aircraft IncN86956Ercoupe 415-D · S/N 129Cancelled Nov 15, 1972 · Built 1945 · Wilco Aviation IncN8417GCessna 150F · S/N 15062517Cancelled May 4, 1972 · Bill Tarver Leasing CoN6923FCessna 150F · S/N 15063523Cancelled Apr 29, 1972 · Tarver Billy E DBA Bill Tarver Leasing CoN2407RCessna 182G · S/N 18255507Cancelled Feb 28, 1972 · T O WilkinsN53770Taylorcraft DCO-65 · S/N L-5098Cancelled Dec 15, 1971 · Built 1945 · Smith Robert LN2219FCessna 310L · S/N 310L-0019Cancelled Sep 28, 1971 · Lubbock Equipment ServiceN8433YPiper PA-30 · S/N 30-1592Cancelled Aug 3, 1971 · Clark RayN7315PPiper PA-24 · S/N 24-2491Cancelled Jul 15, 1971 · George P GreenN8567TCessna 182C · S/N 52467Cancelled Mar 31, 1971 · West Texas Evangelism Assn IncN5440WPiper PA-28-160 · S/N 28-516Cancelled Feb 10, 1971 · Clark Sales CompanyN4891ZPiper PA-22-108 · S/N 22-8473Cancelled Feb 1, 1971 · Wes Tex Aircraft IncN7107BPiper PA-22-150 · S/N 22-4323Cancelled Jan 14, 1971 · Glenn S CN7568DPiper PA-18A 150 · S/N 18-5852Cancelled Oct 12, 1970 · Wes-Tex Aircraft SalesN7264DPiper PA-18 · S/N 18-5672Cancelled Sep 4, 1970 · Gibson Miles EN1375APiper PA-18 · S/N 18-1206Cancelled Sep 3, 1970 · Built 1951 · Horton EarlN1125YCessna 150B · S/N 15059525Cancelled Sep 2, 1970 · Nettleton EdwinN64875Cessna T-50 · S/N 4324Cancelled Jul 30, 1970 · HewettrcN4386CChampion 7EC · S/N 7EC-412Cancelled Jul 21, 1970 · Cramer Phillip RN3579KPiper PA-28-140 · S/N 28-23637Cancelled Jun 25, 1970 · Trivitt Leonard G DBA Flite Line MaintenanceN4116DHelio H-391B · S/N 033Cancelled Jun 10, 1968 · Mallinckrodt George EN5951YPiper PA-23-250 (6PCLM) · S/N 27-3118Cancelled Nov 14, 1967 · Jack Goodman/ G & G Construction CompanyN7255XCessna 150B · S/N 15059355Cancelled May 22, 1965 · Champs Aviation IncN8054PPiper PA-24-250 · S/N 24-3300Cancelled May 22, 1965 · Wes Tex Aircraft IncN7262YPiper PA-30 · S/N 30-297Cancelled Nov 5, 1964 · Lubbock Wrecking Co IncN5313YPiper PA-23-250 · S/N 27-2386Cancelled Jul 1, 1964 · Exported to Canada · Ennis E Moss Jr M DN75086Republic F84G · S/N 51-779Cancelled Dec 11, 1963 · Texas Technological CollegeN94077Engineering & Research ERCOUPE 415-C · S/N 1400Cancelled Nov 26, 1963 · Built 1946 · Branscum B DN2841ACessna 180 · S/N 30041Cancelled Aug 19, 1963 · Champs Aviation IncN75091Dehavilland BEAVER DHC-2 MK.1 · S/N 1282Cancelled Nov 30, 1962 · United States Air ForceN2883PPiper PA-18A 150 · S/N 18-4480Cancelled Nov 26, 1958 · Built 1955 · Dagley M FN1638NFunk B85C · S/N 418Cancelled Nov 5, 1957 · Yoas E JaxonN3545CCessna 170B · S/N 26588Cancelled Feb 18, 1957 · Wilkerson J GN793VFleet 7 · S/N 373Cancelled Jul 21, 1956 · Built 1930 · Maples Travis NolanN56258Boeing A75N1 · S/N 75-724Cancelled Oct 24, 1955 · Quinn Louis FN75994Cessna T-50 · S/N 3371Cancelled Oct 24, 1955 · Arthur French Construction CoN3517APiper PA-22 · S/N 22-1789Cancelled Aug 11, 1955 · Wes Tex Aircraft SalesN75459Consolidated Vultee BT-15 · S/N 7472Cancelled Feb 7, 1955 · A L MuseN75461Consolidated Vultee BT-15 · S/N 7883Cancelled Feb 7, 1955 · A L MuseN42323Piper J-3 · S/N 14573Cancelled Nov 16, 1953 · Texas Tech Af Rotc Flying ClubN33469Piper J3C-65 · S/N 5979Cancelled Jun 16, 1953 · Jerry ThomasN92553Piper PA-12 · S/N 12-82Cancelled Apr 8, 1953 · Exported to Mexico · Cunningham O NN3588KPiper J3C-65 · S/N 22279Cancelled Oct 28, 1952 · Smith W HN3201NPiper J3C-65 · S/N 22392Cancelled Aug 29, 1952 · Built 1946 · Skyway Dusting Co IncN38782Piper J3C-65 · S/N 7260Cancelled Aug 29, 1952 · Built 1941 · Smith W H
Back to Lubbock, TX