OpenAirDocs.org
Denham Springs, LA

Cancelled registrations · 19

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 = 'LA' AND d.registrant_city = 'DENHAM SPRINGS'
  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.

N710LSEvektor-Aerotechnik SPORTSTAR · S/N 20060710Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Olivier Cody JN1757JPiper PA-28-140 · S/N 28-24177Cancelled Jul 12, 2019 · Registration expired, pending cancellation · Eaton Fred IN4512EHead Balloons AX8-88 · S/N 176Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1991 · Fry Shirley GN907CABell 206B · S/N 4130Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1990 · Walls BrianN90831Balloon Works FIREFLY 7 · S/N F7-641Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Built 1990 · Holden Ronald WN4548PParker Richard A B-8M · S/N 11153Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Parker Richard AN9543RBeech K35 · S/N D-6121Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1959 · Bengal FlyersN379NSStafford Michael Leon KR2 · S/N 8826Cancelled Oct 22, 2014 · Registration expired · Stafford Michael LN145TCThunder & Colt Airborne Amer AX8-90 S 2 · S/N 1966USACancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1991 · Balloon Company Of LouisianaN9PRSmith Special S-1 · S/N 1Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1957N5311XGalaxy Balloons GALAXY 7 · S/N GLX-1537Cancelled Jun 11, 2013 · Third renewal notice · Built 1988 · Mitchell Jack KN64984Cessna 152 · S/N 15281511Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1978 · Tillman Michael EN911PCBell OH-58A · S/N 71-20449Cancelled Aug 21, 2012 · Registration pending, canceled · Built 1972N206ENBell 206B · S/N 1757Cancelled Sep 13, 2007 · Exported to France · Built 1975 · Walls Brian PN169HHughes 269C · S/N 690797Cancelled Mar 7, 1996 · Exported to Colombia · Blount Calvin LN1530PPiper PA-22-160 · S/N 222395Cancelled May 13, 1976 · Built 1954 · Hoehne Joachim RN15236Waco CJC · S/N 4264Cancelled Jan 4, 1971 · Built 1935 · Hughes PatN9780HCessna T-50 · S/N 6594Cancelled May 22, 1965 · Hughes Pat BN4360HPiper PA-15 · S/N 15-146Cancelled Feb 9, 1965 · Mcneese J T
Back to Denham Springs, LA