Cancelled registrations · 17

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 = 'HI' AND d.registrant_city = 'LIHUE' 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 = 'HI' AND d.registrant_city = 'LIHUE'
  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 = 'HI' AND d.registrant_city = 'LIHUE'
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.

N209CBDJI MAVIC PRO PLATINUM · S/N 08Q2FBCP010004Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Watabu Casey M N985SAEurocopter AS 350 B2 · S/N 3111Cancelled Mar 5, 2022 · Second renewal notice · Built 1998 · Saf Ltd N7849FDJI PHANTOM 2 VISION + · S/N PH645303225 V2.0Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Grove Farm Co Inc N705PMP&M PEGASUS QUIK 912S · S/N 8245Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 2007 · Gomez Anna M N5341BCessna 152 · S/N 15283842Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1979 · Kaluahine Gordon M Sr N798JHS N I A S AS350BA · S/N 1548Cancelled Sep 13, 2007 · Exported to Canada · Built 1982 · Jack Harter Helicopters Inc N37741Bell 206B · S/N 1695Cancelled Dec 11, 2003 · Triennial form not returned · Built 1975 · Jack Harter Helicopters Inc N206SABell 206L-3 · S/N 51019Cancelled Mar 21, 2003 · Exported to Mexico · Built 1982 · Safari Aviation Inc N245VBell 206B · S/N 2527Cancelled Dec 20, 2001 · Triennial form not returned · Built 1978 · Squyres William W N594BKEurocopter AS 350 BA · S/N 2735Cancelled Mar 5, 2001 · Triennial form not returned · Ohana Aviation Inc DBA N822SAAerospatiale AS350 B2 ECUREUIL · S/N 2467Cancelled Apr 22, 1997 · Exported to Canada · Saf Ltd N2120XBell 206B · S/N 3463Cancelled Dec 10, 1991 · Triennial form not returned · Lofstedt Curtis W Jr DBA N8777SCessna 150F · S/N 15062077Cancelled Apr 4, 1983 · Administratively canceled · Coots John V N65180Sud SA 318C · S/N 2286Cancelled Jun 26, 1973 · Hawaii Helicopters International N9753ZNorth American B-25J · S/N 4431504Cancelled Oct 7, 1971 · Flair Inc N3364HErcoupe 415-CD · S/N 3989Cancelled Jan 2, 1959 · Built 1947 · Bell Joseph E Jr Etal N92356Piper J3C-65 · S/N 16813Cancelled Oct 12, 1955 · Pacific Skyways Ltd

Back to Lihue, HI