Skip to content

Cancelled registrations · 171

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

N246EAPipistrel D O O ALPHA TRAINER · S/N 1165 AT 912 LSACancelled Jul 21, 2026 · Built 2023 · Mesa Pilot Development LLC N935WNBoeing 737-7H4 · S/N 36641Cancelled Oct 3, 2025 · Sale reported · Built 2009 N756WHUltramagic M-56C · S/N 56/22Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 2002 · Stephenson Kevin L N90030Cessna 140 · S/N 9088Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 2000 · Monroe Thomas A Sr N7329HDJI PHANTOM 3 PROFESSION · S/N P76DCL20826174Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Perryman Andrew N19AMExtra Flugzeugbau EA 300/L · S/N 046Cancelled May 7, 2022 · Registration expired, pending cancellation · Built 1997 · Op Aviation & Consulting LLC N2184KFirefly Balloons FIREFLY 8B-15 · S/N F8B2079Cancelled May 7, 2022 · Registration expired, pending cancellation · Built 2005 · Cory Shane D N623PBBell UH-1H · S/N 64-13689Cancelled Feb 26, 2022 · Second renewal notice · Built 1964 · Aero Leasing LLC N1992NCameron Balloons US V-77 · S/N 5284Cancelled Aug 20, 2021 · Exported to Mexico · Built 1987 · Kjb LLC N2606FPiper PA-38-112 · S/N 38-79A0490Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1979 · Western Maricopa Education (West-Mec)N64654Boeing PT-17 · S/N 752286Cancelled May 8, 2020 · Revoked, canceled · Built 1941 · Lewis Wayne N8844ABeech B35 · S/N D-2499Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1950 · Monteil Felipe N7004MCessna 175 · S/N 55304Cancelled Jan 24, 2020 · Revoked, canceled · Built 1958 · Vandever Inc V Vincent N4505PPiper PA-23-250 · S/N 27-8Cancelled Jan 10, 2020 · Revoked, canceled · Built 1960 · Vandever V Vincent Inc N12242Cessna 172M · S/N 17261902Cancelled Dec 4, 2019 · Exported to Philippines · Built 1973 · Keystone Flight LLC N2775CCessna 170B · S/N 26319Cancelled Nov 29, 2019 · Revoked, canceled · Built 1954 · V Vincent Vandever Inc N6890ACessna 172 · S/N 28990Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1956 · Barnes A Kenneth N9723VCessna 172M · S/N 17264489Cancelled Oct 9, 2019 · Exported to Mexico · Built 1974 · King Transportation Inc N411PX3D Robotics SOLO · S/N S111A5606864Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Daily Mark C N93349Engineering & Research ERCOUPE 415-C · S/N 672Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Ployhar Bruce Earl N34605Cessna 177B · S/N 17701897Cancelled Jul 25, 2019 · Registration expired, pending cancellation · Rather Ronald P N210CBCessna 210 · S/N 57038Cancelled Jul 16, 2019 · Registration expired, pending cancellation · Built 1959 · Western Maricopa Education Center District No 402 N172PCCessna 172M · S/N 17267111Cancelled Jul 3, 2019 · Exported to Philippines · Built 1976 · Keystone Flight LLC N7803HPiper PA-12 · S/N 12-700Cancelled May 4, 2019 · Revoked, canceled · Built 1946 · Atkin Crop Dusters Inc N811WQIndustrial Aerobotics SD04 · S/N IA-SD04-01Cancelled Feb 25, 2019 · Registration expired, pending cancellation · Industrial Aerobotics LLC N8053GCessna 177RG · S/N 177RG0053Cancelled Dec 4, 2018 · Sale reported, canceled · Built 1971 N76782Cessna 120 · S/N 11214Cancelled May 31, 2018 · Sale reported, canceled · Built 1946 N49SXKevin L Lawrence SONEX · S/N 278Cancelled May 30, 2018 · Sale reported, canceled N5142YPiper PA-23-250 · S/N 27-2173Cancelled May 30, 2018 · Sale reported, canceled · Built 1962 N7932JBell 47G-3B-2 · S/N 6799Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Underwood John P N3817TPiper PA-28R-180 · S/N 28R-30133Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1967 · Vasilev Boris S N57AWBell 206-L4 · S/N 52004Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1992 · N57aw LLC N2587QBalloon Works FIREFLY 8B-15 · S/N F8B-472Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Pyramid Pool LLC N9791TCessna 172A · S/N 47591Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1960 · Muffitt Jerome P N25780Balloon Works FIREFLY 7-15 · S/N F7-831Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Harrison Dorothy E N19DVRobinson Helicopter R44 II · S/N 11027Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 2005 · Dooley Aviation Inc N7749HPiper PA-12 · S/N 12-647Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Atkin Crop Dusters Inc N1678KLuscombe 8A · S/N 4405Cancelled Oct 28, 2017 · Revoked, canceled · Built 1946 · V Vincent Vandever Inc N3428BBeech D35 · S/N D-3666Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1953 · American National Transport Inc N50257Avian Balloon MAGNUM IX · S/N 173Cancelled Jun 22, 2017 · Third renewal notice · Cory Shane D N5865BCessna 182A · S/N 33865Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1956 · Azdsc Skydivers Inc N4820YPiper PA-25-260 · S/N 25-4591Cancelled May 16, 2017 · Registration expired, pending cancellation · Built 1968 · Everett John D N1998TBernier Timothy 162F · S/N 6218Cancelled Mar 21, 2017 · Registration expired, pending cancellation · White Calf Island Corp N5321PCessna 152 · S/N 15284913Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1981 · Glendale Aviation L L C N9168ZNorth American SNJ-5B · S/N 90953Cancelled Feb 13, 2017 · Revoked, canceled · Built 1943 · Moseley Ernest E N130TTRockwell International 690B · S/N 11495Cancelled Jun 30, 2016 · Built 1978 · Sunrise Air Transportation LLC N160RCessna 310 · S/N 35259Cancelled Feb 22, 2016 · Built 1956 · Stratton Robert G N8808NPiper PA-28-140 · S/N 28-25654Cancelled May 21, 2015 · Sale reported, canceled · Built 1969 N502AWWilliams Helicopter UH-1H · S/N 69-15340Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1998 · Aero Leasing LLC N4564WRockwell International 112TC · S/N 13054Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1976 · Putnam Roger V

Back to Glendale, AZ