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.

N77581Piper J-3C · S/N 22072Cancelled Dec 4, 1951 · Arthur PierceN1771VCessna 120 · S/N 13956Cancelled Feb 20, 1951 · Twentieth Century Plus Flying ClubN1904VCessna 140 · S/N 14095Cancelled Nov 6, 1950 · Coursey Joe C JrN41614Culver LFA · S/N 361Cancelled Oct 31, 1950 · Hale Howard GeorgeN9530KStinson 108-2 · S/N 108-2530Cancelled Oct 31, 1950 · Wes-Tex AircraftN36523Aeronca 65-CA · S/N CA16161Cancelled Aug 14, 1950 · Exported to Mexico · Built 1941 · Scales DonN48558Fairchild M-62A · S/N T41-666Cancelled Jun 2, 1950 · Mcgough DudleyN3202NPiper J3C-65 · S/N 22393Cancelled Aug 30, 1949 · Built 1946 · Skyway Dusting CoN91782Ryan NAVION · S/N NAV-4-494Cancelled Jun 22, 1949 · Bledsoe JimN4411NBoeing A75N1 · S/N 75-3692Cancelled May 26, 1949 · Phillips Aero Dusting Co IncN76153Cessna 120 · S/N 10550Cancelled May 18, 1949 · Hutchinson Tom NN77056Cessna 120 · S/N 11510Cancelled Feb 17, 1949 · Built 1946 · Jenkins Aircraft Sales & ServiceN47715Piper TG-8 · S/N G-63Cancelled Jan 14, 1949 · Built 1944 · Breedlove William C - Breedlove Aerial ServiceN47717Piper TG-8 · S/N G-98Cancelled Jan 14, 1949 · Built 1944 · Breedlove William C - Breedlove Aerial ServiceN15714Waco DQC-6 · S/N 4389Cancelled Aug 4, 1948 · Clent Breedlove Aerial ServiceN18430Stinson SR-9E · S/N 5266Cancelled Jul 27, 1948 · Exported to Mexico · Built 1937 · Cupp Ae Et AlN25801Piper J3F-50 · S/N 3753Cancelled Jul 6, 1948 · Dagley M FN21952Porterfield 75C · S/N 650Cancelled Jun 15, 1948 · Crow John AlmuthN97039Stinson 108-1 · S/N 108-1-1039Cancelled Apr 13, 1948 · Built 1946 · Baca AdeleN3420HEngineering & Research 415-C · S/N 4045Cancelled Feb 10, 1948 · Built 1946 · Breedlove Aerial ServiceN2312HErcoupe 415-C · S/N 2937Cancelled Sep 16, 1947 · Built 1946 · Breedlove Wm C DBA Breedlove Aerial ServiceN21928Culver LCA · S/N 179Cancelled May 21, 1945 · Built 1940 · Lubbock Aero ServiceN39707Waco UPF-7 · S/N 5839Cancelled May 21, 1945 · Lubbock Aero ServiceN146VCessna CG-2 · S/N 85Cancelled Jan 25, 1933 · Cavett RichardN43136Taylorcraft BC12-D · S/N 6795Cancellation date not recorded · Built 1946 · Breedlove William CN64877Cessna UC-78B · S/N 6590(43-32652)Cancellation date not recorded · Built 1943 · Jenkins Aircraft
Back to Lubbock, TX