Skip to content

Del Rio Aviation Inc

Earlier aircraft under this name · 39

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 = 'DEL RIO AVIATION INC' OR list_contains(d.other_registrant_names, 'DEL RIO AVIATION 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 = 'DEL RIO AVIATION INC' OR list_contains(d.other_registrant_names, 'DEL RIO AVIATION 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 = 'DEL RIO AVIATION INC' OR list_contains(d.other_registrant_names, 'DEL RIO AVIATION 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.

N614GEurocopter Deutschland EC135T2 · S/N 0476Cancelled Feb 19, 2026 · Exported to Mexico · Built 2006 · Paso Robles, CA N103CPSchweizer 269C · S/N S1617Cancelled Apr 30, 2024 · Exported to Mexico · Built 1992 · Paso Robles, CA N502DRBell 206B · S/N 2183Cancelled Jul 7, 2023 · Exported to Mexico · Paso Robles, CA N744JBRobinson Helicopter R44 · S/N 1066Cancelled Sep 20, 2022 · Registration expired, pending cancellation · Paso Robles, CA N58274Hughes 269C · S/N 1180719Cancelled Mar 8, 2022 · Exported to Mexico · Built 1978 · Paso Robles, CA N1354XBell 47G-4A · S/N 7537Cancelled Feb 23, 2021 · Exported to Mexico · Built 1966 · Paso Robles, CA N9248FHughes 269C · S/N 390764Cancelled May 20, 2019 · Exported to Mexico · Paso Robles, CA N9170TBell UH-1H · S/N 65-09609Cancelled Mar 29, 2017 · Second renewal notice · Paso Robles, CA N230KCRobinson Helicopter R44 · S/N 0108Cancelled Mar 23, 2017 · Exported to Mexico · Paso Robles, CA N167BHBell 206B · S/N 1961Cancelled Oct 6, 2016 · Exported to Mexico · Built 1976 · Paso Robles, CA N2063FSchweizer 269C · S/N S1735Cancelled Jul 25, 2016 · Exported to Mexico · Built 1996 · Paso Robles, CA N6002XSchweizer 269C-1 · S/N 0001Cancelled Aug 4, 2014 · Exported to Mexico · Built 1993 · Paso Robles, CA N8874FHughes 269A · S/N 0239Cancelled Nov 4, 2010 · Exported to Mexico · Built 1963 · Paso Robles, CA N2503QBell 206A · S/N 71-20530Cancelled Apr 26, 2004 · Exported to Mexico · Paso Robles, CA N622NABell 47G-3B-1 · S/N 6670Cancelled Dec 4, 2002 · Exported to Mexico · Paso Robles, CA N1851XBell OH-58C · S/N 70-15316Cancelled Jan 25, 2002 · Exported to Mexico · Paso Robles, CA N4497UPartenavia P 68 C/TC · S/N 315-24/TCCancelled Dec 19, 2001 · Exported to Mexico · Paso Robles, CA N108AGBell OH-58C · S/N 71-20646Cancelled Nov 30, 2001 · Exported to Mexico · Paso Robles, CA N107AGBell OH-58C · S/N 72-21137Cancelled May 30, 2001 · Exported to Mexico · Paso Robles, CA N7237RBell 206A-1 · S/N 44008Cancelled Dec 11, 2000 · Exported to Mexico · Paso Robles, CA N9117FBell OH-58A · S/N 68-16807Cancelled Sep 26, 2000 · Exported to Mexico · Paso Robles, CA N18LBBell 47G-2A-1 · S/N 3839Cancelled Apr 6, 2000 · Exported to Mexico · Paso Robles, CA N9668FHughes 269C · S/N 310098Cancelled Jan 5, 2000 · Exported to Mexico · Paso Robles, CA N110LBBell 47G-3B-1 · S/N 3767Cancelled Sep 15, 1999 · Exported to Mexico · Paso Robles, CA N460MCBell OH-58C · S/N 7015135Cancelled Oct 7, 1998 · Exported to Mexico · Paso Robles, CA N7236ZBell 206A-1 · S/N 44063Cancelled Jun 18, 1998 · Exported to Mexico · Paso Robles, CA N240SPBell OH-58A · S/N 7015370Cancelled Mar 19, 1998 · Exported to Mexico · Paso Robles, CA N58168Hughes Helicopters HUGHES 369D · S/N 1070218DCancelled Jan 27, 1998 · Exported to Mexico · Paso Robles, CA N82854Bell OH-58A · S/N 7120597Cancelled Sep 8, 1997 · Exported to Mexico · Paso Robles, CA N160SPBell OH-58A · S/N 7015073Cancelled Apr 1, 1997 · Exported to Mexico · Paso Robles, CA N290SPBell OH-58A · S/N 7221439Cancelled Apr 1, 1997 · Exported to Mexico · Paso Robles, CA N1167WBell OH-58C · S/N 6816707Cancelled Nov 12, 1996 · Exported to Mexico · Paso Robles, CA N98LMBell OH-58C · S/N 7120556Cancelled Oct 10, 1996 · Exported to Mexico · Paso Robles, CA N1188NBell OH-58C · S/N 7120550Cancelled Aug 30, 1996 · Exported to Mexico · Paso Robles, CA N75440Bell OH-58C · S/N 6816798Cancelled May 10, 1996 · Exported to Mexico · Paso Robles, CA N75496Bell OH-58C · S/N 7221247Cancelled May 10, 1996 · Exported to Mexico · Paso Robles, CA N9172NBell OH-58C · S/N 7221232Cancelled Jan 31, 1996 · Exported to Mexico · Paso Robles, CA N6222LBell OH-58C · S/N 7015634Cancelled Dec 29, 1995 · Exported to Mexico · Paso Robles, CA N9106RBell 47G-3B-2 · S/N 6808Cancelled Dec 21, 1995 · Exported to Mexico · Paso Robles, CA

Back to Del Rio Aviation Inc