Cancelled registrations · 30

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_state = 'NE' AND d.registrant_city = 'WEST POINT' 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_state = 'NE' AND d.registrant_city = 'WEST POINT'
  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_state = 'NE' AND d.registrant_city = 'WEST POINT'
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 · Turbines Ltd N363ETBell 407 · S/N 53135Cancelled Mar 4, 2025 · Exported to Ecuador · Turbines Ltd N418NABell Helicopter UH-1H II · S/N 73-21779Cancelled Jan 31, 2023 · Exported to Dominican Republic · Turbines Ltd N72594Bell UH-1H · S/N 72-21485Cancelled Jan 31, 2023 · Exported to Dominican Republic · Turbines Ltd N72593Bell UH-1H · S/N 70-16452Cancelled Dec 15, 2022 · Exported to Dominican Republic · Turbines Ltd N72595Bell UH-1H · S/N 73-21769Cancelled Dec 15, 2022 · Exported to Dominican Republic · Turbines Ltd N416NABell Helicopter UH-1H II · S/N 72-21480Cancelled Nov 22, 2022 · Exported to Dominican Republic · Turbines Ltd N419NABell UH-1H · S/N 74-22429Cancelled Nov 22, 2022 · Exported to Dominican Republic · Turbines Ltd N555BABell Helicopter Textron Canada 430 · S/N 49119Cancelled Apr 7, 2021 · Exported to South Africa · Built 2006 · Turbines Ltd N332BBAerospatiale AS332L1 · S/N 2350Cancelled Jun 25, 2020 · Exported to Canada · Turbines International Inc N474WZAerospatiale AS332L1 · S/N 2352Cancelled Jan 31, 2019 · Registration expired, pending cancellation · Turbines Ltd N20171Bell 222U · S/N 47535Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Built 1985 · Turbines Ltd N518ALSikorsky S-76A · S/N 760134Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Built 1980 · Turbines Ltd N20140Bell 222UT · S/N 47506Cancelled Feb 14, 2017 · Exported to South Africa · Built 1983 · Turbines Ltd N332TLAerospatiale AS332L1 · S/N 2397Cancelled Apr 4, 2016 · Exported to Canada · Turbines Ltd N6156RSikorsky S64 · S/N 68-18428Cancelled Aug 23, 2013 · Sale reported, canceled N3524TBell 206B · S/N 2682Cancelled Oct 17, 2012 · Exported to China · Built 1979 · Turbines Ltd N2056CBell 222U · S/N 47531Cancelled Aug 20, 2012 · Exported to Panama · Turbines Ltd N993PABell 430 · S/N 49050Cancelled Mar 23, 2012 · Exported to South Africa · Built 1999 · Turbines Ltd N121RHBell 206B · S/N 3443Cancelled Aug 31, 2010 · Exported to Ecuador · Built 1981 · Turbines Ltd N5008QBell 222 · S/N 47009Cancelled Jul 23, 2009 · Exported to South Africa · Built 1980 · Turbines Ltd N206AWBell 206B · S/N 2861Cancelled May 11, 2009 · Exported to Mexico · Turbines Ltd N49KPNorthwest Rotorcraft UH-1H · S/N 66-16149Cancelled Oct 5, 2005 · Exported to Chile · Turbines Ltd N97KPNorthwest Rotorcraft UH-1H · S/N 67-17297Cancelled Oct 5, 2005 · Exported to Chile · Built 1967 · Turbines Ltd N3149NNorthwest Rotorcraft UH-1H · S/N 63-08841Cancelled Aug 17, 2005 · Exported to Chile · Turbines Ltd N45401Northwest Rotorcraft UH-1H · S/N 68-16151Cancelled Aug 12, 2005 · Exported to Chile · Turbines Ltd N876MBell 206B · S/N 4528Cancelled Sep 3, 2004 · Exported to Austria · Built 1999 · Turbines Ltd N6154YDehavilland CARIBOU DHC-4 · S/N 6309737Cancelled Feb 9, 1998 · Exported to Canada · Turbines Ltd N244HBell 206B-III · S/N 4301Cancelled Jan 9, 1995 · Exported to Thailand · Turbines Ltd N3212DCessna 208 · S/N 20800003Cancelled Jun 20, 1994 · Exported to Australia · Turbines Ltd

Back to West Point, NE