Skip to content

Cancelled registrations · 32

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

N1235JBalony Kubicek Spol Sro BB70Z · S/N 906Cancelled Mar 6, 2025 · Exported to Mexico · Built 2012 · District Aviation LLC N28300Grumman American Avn. AA-5B · S/N AA5B0538Cancelled Jun 17, 2023 · Sale reported, canceled · Built 1977 N7244WBalloon Works FIREFLY 11B · S/N F11B-003Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1999 · Vanca John M N4198ERaven Industries S-66A · S/N S66A-138Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Born Gary V N740TCColt Balloons 240A · S/N 2278Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Born Gary V N540ZAZivko Aeronautics EDGE 540-T · S/N 0010Cancelled May 9, 2022 · Registration expired, pending cancellation · Knc 2 LLC N7615FPiper PA-28-140 · S/N 28-7725090Cancelled Mar 6, 2021 · Sale reported, canceled · Built 1976 N71702Luscombe 8A · S/N 3129Cancelled Jan 31, 2020 · Revoked, canceled · Built 1946 · Stevens M A N669RBZivko Aeronautics EDGE 540 · S/N 0027Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 2000 · Chambliss Aerobatics LLC N92577Piper PA-12 · S/N 12-107Cancelled Feb 13, 2017 · Revoked, canceled · Built 1946 · Shirley E D N540KCChambliss Kirby Z-EDGE 540 · S/N 0010Cancelled May 6, 2015 · Registration expired, pending cancellation · Chambliss Maurice K N19875Cameron Balloons US N-160 · S/N 5251Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1986 N2985DCameron Balloons US N-160 · S/N 5140Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1985 N16GTTillery Gregory Walter AIRCOMMANDER · S/N AC1GWTCancelled Jul 11, 2013 · Sale reported, canceled · Built 1993 N5285XChampion 7KCAB · S/N 219Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 1969 · Nelson Roger C N82774Penney ACRODUSTER SA-750 · S/N 1-RVPCancelled Nov 9, 2012 · Sale reported, pending cancellation N54427Boeing PT-17 · S/N 75326Cancelled Sep 12, 2012 · Revoked, canceled · Built 1940 · Bolley Warren E N543BBeech D18S · S/N A-408Cancelled Aug 21, 2012 · Revoked, canceled · Built 1947 · South Marc A N65294Thunder Balloons AX7-77A · S/N 078Cancelled Apr 7, 2004 · Triennial form not returned · Built 1976 · Born Gary V N562PBeech 65-A90 · S/N LJ-248Cancelled Oct 23, 2002 · Exported to Colombia · Built 1967 · Verner Dave N6681QGrumman Acft ENG Cor-Schweizer G-164B · S/N 1700Cancelled Jan 15, 1992 · Hamman Alvin D Co Trustee N85WTWalters Robert J VIKING · S/N 001Cancelled Jul 8, 1991 · Triennial form not returned · Viking Aircraft Ltd N4941QCessna A188B · S/N 18802676TCancelled Sep 2, 1981 · Exported to Mexico · Hamman Alvin N9821PPiper PA-25-235 · S/N 25-7556139Cancelled May 27, 1980 · Exported to Mexico · Ag Aero Inc N9871PPiper PA-25-235 · S/N 25-7556199Cancelled Feb 14, 1980 · Exported to Mexico · Ag-Aero Inc N56930Boeing A75N1 · S/N 75-780Cancelled Jun 21, 1976 · Booker F E N8160CPiper PA-18A · S/N 18-3614Cancelled Sep 25, 1970 · Warren E Bolley N88559Piper J-3 · S/N 16184Cancelled Jun 29, 1970 · Booker F E N6003ZPiper PA-25 · S/N 25-6Cancelled Apr 23, 1964 · Thomasson Ed N9861DPiper PA-18A 150 · S/N 18-6878Cancelled Oct 29, 1963 · Leroux Laverne C N4909KRyan NAVION · S/N NAV-4-1909Cancelled Feb 21, 1957 · Frontier Pump & Machine Co N98222Piper J3C-65 · S/N 18389Cancelled Mar 21, 1956 · Ledbetter Sam

Back to Eloy, AZ