Skip to content

Cancelled registrations · 548

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 = 'HONOLULU' 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 = 'HONOLULU'
  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 = 'HONOLULU'
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.

N545PHMcdonnell Douglas Helicopter 369E · S/N 0536ECancelled Nov 24, 2025 · Registration pending, canceled · Built 1997 N72HBPiper PA-23-250 · S/N 27-7754149Cancelled Jun 11, 2025 · Built 1977 · Cottrell James Arley III N825BCBoeing 717-200 · S/N 55174Cancelled Feb 25, 2025 · Hawaiian Airlines Inc N728BCBoeing 717-200 · S/N 55172Cancelled Dec 14, 2024 · Hawaiian Airlines Inc N811HCAtr-Gie Avions De Transport ATR-72-201 · S/N 227Cancelled Oct 16, 2023 · Exported to Hungary · Built 1991 · Airline Contract Maintenance & Equipment Inc N9511Eurocopter AS 350 B2 · S/N 1324Cancelled Aug 22, 2023 · Exported to Australia · Built 1980 · Schuman Carriage Company Ltd N804HCEads/Alenia ATR ATR 42-500 · S/N 623Cancelled Jul 27, 2023 · Built 2004 · Airline Contract Maintenance And Equipment Inc N40370Piper PA-23-250 · S/N 27-7305133Cancelled Jun 26, 2023 · Registration pending, canceled · Built 1973 N806HCAerospatiale/Alenia ATR42-500 · S/N 594Cancelled Mar 28, 2023 · Airline Contract Maintenance And Equipment Inc N805HCEads/Alenia ATR ATR 42-500 · S/N 625Cancelled Feb 1, 2023 · Exported to Canada · Built 2004 · Airline Contract Maintenance And Equipment Inc N532KACessna 150M · S/N 15078140Cancelled Jan 14, 2023 · Registration pending, canceled N727EMCessna 172N · S/N 17269621Cancelled Jan 2, 2023 · Registration expired, pending cancellation · Built 1977 · Georges Aviation Services Inc N808AQDJI INSPIRE 1 · S/N W13DCE11031539Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Kapiolani Community College N6400RPiper PA-28-140 · S/N 28-21578Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1966 · Gonzalez Luis C N7056HRobinson Helicopter R44 · S/N 0497Cancelled Nov 5, 2022 · Registration expired, pending cancellation · N7056h LLC N6912DPiper PA-28-181 · S/N 28-8590052Cancelled Sep 26, 2022 · Registration pending, canceled · Built 1985 N5060YPiper PA-23-250 · S/N 27-2072Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1962 · Georges Aviation Services Inc N807HCAerospatiale/Alenia ATR-72-212 · S/N 432Cancelled May 6, 2022 · Exported to Canada · Built 1994 · Airline Contract Maintenance And Equipment Inc N810HCAerospatiale/Alenia ATR-72-212 · S/N 423Cancelled May 6, 2022 · Exported to Canada · Built 1994 · Airline Contract Maintenance And Equipment Inc N44270Robinson Helicopter R22 BETA · S/N 0733Cancelled Apr 2, 2022 · Registration expired, pending cancellation · N44270 LLC N801HEPhysical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030200300640Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Hawaiian Electric Co N595KDDJI INSPIRE 1 · S/N W13DCC15020328Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Owen Peter T N802HEPhysical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030200300641Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Hawaiian Electric Co N550FTPiper PA-28RT-201 · S/N 28R-8218024Cancelled Jul 31, 2021 · Sale reported, canceled · Built 1982 N282KKDJI MAVIC PRO · S/N 08QDE2401201BQCancelled Jul 3, 2021 · Registration expired, pending cancellation · Kulia LLC N680DSDiamond Aircraft Ind DA 40 · S/N 40.680Cancelled Jun 28, 2021 · Built 2006 · George'S Aviation Services Inc N481SMPezetel SZD-48-1JANTAR STD 2 · S/N B1205Cancelled Jun 9, 2021 · Registration expired, pending cancellation · Pandya Jay T N1310LCessna 337G · S/N 33701803Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1977 · Hawaii From Above LLC N4041GRobinson Helicopter R66 · S/N 0830Cancelled Apr 7, 2021 · Exported to Canada · Built 2017 · Bento Air LLC N64057Cessna R182 · S/N R18202024Cancelled Dec 28, 2020 · Registration expired, pending cancellation · Built 1985 · East Oahu Pet Hospital LLC N481HABoeing 717-200 · S/N 55126Cancelled Oct 26, 2020 · Built 2001 · Hawaiian Airlines Inc N1841CPhantom Aeronautics PHANTOM X-1 · S/N 6580Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 2007 · Hudson Kenneth J N813BKDJI INSPIRE 1 · S/N W13DDH09060954Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Kalodimos Nicholas P N421ABCessna 421A · S/N 421A0058Cancelled Jul 24, 2020 · Second renewal notice · Built 1969 · R & J Aviators LLC N22ARCessna 421A · S/N 421A0054Cancelled May 8, 2020 · Sale reported, canceled N6255KRepublic RC-3 · S/N 462Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Pearl Harbor Aviation Museum N796QPDJI PHANTOM 4 · S/N 07DDD4Q0A10506Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Skies The Limit Productions LLC N231HBeech E18S · S/N BA-281Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 1957 · Kamaka Air Inc N5794WPiper PA-28-150 · S/N 28-1723Cancelled Dec 20, 2019 · Revoked, canceled · Built 1964 · Mcpheeters James H N808MKFreefly Systems ALTA 6 · S/N 151267Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Skies The Limit Productions LLC N776TUDJI PHANTOM 4 · S/N 07DDD3T0B10173Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Skies The Limit Production LLC N23613Taylorcraft BL-65 · S/N 1337Cancelled Nov 25, 2019 · Revoked, canceled · Built 1939 · Char Calvin C N756LHDJI S1000+ · S/N 03P0015973Cancelled Oct 5, 2019 · Registration expired, pending cancellation · College Of Tropical Agriculture & Human Resources N808NVRobinson Helicopter R44 · S/N 0926Cancelled Sep 25, 2019 · Built 2000 · United Helicopter Leasing LLC N632NVRobinson Helicopter R44 · S/N 2435Cancelled Sep 23, 2019 · Third renewal notice · Built 2016 · United Helicopter Leasing LLC N27877Piper PA-31-350 · S/N 317952019Cancelled Sep 12, 2019 · Exported to El Salvador · Air Molokai Inc N1485HAeronca 15AC · S/N 15AC556Cancelled Sep 6, 2019 · Revoked, canceled · Built 1951 · Skypac Ltd N240HADJI INSPIRE 1 · S/N W13DCD8030686Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Inspect Hawaii LLC N4244TPiper PA-28-140 · S/N 28-7225103Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1971 · Mueller Jahn P N729PCShort Bros SD3-60 · S/N SH3729Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Trans Executive Airlines Of Hawaii In DBA

Back to Honolulu, HI