OpenAirDocs.org
Lake Providence, LA

Cancelled registrations · 32

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 = 'LAKE PROVIDENCE'
  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.

N92157Piper J3C-65 · S/N 16596Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Carroll Aero IncN46717Air Creation TWIN 503 SL · S/N T04017Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 2004 · Howard Brian AN70934Piper J3C-65 · S/N 17958Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Shepherd And ShepherdN2404DCessna 170B · S/N 20556Cancelled Oct 28, 2017 · Revoked, canceled · Built 1952 · Dillard J RN35516Piper J3C-65 · S/N 6420Cancelled Feb 14, 2017 · Revoked, pending cancellation · Built 1941 · Edwards JohnnyN634UGrumman G-164 · S/N 370Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1965 · J & J Salvage IncN8390Grumman Acft ENG Cor-Schweizer G-164A · S/N 882Cancelled Oct 30, 2001 · Exported to Uruguay · Newtons Flying Service IncN4387Grumman Acft ENG Cor-Schweizer G-164A · S/N 1046Cancelled Nov 1, 2000 · Triennial form not returned · Carroll Flying Service IncN1549DAir Tractor AT-401 · S/N 401-0881Cancelled Feb 25, 1999 · Triennial form not returned · Monticello Flying Service IncN4477QCessna A188B · S/N 18800877Cancelled Dec 1, 1992 · Triennial form not returned · Rinicker Flying Service IncN7094ZPiper PA-25-235 · S/N 252882Cancelled Dec 1, 1992 · Triennial form not returned · Rinicker Flying Service IncN3849SCessna 172E · S/N 17251049Cancelled Nov 30, 1992 · Triennial form not returned · Rinicker Dale SN5977WPiper PA-28-160 · S/N 284054Cancelled Mar 19, 1990 · Second triennial mailing, no response · Bernard S LN8859QRockwell International S-2R · S/N 2344RCancelled Jul 27, 1978 · Howard AviationN6160HPiper J3C-65 · S/N 19327Cancelled May 26, 1976 · Guthrie Robert CN22267Taylorcraft BL-65 · S/N 1216Cancelled May 7, 1975 · Built 1939 · Jordan Glen EN4737YPiper PA-25-260 · S/N 25-4490Cancelled Sep 30, 1974 · Exported to Mexico · Built 1967 · Davis Charles R JrN8523EChampion 7GC · S/N 7 GC 83Cancelled Jun 25, 1973 · Howard Jimmie Lee SrN70776Piper J3C-65 · S/N 17796Cancelled Aug 6, 1970 · Lake Providence Flying Service IncN44932Naval Aircraft Factory N3N-3 · S/N 2718Cancelled Jun 24, 1970 · Eugene L Wilson JrN45253Naval Aircraft Factory N3N-3 · S/N 1806Cancelled Jun 24, 1970 · Eugene L Wilson JrN47235Aeronca 0-58B · S/N C3722TACancelled Jun 24, 1970 · Wilson E L JrN1266APiper PA-18 · S/N 18-1062Cancelled Jun 5, 1970 · Rinicker Dale SN3333MPiper PA-12 · S/N 12-2191Cancelled Oct 19, 1967 · Exported to Honduras · John D JohnsonN70816Piper J3C-65 · S/N 17833Cancelled May 21, 1965 · Fleeman Russel CN3344NPiper J3C-65 · S/N 22543Cancelled May 20, 1965 · Carroll Aero IncN49806Fairchild M-62A · S/N T43-5233Cancelled May 20, 1965 · Mobley Clifford RN7173DPiper PA-18A 150 · S/N 18-5631Cancelled Nov 18, 1957 · Tomlinson Walter P & Henry HN81497Aeronca 7AC · S/N 7AC-116Cancelled Aug 18, 1954 · Built 1945 · Bonner W F JrN89863Cessna 140 · S/N 8908Cancelled Apr 27, 1950 · Rentz Robert AN9304KStinson 108-2 · S/N 108-2304Cancelled Jun 17, 1949 · Russel C FleemanN6687Command-Aire 3C-3 · S/N 512Cancelled Nov 1, 1929 · Kilpatrick & Haskin
Back to Lake Providence, LA