Department Of Public Safety

Earlier aircraft under this name · 34

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'DEPARTMENT OF PUBLIC SAFETY' OR list_contains(d.other_registrant_names, 'DEPARTMENT OF PUBLIC SAFETY')
  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.

N720HPBell 206B · S/N 2325Cancelled Oct 28, 2019 · Third renewal notice · Built 1978 · State Of Tennessee, Nashville, TNN9770Hiller UH-12C · S/N 55-4069Cancelled Jun 20, 2018 · Revoked, canceled · Built 1955 · St Paul, MNN9084JPiper PA-32R-301 · S/N 32-8506013Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1985 · State Of Alaska, Anchorage, AKN911AAEurocopter AS 350 B3 · S/N 3611Cancelled Jun 13, 2013 · Built 2002 · State Of Alaska, Anchorage, AKN3902WBell 206B · S/N 3233Cancelled Feb 7, 2013 · Registration expired, pending cancellation · Built 1981 · Montgomery, ALN6476HCessna 207A · S/N 20700536Cancelled Feb 13, 2007 · Triennial form not returned · State Of Alaska, Anchorage, AKN48JABeech C-12C · S/N 77-22940Cancelled Sep 29, 2003 · Exported to Venezuela · State Of New Mexico, Santa Fe, NMN160SABell OH-58A · S/N 7015286Cancelled Oct 16, 1996 · State Of Alabama, Montgomery, ALN202FCBell 206B · S/N 3644Cancelled Aug 8, 1995 · Exported to Taiwan · County Of Volusia, Deland, FLN70711Hiller UH-12E · S/N 1704Cancelled Dec 16, 1992 · Second triennial mailing, no response · State Of Alaska, Anchorage, AKN23088Street-Thomas B8M · S/N 1Cancelled Jul 25, 1985 · Administratively canceled · Street Thomas M, Lakeland, FLN8818TCessna 182C · S/N 52718Cancelled Feb 14, 1985 · Administratively canceled · Jones Herbert E, Owlshead, MEN3099Noorduyn UC-64A · S/N 44-70378Cancelled Jan 8, 1985 · Administratively canceled · Heckman Charles W, Queens Village, NYN8394MPiper PA-28-161 · S/N 28-8116239Cancelled Dec 11, 1984 · Administratively canceled · Hauser Victor E Jr, Boulder, CON3124UCessna 182F · S/N 18254524Cancelled Nov 5, 1984 · Administratively canceled · Quad Aviation Inc, Weldona, CON242EZCessna 150L · S/N 15075566Cancelled Aug 31, 1984 · Administratively canceled · Arizona Airmotive Inc, Tucson, AZN8092ZPiper PA-28-161 · S/N 28-8016085Cancelled Aug 6, 1984 · Administratively canceled · Lopez Jesse, Liberty, TXN913AJJohnson J Alden QUICKIE Q2 · S/N 2553Cancelled Aug 2, 1984 · Administratively canceled · Johnson J Alden, Greenfield, MAN3447GCessna 310R · S/N 310R0836Cancelled Aug 1, 1984 · Administratively canceled · Wings Of Venice Inc, Venice, FLN3046PConsolidated Aeronautics LAKE LA-4-200 · S/N 968Cancelled Jul 11, 1984 · Administratively canceled · Snead Research Lab Inc, Georgetown, TXN302MAMurrayair MA-1 · S/N 002Cancelled Apr 10, 1984 · Administratively canceled · Murrayair Limited, Honolulu, HIN8732Boeing 707-331B · S/N 20061Cancelled Feb 22, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NYN80190Chamberlain Harry L KR-1 · S/N 192-01-7391Cancelled Jan 13, 1984 · Administratively canceled · Chamberlain Harry L, Johnstown, PAN84661Cessna 172K · S/N 17258568Cancelled Nov 23, 1983 · Administratively canceled · Wilkinson Larry D, Graysville, ALN8345JCessna 150G · S/N 15066245Cancelled Sep 24, 1983 · Administratively canceled · Carreiro John A Jr, Swansea, MAN2238QCessna 402B · S/N 402B0230Cancelled Aug 2, 1983 · Administratively canceled · State Of Texas, Austin, TXN8666ZCessna P206C · S/N P206-0466Cancelled Jun 29, 1983 · Administratively canceled · Bailey Wm Boner, Portland, ORN8422CPiper PA-28-181 · S/N 28-7690139Cancelled May 25, 1983 · Administratively canceled · Slinger Vegetable Corp, Beaver Dam, WIN79SPBell 206B · S/N 892Cancelled May 4, 1983 · Institute, WVN8773HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1524Cancelled Oct 2, 1982 · Administratively canceled · R & W Air Service Inc, Angleton, TXN207PSBell TH-13T · S/N 658074Cancelled Dec 31, 1980 · Montgomery, ALN209PSBell TH-13T · S/N 65-8056Cancelled Dec 31, 1980 · Montgomery, ALN9771Hiller OH-23C · S/N 56-2294Cancelled Apr 14, 1978 · St Paul, MNN9406ZBeech C-45H · S/N 52-10817ACancelled Apr 28, 1965 · Oklahoma City, OK
Back to Department Of Public Safety