Skip to content

Cancelled registrations · 29

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 = 'ID' AND d.registrant_city = 'HAYDEN' 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 = 'ID' AND d.registrant_city = 'HAYDEN'
  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 = 'ID' AND d.registrant_city = 'HAYDEN'
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.

N348TACostruzioni Aeronautiche Tecna P2008 · S/N 202Cancelled Feb 23, 2026 · Expired dealer · Built 2022 · Clear Blue Aviation LLC N61355Fairchild M-62A-4 · S/N T42-4162Cancelled Dec 27, 2025 · Sale reported, canceled N4526KNavion NAVION A · S/N NAV-4-1526Cancelled Apr 19, 2025 · Sale reported, canceled N700RFFrets Glynn CHRISTEN EAGLE II · S/N F-0047Cancelled Sep 7, 2024 · Registration pending, canceled · Built 1982 N3129YCessna 182E · S/N 18254129Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1962 · Johnson John P A N2407TNavion NAVION G · S/N NAV-4-2407Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1962 · No Limits Aviation Inc N696LDYuneec Electric TYPHOON Q500 4K · S/N YU15262479B04B01Cancelled Jan 14, 2023 · Sale reported, canceled N61KJBell Helicopter Textron 206L-1 · S/N 45677Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Kelly Kathy S N3944EAeronca 11BC · S/N 11BC-25Cancelled Feb 28, 2022 · Registration pending · Built 1947 N103EUSensefly EBEE AG · S/N EB-03-31668Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Empire Unmanned LLC N3370CBeech F35 · S/N D-4037Cancelled Dec 11, 2020 · Sale reported, canceled N6989LCessna 310K · S/N 310K0089Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1966 · North Idaho College N107EUSensefly EBEE AG · S/N EB-03-01314Cancelled May 29, 2020 · Registration expired, pending cancellation · Empire Unmanned LLC N106EUSensefly EBEE AG · S/N EB-03-24899Cancelled May 1, 2020 · Registration expired, pending cancellation · Empire Unmanned LLC N451KKKirby G Kiehle GARY II · S/N 07152011Cancelled Mar 11, 2020 · First renewal notice · Built 2011 · Kiehle Kirby G N105EUSensefly EBEE · S/N ER-01-25697Cancelled Jan 3, 2020 · Registration expired, pending cancellation · Empire Unmanned N101EUSensefly EBEE AG · S/N EB-03-23109Cancelled Jan 29, 2019 · Registration expired, pending cancellation · Empire Unmanned LLC N102EUSensefly EBEE AG · S/N EB-03-26807Cancelled Jan 29, 2019 · Registration expired, pending cancellation · Empire Unmanned LLC N104EUDJI PHANTOM 2 · S/N PH636158255Cancelled Jan 29, 2019 · Registration expired, pending cancellation · Empire Unmanned LLC N9449KStinson 108-2 · S/N 108-2449Cancelled Jun 4, 2018 · Sale reported, canceled · Built 1947 N9478XCessna 210A · S/N 21057778Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1961 · Close Christopher N8851TCessna 182C · S/N 52751Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Cripe Robert J N7547EChampion AERONCA 7FC · S/N 7FC-251Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1958 · Meoak Joseph H N1598Stearman C3-B · S/N 173Cancelled Sep 3, 2014 · Sale reported, canceled · Built 1928 N998DGMooney M-18LA · S/N 119Cancelled Apr 3, 2014 · Sale reported · Built 1952 N62736Cessna T210M · S/N 21062216Cancelled Dec 31, 2013 · Exported to Mexico · Built 1977 · Klein Dennis L N301ASRobinson Helicopter R44 · S/N 0324Cancelled Mar 11, 2008 · Exported to Canada · Built 1997 · Lunceford Earl G Trustee N6755NMooney M20C · S/N 680069Cancelled Jun 25, 1997 · Exported to Canada · Jones Dene P N3986JCessna 150G · S/N 15065286Cancelled Jun 12, 1995 · Triennial form not returned · Mckay Wade D

Back to Hayden, ID