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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N720HPBell 206B · S/N 2325N9770Hiller UH-12C · S/N 55-4069N9084JPiper PA-32R-301 · S/N 32-8506013N911AAEurocopter AS 350 B3 · S/N 3611N3902WBell 206B · S/N 3233N6476HCessna 207A · S/N 20700536N48JABeech C-12C · S/N 77-22940N160SABell OH-58A · S/N 7015286N202FCBell 206B · S/N 3644N70711Hiller UH-12E · S/N 1704N23088Street-Thomas B8M · S/N 1N8818TCessna 182C · S/N 52718N3099Noorduyn UC-64A · S/N 44-70378N8394MPiper PA-28-161 · S/N 28-8116239N3124UCessna 182F · S/N 18254524N242EZCessna 150L · S/N 15075566N8092ZPiper PA-28-161 · S/N 28-8016085N913AJJohnson J Alden QUICKIE Q2 · S/N 2553N3447GCessna 310R · S/N 310R0836N3046PConsolidated Aeronautics LAKE LA-4-200 · S/N 968N302MAMurrayair MA-1 · S/N 002N8732Boeing 707-331B · S/N 20061N80190Chamberlain Harry L KR-1 · S/N 192-01-7391N84661Cessna 172K · S/N 17258568N8345JCessna 150G · S/N 15066245N2238QCessna 402B · S/N 402B0230N8666ZCessna P206C · S/N P206-0466N8422CPiper PA-28-181 · S/N 28-7690139N79SPBell 206B · S/N 892N8773HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1524N207PSBell TH-13T · S/N 658074N209PSBell TH-13T · S/N 65-8056N9771Hiller OH-23C · S/N 56-2294N9406ZBeech C-45H · S/N 52-10817A
Back to Department Of Public Safety