Skip to content

Department Of Commerce

Earlier aircraft under this name · 30

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

Query with SQL

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 COMMERCE' OR list_contains(d.other_registrant_names, 'DEPARTMENT OF COMMERCE') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 COMMERCE' OR list_contains(d.other_registrant_names, 'DEPARTMENT OF COMMERCE')
  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 COMMERCE' OR list_contains(d.other_registrant_names, 'DEPARTMENT OF COMMERCE')
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.

N765UCAerial Imaging Solutionsllc APQ-18 · S/N 002Cancelled Nov 5, 2022 · Registration expired, pending cancellation · La Jolla, CA N6584PAerial Imaging Solutions APH-22 · S/N 017Cancelled Jun 4, 2022 · Registration expired, pending cancellation · La Jolla, CA N658XCAerial Imaging Solutions APH-22 · S/N 020Cancelled Jun 4, 2022 · Registration expired, pending cancellation · La Jolla, CA N659CNAerial Imaging Solutions APH-22 · S/N 018Cancelled Jun 4, 2022 · Registration expired, pending cancellation · La Jolla, CA N659JAAerial Imaging Solutions APH-22 · S/N 019Cancelled Jun 4, 2022 · Registration expired, pending cancellation · La Jolla, CA N545HNAerial Imaging Solutions APH-22 · S/N 008Cancelled Feb 5, 2022 · Registration expired, pending cancellation · La Jolla, CA N581YBAerial Imaging Solutionsllc APQ-18 · S/N 001Cancelled Feb 5, 2022 · Registration expired, pending cancellation · La Jolla, CA N563SNAerial Imaging Solutions APH-22 · S/N 009Cancelled Oct 2, 2021 · Registration expired, pending cancellation · La Jolla, CA N5341DAerovironment RQ-20A PUMA AE · S/N 1725Cancelled May 8, 2021 · Registration expired, pending cancellation · Lakeland, FL N535VAAerovironment RQ-20A PUMA AE · S/N 1724Cancelled May 8, 2021 · Registration expired, pending cancellation · Lakeland, FL N535XAAerovironment RQ-20A PUMA AE · S/N 1727Cancelled May 8, 2021 · Registration expired, pending cancellation · Lakeland, FL N536JNMicrodrones MD4-1000 · S/N 103Cancelled May 8, 2021 · Registration expired, pending cancellation · Lakeland, FL N556AZNasa Langley Research Center BEBOP DRONE #1 · S/N PH645337044Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Gloucester, MA N981Bell UH-1F · S/N 657936Cancelled Jul 25, 1995 · Administratively canceled · Rockville, MD N223Stinson L-5G · S/N 76-3599Cancelled Mar 23, 1954 · Built 1945 · Washington, DC N103Grumman JRF-5 · S/N B-110Cancelled Jul 10, 1952 · Washington, DC N68Beech C18S · S/N 5659Cancelled Jan 29, 1951 · Washington, DC N219Beech C18S · S/N 6063Cancelled Oct 31, 1950 · Built 1944 · Washington, DC N55Beech C18S · S/N 521Cancelled Dec 23, 1948 · Oklahoma City, OK N213Beech D17S · S/N 423Cancelled Aug 27, 1948 · Built 1942 · Washington, DC N292North American SNJ-4 · S/N 9447Cancelled Jul 15, 1948 · Built 1942 · Washington25, DC N387North American SNJ-4 · S/N 88-9561Cancelled Jul 15, 1948 · Washington, DC N296North American SNJ-4 · S/N 889476Cancelled Jul 14, 1948 · Washington, DC N279North American SNJ-4 · S/N 88-11229Cancelled Jun 9, 1948 · Built 1942 · Washington, DC N280North American SNJ-4 · S/N 10773Cancelled Mar 9, 1948 · Washington Dc, DC N63Beech D17S · S/N 4881Cancelled Jan 28, 1947 · Washington, DC N729Luscombe 8A · S/N 1758Cancelled Feb 14, 1946 · Washington, DC N183Waco UPF-7 · S/N 5602Cancelled Jan 17, 1946 · Washington, DC N5Bellanca SKYROCKET F · S/N 805Cancelled Oct 30, 1945 · Washington, DC N63Stinson SR-5E · S/N 9342-ACancelled Jan 1, 1937 · Washington, DC

Back to Department Of Commerce