Skip to content

Cancelled registrations · 75

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 = 'AZ' AND d.registrant_city = 'DOUGLAS' 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 = 'AZ' AND d.registrant_city = 'DOUGLAS'
  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 = 'AZ' AND d.registrant_city = 'DOUGLAS'
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.

N571CCE-Flite APPRENTICE S · S/N 85607-571CCCancelled Feb 5, 2022 · Registration expired, pending cancellation · Cochise Community College N572CCE-Flite APPRENTICE S · S/N 85607-572CCCancelled Feb 5, 2022 · Registration expired, pending cancellation · Cochise Community College N573CCE-Flite APPRENTICE S · S/N 85607-573CCCancelled Feb 5, 2022 · Registration expired, pending cancellation · Cochise Community College N621PH3D Robotics DIY QUAD KIT · S/N 85607-621Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Cochise Community College N622PH3D Robotics DIY QUAD KIT · S/N 85607-622Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Cochise Community College N623PH3D Robotics DIY QUAD KIT · S/N 85607-623Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Cochise Community College N624PH3D Robotics DIY QUAD KIT · S/N 85607-624Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Cochise Community College N4051ECessna T210L · S/N 21060228Cancelled Jan 10, 2020 · Sale reported, canceled N59241Boeing PT-17 · S/N 752713Cancelled Dec 5, 2019 · Revoked, pending cancellation · Built 1941 · Richey W Shelley N2226CCessna 180 · S/N 30526Cancelled Sep 16, 2019 · Revoked, pending cancellation · Built 1953 · A Frisby Florencio N5377UCessna U206G · S/N U20605258Cancelled Jun 19, 2019 · Exported to Mexico · Built 1979 · Ibarrola Manuel G N151CUPrioria Robotics MAVERIC · S/N M100-100151Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Cochise Community College N131DJDJI INSPIRE 1 · S/N W13DCA19020939Cancelled Oct 22, 2018 · Registration expired, pending cancellation · Cochise Community College N9901TCessna 182C · S/N 53001Cancelled Aug 23, 2018 · Revoked, canceled · Built 1960 · Kenyon A R N152CUPrioria Robotics MAVERIC · S/N M100-100152Cancelled Aug 9, 2018 · Registration expired, pending cancellation · Cochise Community College N153CUPrioria Robotics MAVERIC · S/N M100-100153Cancelled Aug 9, 2018 · Registration expired, pending cancellation · Cochise Community College N12GPGrumman G-1159 · S/N 63Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1969 · Garcia Rafael C N3218NConrad William R PULSAR · S/N 173Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Maldonado Lyvonna Kay N903BYRobinson Helicopter R22 · S/N 2927Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1999 · Snure Richard R N3226ALockheed C-130A · S/N 57-523Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Montano Huberto Trustee N3843KTemco GC-1B · S/N 3543Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1948 · Snyder George W N6GZElam Daryl B GAZELLE · S/N 001Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Built 1996 · Elam Daryl B N880KCessna U206G · S/N U20606633Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1982 · Valenzuela Ignacio Jose N53448Fairchild M-62A · S/N T43-7337Cancelled Dec 22, 2014 · Revoked, canceled · Built 1944 · Duckworth Walter F N85833Aeronca 11AC · S/N 11AC-250Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Abrahamson Joe A N6012Lockheed 18-56 · S/N 2256Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Hale Lindsay W N9191ZS. Hall Cherokee II J. M. BAKER · S/N 1Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1960 N47HMAero Commander 680V · S/N 1691-70Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1967 N3980YCessna 210D · S/N 21058480Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1964 · G G And M Aviators Inc N76992Cessna 120 · S/N 11438Cancelled Oct 22, 2012 · Sale reported, pending cancellation · Built 1946 N25593Cessna 152 · S/N 15280753Cancelled Sep 12, 2012 · Registration expired, pending cancellation · Built 1977 · Taylor Dwight K N143PCessna 305A · S/N 21501Cancelled May 5, 2005 · Triennial form not returned · Built 1951 · Spacecraft Aviation Services Co N182PACessna 182R · S/N 18268115Cancelled May 16, 2001 · Exported to Mexico · Teran Bernardo N4755Beech UC-45J · S/N 67311Cancelled Dec 11, 2000 · Triennial form not returned · Cochise College N75209Beech QU-22B · S/N 701542Cancelled Jul 29, 1997 · Triennial form not returned · Cochise College N1358CPiper PA-18A-135 · S/N 182529Cancelled Sep 14, 1994 · Triennial form not returned · Tribal Air Communications Inc N54834Piper PA-23-250 · S/N 277554133Cancelled Jul 12, 1994 · Exported to Senegal · New Tribes Mission Inc DBA N4850Beech UC-45J · S/N 51120Cancelled Mar 16, 1994 · Triennial form not returned · Cochise College N40751Piper PA-31-350 · S/N 318152041Cancelled Apr 29, 1993 · Exported to Papua New Guinea · Tribal Air Communication Inc N28723Piper PA-28-161 · S/N 287916410Cancelled Dec 1, 1992 · Triennial form not returned · Cochise Community College N3106YCessna A185F · S/N 18503641Cancelled Oct 22, 1991 · Exported to Venezuela · Tribal Air Communications Inc N8516XCessna 175C · S/N 17557116Cancelled Oct 9, 1991 · Cocgise Community College N89080Cessna 152 · S/N 15282622Cancelled Aug 13, 1991 · Exported to Israel · Haxton James B N61305Cessna 150J · S/N 15070951Cancelled Feb 28, 1991 · Triennial form not returned · Cochise Community College N62846Piper PA-23-250 · S/N 27-7754084Cancelled Aug 23, 1985 · Exported to Bolivia · Tribal Air Communications Inc N93956Cessna 210L · S/N 21060465Cancelled Nov 23, 1983 · Administratively canceled · Cochise College N29183Cessna U206C · S/N U206-1148Cancelled Jul 6, 1982 · Exported to Senegal · Built 1968 · Tribal Air Communications Inc N4959North American F-86L · S/N 53-742Cancelled Jan 14, 1982 · Cochise College N7064YPiper PA-30 · S/N 30-76Cancelled Jan 8, 1976 · Cochise College N8858NPiper PA-28-140 · S/N 28-25713Cancelled May 7, 1975 · Built 1969 · Cochise College

Back to Douglas, AZ