Skip to content

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 = 'TURBINES LTD' OR list_contains(d.other_registrant_names, 'TURBINES LTD') 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 = 'TURBINES LTD' OR list_contains(d.other_registrant_names, 'TURBINES LTD')
  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 = 'TURBINES LTD' OR list_contains(d.other_registrant_names, 'TURBINES LTD')
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.

N101TLBell Helicopter Textron Canada 206B · S/N 4670Cancelled Mar 4, 2025 · Exported to Ecuador · Built 2009 · West Point, NE N363ETBell 407 · S/N 53135Cancelled Mar 4, 2025 · Exported to Ecuador · West Point, NE N418NABell Helicopter UH-1H II · S/N 73-21779Cancelled Jan 31, 2023 · Exported to Dominican Republic · West Point, NE N67620Bell 206B · S/N 5179Cancelled Jan 31, 2023 · Exported to Dominican Republic · Built 1994 · Steamboat Springs, CO N72594Bell UH-1H · S/N 72-21485Cancelled Jan 31, 2023 · Exported to Dominican Republic · West Point, NE N72593Bell UH-1H · S/N 70-16452Cancelled Dec 15, 2022 · Exported to Dominican Republic · West Point, NE N72595Bell UH-1H · S/N 73-21769Cancelled Dec 15, 2022 · Exported to Dominican Republic · West Point, NE N416NABell Helicopter UH-1H II · S/N 72-21480Cancelled Nov 22, 2022 · Exported to Dominican Republic · West Point, NE N419NABell UH-1H · S/N 74-22429Cancelled Nov 22, 2022 · Exported to Dominican Republic · West Point, NE N555BABell Helicopter Textron Canada 430 · S/N 49119Cancelled Apr 7, 2021 · Exported to South Africa · Built 2006 · West Point, NE N474WZAerospatiale AS332L1 · S/N 2352Cancelled Jan 31, 2019 · Registration expired, pending cancellation · West Point, NE N20171Bell 222U · S/N 47535Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Built 1985 · West Point, NE N518ALSikorsky S-76A · S/N 760134Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Built 1980 · West Point, NE N20140Bell 222UT · S/N 47506Cancelled Feb 14, 2017 · Exported to South Africa · Built 1983 · West Point, NE N332TLAerospatiale AS332L1 · S/N 2397Cancelled Apr 4, 2016 · Exported to Canada · West Point, NE N3524TBell 206B · S/N 2682Cancelled Oct 17, 2012 · Exported to China · Built 1979 · West Point, NE N2056CBell 222U · S/N 47531Cancelled Aug 20, 2012 · Exported to Panama · West Point, NE N993PABell 430 · S/N 49050Cancelled Mar 23, 2012 · Exported to South Africa · Built 1999 · West Point, NE N121RHBell 206B · S/N 3443Cancelled Aug 31, 2010 · Exported to Ecuador · Built 1981 · West Point, NE N5008QBell 222 · S/N 47009Cancelled Jul 23, 2009 · Exported to South Africa · Built 1980 · West Point, NE N206AWBell 206B · S/N 2861Cancelled May 11, 2009 · Exported to Mexico · West Point, NE N111DSBell 222U · S/N 47554Cancelled Jul 25, 2008 · Exported to Ethiopia · Built 1986 · Denton, TX N49KPNorthwest Rotorcraft UH-1H · S/N 66-16149Cancelled Oct 5, 2005 · Exported to Chile · West Point, NE N97KPNorthwest Rotorcraft UH-1H · S/N 67-17297Cancelled Oct 5, 2005 · Exported to Chile · Built 1967 · West Point, NE N3149NNorthwest Rotorcraft UH-1H · S/N 63-08841Cancelled Aug 17, 2005 · Exported to Chile · West Point, NE N45401Northwest Rotorcraft UH-1H · S/N 68-16151Cancelled Aug 12, 2005 · Exported to Chile · West Point, NE N876MBell 206B · S/N 4528Cancelled Sep 3, 2004 · Exported to Austria · Built 1999 · West Point, NE N6154YDehavilland CARIBOU DHC-4 · S/N 6309737Cancelled Feb 9, 1998 · Exported to Canada · West Point, NE N244HBell 206B-III · S/N 4301Cancelled Jan 9, 1995 · Exported to Thailand · West Point, NE N3212DCessna 208 · S/N 20800003Cancelled Jun 20, 1994 · Exported to Australia · West Point, NE

Back to Turbines Ltd