Skip to content

Diamond Financial Inc

Earlier aircraft under this name · 49

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 = 'DIAMOND FINANCIAL INC' OR list_contains(d.other_registrant_names, 'DIAMOND FINANCIAL INC') 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 = 'DIAMOND FINANCIAL INC' OR list_contains(d.other_registrant_names, 'DIAMOND FINANCIAL INC')
  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 = 'DIAMOND FINANCIAL INC' OR list_contains(d.other_registrant_names, 'DIAMOND FINANCIAL INC')
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.

N243CLDiamond Aircraft Ind DA20-C1 · S/N C0044Cancelled Aug 27, 2004 · Exported to New Zealand · London N848DFDiamond Aircraft Ind DA20-A1 · S/N 10004Cancelled May 2, 2003 · Exported to Austria · Built 1994 · London Ontario N293DADiamond Aircraft Ind DA20-A1 · S/N 10293Cancelled Mar 4, 2003 · Exported to Austria · Built 1997 · London Ontario N237DADiamond Aircraft Ind DA20-A1 · S/N 10235Cancelled Aug 8, 2002 · Exported to Austria · Built 1997 · London Ontario N309DADiamond Aircraft Ind DA20-A1 · S/N 10309Cancelled Oct 1, 2001 · Exported to Austria · Sarasota, FL N264DADiamond Aircraft Ind DA20-A1 · S/N 10261Cancelled Dec 15, 2000 · Exported to Canada · Wilmington, DE N668DADiamond Aircraft Ind DA20-A1 · S/N 10191Cancelled Oct 26, 2000 · Exported to Austria · Wilmington, DE N604FDiamond Aircraft Ind DA20-A1 · S/N 10012Cancelled Jul 5, 2000 · Exported to Austria · Wilmington, DE N19DVHoac-Austria DV-20 KATANA · S/N 20019Cancelled Mar 17, 2000 · Exported to Canada · Sarasota, FL N642DADiamond Aircraft Ind DA20-A1 · S/N 10312Cancelled Jan 26, 2000 · Exported to Canada · Sarasota, FL N96DVHoac-Austria DV-20 KATANA · S/N 20096Cancelled Jan 19, 2000 · Exported to Austria · Sarasota, FL N35DVHoac-Austria DV-20 KATANA · S/N 20.036Cancelled Aug 4, 1999 · Exported to Austria · Sarasota, FL N39DVHoac-Austria DV-20 KATANA · S/N 20.039Cancelled Aug 4, 1999 · Exported to Austria · Sarasota, FL N45DVHoac-Austria DV-20 KATANA · S/N 20045Cancelled Aug 4, 1999 · Exported to Austria · Sarasota, FL N29DVHoac-Austria DV-20 KATANA · S/N 20028Cancelled Aug 3, 1999 · Exported to Austria · Sarasota, FL N18DVHoac-Austria DV-20 KATANA · S/N 20018Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N192DVHoac-Austria DV-20 KATANA · S/N 20092Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N194DVHoac-Austria DV-20 KATANA · S/N 20094Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N197DVHoac-Austria DV-20 KATANA · S/N 20097Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N199DVHoac-Austria DV-20 KATANA · S/N 20099Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N200DVHoac-Austria DV-20 KATANA · S/N 20088Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N203DVHoac-Austria DV-20 KATANA · S/N 20.103Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N27DVHoac-Austria DV-20 KATANA · S/N 20027Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N41DVHoac-Austria DV-20 KATANA · S/N 20.040Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N44DVHoac-Austria DV-20 KATANA · S/N 20044Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N48DVHoac-Austria DV-20 KATANA · S/N 20048Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N49DVHoac-Austria DV-20 KATANA · S/N 20049Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N54DVHoac-Austria DV-20 KATANA · S/N 20054Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N87DVHoac-Austria DV-20 KATANA · S/N 20087Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N95DVHoac-Austria DV-20 KATANA · S/N 20095Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N98DVHoac-Austria DV-20 KATANA · S/N 20098Cancelled Jul 30, 1999 · Exported to Austria · Sarasota, FL N228PDiamond Aircraft Ind DA20-A1 · S/N 10054Cancelled Jun 19, 1998 · Exported to Germany · Wilmington, DE N608FDiamond Aircraft Ind DA20-A1 · S/N 10033Cancelled Jun 19, 1998 · Exported to Germany · Wilmington, DE N896DADiamond Aircraft Ind DA20-A1 · S/N 10296Cancelled Apr 6, 1998 · Exported to Canada · Wilmington, DE N177DADiamond Aircraft Ind DA20-A1 · S/N 10177Cancelled Oct 20, 1997 · Exported to United Kingdom · Wilmington, DE N322FTDiamond Aircraft Ind DA20-A1 · S/N 10021Cancelled May 9, 1997 · Exported to Czech Republic · Wilmington, DE N284DADiamond Aircraft Ind DA20-A1 · S/N 10184Cancelled Apr 28, 1997 · Exported to Canada · Wilmington, DE N185DADiamond Aircraft Ind DA20-A1 · S/N 10185Cancelled Mar 19, 1997 · Wilmington, DE N674DADiamond Aircraft Ind DA20-A1 · S/N 10201Cancelled Mar 19, 1997 · Wilmington, DE N852DFDiamond Aircraft Ind DA20-A1 · S/N 10192Cancelled Mar 19, 1997 · Wilmington, DE N321FTDiamond Aircraft Ind DA20-A1 · S/N 10020Cancelled Mar 17, 1997 · Exported to Canada · Wilmington, DE N86DVHoac-Austria DV-20 KATANA · S/N 20086Cancelled Apr 12, 1996 · Exported to Australia · Wilmington, DE N195DADiamond Aircraft Ind DA20-A1 · S/N 10093Cancelled Apr 2, 1996 · Exported to Germany · Wilmington, DE N850DFDiamond Aircraft Ind DA20-A1 · S/N 10080Cancelled Mar 7, 1996 · Exported to South Africa · Wilmington, DE N189MFDiamond Aircraft Ind DA20-A1 · S/N 10089Cancelled Feb 28, 1996 · Exported to Germany · Wilmington, DE N199DADiamond Aircraft Ind DA20-A1 · S/N 10059Cancelled Feb 16, 1996 · Exported to Australia · Wilmington, DE N104DVHoac-Austria DV-20 KATANA · S/N 20104Cancelled May 25, 1995 · Exported to Canada · Wilmington, DE N105DVHoac-Austria DV-20 KATANA · S/N 20105Cancelled May 25, 1995 · Exported to Canada · Wilmington, DE N202DVHoac-Austria DV-20 KATANA · S/N 20102Cancelled May 10, 1995 · Exported to Canada · Wilmington, DE

Back to Diamond Financial Inc