Skip to content

Cancelled registrations · 253

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 = 'CA' AND d.registrant_city = 'PALO ALTO' 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 = 'CA' AND d.registrant_city = 'PALO ALTO'
  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 = 'CA' AND d.registrant_city = 'PALO ALTO'
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.

N924NEAlways Blue Skies BLACKFLY V3 · S/N SN103-9594Cancelled Sep 16, 2024 · Exported to Canada · Always Blue Skies Inc N22NTCannon Walter R KITFOX · S/N 43Cancelled Jan 19, 2024 · Built 1988 · Cannon Walter B Trustee N879KBOpener BLACKFLY V3 · S/N 100-4242Cancelled Apr 15, 2023 · Registration expired, pending cancellation · Built 2019 · Opener Inc N879LBOpener BLACKFLY V3 · S/N 100-4942Cancelled Apr 15, 2023 · Registration expired, pending cancellation · Opener Inc N879NAOpener BLACKFLY V3 · S/N SN100-4941Cancelled Apr 15, 2023 · Registration expired, pending cancellation · Built 2019 · Opener Inc N221HVKitty Hawk HEAVISIDE 2 · S/N H2.2-003Cancelled Jan 11, 2023 · Registration expired, pending cancellation · Kitty Hawk Corp N223HVKitty Hawk HEAVISIDE 2 · S/N H2.2-004Cancelled Jan 11, 2023 · Registration expired, pending cancellation · Kitty Hawk Corp N224HVKitty Hawk HEAVISIDE 2 · S/N H2.2-005Cancelled Jan 11, 2023 · Registration expired, pending cancellation · Kitty Hawk Corp N225HVKitty Hawk HEAVISIDE 2 · S/N H2.2-006Cancelled Jan 11, 2023 · Registration expired, pending cancellation · Kitty Hawk Corp N226HVKitty Hawk HEAVISIDE 2 · S/N H2.2-007Cancelled Jan 11, 2023 · Registration expired, pending cancellation · Kitty Hawk Corp N227HVKitty Hawk HEAVISIDE 2 · S/N H2.2-008Cancelled Jan 11, 2023 · Registration expired, pending cancellation · Kitty Hawk Corp N2165Dornier ALPHA-JET · S/N 0165Cancelled May 7, 2022 · Registration expired, pending cancellation · Built 1982 · H211 LLC N220HVKitty Hawk HEAVISIDE 2 · S/N H2-002Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Kitty Hawk Corp N620BSOpener BLACKFLY V3 · S/N SN100-2577Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 2018 · Opener Inc N8574BOpener BLACKFLY V3 · S/N SN100-2796Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Opener Inc N8575POpener BLACKFLY V3 · S/N SN100-2678Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Opener Inc N3300HRobinson Helicopter R44 II · S/N 12609Cancelled Nov 29, 2021 · Exported to Japan · Victor Aviation Service Inc N4195UCessna 182S · S/N 18280365Cancelled Aug 24, 2020 · Exported to Thailand · Built 1998 · Nano Solar LLC N5578TGlasflugel MOSQUITO · S/N 67Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1978 · Burward-Hoy Graeme William N200FLKitty Hawk FLYER · S/N F26088Cancelled Jul 23, 2020 · Kitty Hawk Corp N204FLKitty Hawk FLYER · S/N F26091Cancelled Jul 23, 2020 · Kitty Hawk Corp N209FLKitty Hawk FLYER · S/N F26089Cancelled Jul 23, 2020 · Kitty Hawk Corp N218FLKitty Hawk FLYER · S/N F26090Cancelled Jul 23, 2020 · Kitty Hawk Corp N748FLKitty Hawk FLYER · S/N F26071Cancelled Jul 23, 2020 · Kitty Hawk Corp N753FLKitty Hawk FLYER · S/N F26072Cancelled Jul 23, 2020 · Kitty Hawk Corp N788FLKitty Hawk FLYER · S/N F26073Cancelled Jul 23, 2020 · Kity Hawk Corp N796FLKitty Hawk FLYER · S/N F26074Cancelled Jul 23, 2020 · Kitty Hawk Corp N832FLKitty Hawk FLYER · S/N F26075Cancelled Jul 23, 2020 · Kitty Hawk Corp N867FLKitty Hawk FLYER · S/N F26076Cancelled Jul 23, 2020 · Kitty Hawk Corp N879FLKitty Hawk FLYER · S/N F26078Cancelled Jul 23, 2020 · Kitty Hawk Corporation N880FLKitty Hawk FLYER · S/N F26081Cancelled Jul 23, 2020 · Kitty Hawk Corp N882FLKitty Hawk FLYER · S/N F26084Cancelled Jul 23, 2020 · Kitty Hawk Corp N883FLKitty Hawk FLYER · S/N F26086Cancelled Jul 23, 2020 · Kitty Hawk Corp N885FLKitty Hawk FLYER · S/N F26079Cancelled Jul 23, 2020 · Kitty Hawk Corp N886FLKitty Hawk FLYER · S/N F26082Cancelled Jul 23, 2020 · Kitty Hawk Corp N887FLKitty Hawk FLYER · S/N F26085Cancelled Jul 23, 2020 · Kitty Hawk Corp N888FLKitty Hawk FLYER · S/N F26087Cancelled Jul 23, 2020 · Kitty Hawk Corp N889FLKitty Hawk FLYER · S/N F26080Cancelled Jul 23, 2020 · Kity Hawk Corp N890FLKitty Hawk FLYER · S/N F26083Cancelled Jul 23, 2020 · Kitty Hawk Corp N948FLKitty Hawk FLYER · S/N F26077Cancelled Jul 23, 2020 · Kitty Hawk Corp N67028Stinson L-5 · S/N 76-487Cancelled Aug 5, 2019 · Revoked, canceled · Built 1943 · Simon Leroy R N607VPDJI PHANTOM 2 VISION · S/N BC241436402797Cancelled May 30, 2018 · Sale reported, canceled N2204PPiper PA-23-150 · S/N 23-814Cancelled May 18, 2018 · Revoked, canceled · Built 1956 · Seifert Charles J Jr N821SGCirrus Design SR22T · S/N 0185Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 2011 · Ddlv LLC N3083UCessna 172E · S/N 17250683Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 1963 · Jorgenson Lawrence Aircraft Sales N97917Stinson 108-1 · S/N 108-917Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1946 · Ganschow Donald E N91506North American NAVION · S/N NAV-4-301Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Built 1946 · Morley Bruce N63CPSizemore CASSUTT 111M · S/N DS01Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1974 · Rossi Aircraft Inc N6709UMooney M20C · S/N 2441Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 1963 · Lefton Steven A N3284XPavan S Bhatnagar THUNDERGULL-JT2 · S/N 12345Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 2005 · Bhatnagar Pavan S

Back to Palo Alto, CA