Skip to content

Cancelled registrations · 88

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 = 'IN' AND d.registrant_city = 'ANDERSON' 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 = 'IN' AND d.registrant_city = 'ANDERSON'
  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 = 'IN' AND d.registrant_city = 'ANDERSON'
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.

N3975LCessna 172G · S/N 17254144Cancelled Mar 17, 2025 · Exported to Chile · Built 1966 · Indy Air Sales LLC N33522Piper PA-28-140 · S/N 28-7525202Cancelled Feb 13, 2025 · Exported to Canada · Built 1975 · Indy Air Sales LLC N8631UCessna 172F · S/N 17252532Cancelled Mar 2, 2024 · Registration pending, canceled · Built 1965 N7397DPiper PA-18-150 · S/N 18-5773Cancelled Nov 14, 2023 · Exported to Paraguay · Indy Air Sales LLC N4442RCollis Paul L OSPREY II · S/N 1Cancelled Jun 14, 2022 · Registration expired, pending cancellation · Built 1984 · Collis Paul L N3818ADestiny 2000 PP · S/N 1B0022Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Anderson James S N2897KLuscombe 8A · S/N 5624Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1947 · Day Corwin R N100BTBeech 95-C55 · S/N TE-46Cancelled Aug 23, 2019 · Exported to Philippines · Built 1966 · Indy Air Sales LLC N9583WPiper PA-28-140 · S/N 28-23029Cancelled Jul 3, 2019 · Exported to Guatemala · Built 1967 · Indy Air Sales LLC N8052BBerry Hugh E GTX 2000 · S/N 1Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Built 2004 · Berry Hugh E N939MMGrumman OV-1D · S/N 68-15939Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Mc Clain Museum Inc% J Mc Clain N53MCCarpenter SCORPION II · S/N 1717MCCancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1978 · Mcclain Museum Inc N7145ACessna 172 · S/N 29245Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1956 · Air Buoyant LLC N2008AAvian Balloons TURBO 8 · S/N 194Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Hot Air Coups Inc N47119Fairchild M-62A · S/N T435403Cancelled Nov 18, 2017 · Revoked, canceled · Built 1943 · Anderson Charter And Flying Svc N75AVAvian Balloon MAGNUM IX · S/N 75Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1982 · Hot Air Corps Inc N987TCThunder & Colt Balloons 77 SERIES I · S/N 1463USCancelled Sep 26, 2017 · Registration expired, pending cancellation · Hot Air Corps Inc N90217Vaught Phillip PV-1 · S/N 1Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Vaught Phillip W N55438Piper PA-28R-200 · S/N 28R-7335234Cancelled Nov 3, 2015 · Exported to Canada · Built 1973 · Indy Air Sales LLC N2992YCessna 182E · S/N 18253992Cancelled May 13, 2015 · Sale reported, canceled · Built 1962 N57AVAvian Balloon SKYHAWK · S/N 57Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1980 · Hunt Dawn W N127RDDonnelly Richard L ZEPHYR · S/N HAC-001Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1994 · Donnelly Richard L N2433Rohdecap T-18 · S/N 547Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1970 · Huston Loren E N7VPSowers VOLKSPLANE VP-2 · S/N V2-1506Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1975 N757XQCessna 152 · S/N 15280089Cancelled Aug 9, 2013 · Exported to Pakistan · Built 1977 N39AVAvian Balloon SKYHAWK · S/N 39Cancelled Jul 26, 2013 · Third renewal notice · Built 1979 · Hot Air Corps Inc N74AVAvian Balloon SKYHAWK · S/N 74Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1982 · Hot Air Corps Inc N73AVAvian Balloon SKYHAWK · S/N 73Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Hot Air Corps Inc N72GGresley GR-1 · S/N 001Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1972 · Gresley Ross A N6842BPiper PA-22-150 · S/N 22-4141Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1956 N67608Cessna 152 · S/N 15281943Cancelled Dec 28, 2012 · Exported to Indonesia · Built 1978 · Indy Air Sales LLC N48261Taylorcraft DCO-65 · S/N L-4826Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1943 · Crandall Wayne A N4628SJodel D-11 · S/N D-1Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1977 · Wright James F N68208Cessna 152 · S/N 15282186Cancelled Nov 14, 2012 · Exported to Pakistan · Built 1978 N89699Cessna 152 · S/N 15282829Cancelled Oct 2, 2012 · Exported to Mexico · Built 1978 · Indy Air Sales LLC N25405Cessna 152 · S/N 15280634Cancelled Oct 1, 2012 · Exported to Mexico · Built 1977 · Indy Air Sales LLC N25012Semco Balloon T · S/N SEM73Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Built 1972 · Harney Michael L N91FNorth American NAVION · S/N NAV4-204Cancelled Sep 10, 2012 · Revoked, canceled · Built 1947 · Baxter Robert W N2813Stits Playmate SA-11A · S/N 84Cancelled Aug 27, 2012 · Sale reported, canceled · Built 1969 N6172NPegg R/Makowski C PM100 · S/N 001Cancelled Aug 21, 2012 · Registration pending, canceled · Built 1992 N36AVAvian Balloon SKYHAWK · S/N 36Cancelled Aug 8, 2012 · Registration pending, canceled · Built 1979 N14431Semco Balloon T · S/N SEM-66Cancelled Jul 6, 2012 · Registration expired, pending cancellation · Built 1972 · Gammon Ginna G N68AVAvian Balloon SKYHAWK · S/N 68Cancelled Mar 7, 2012 · Triennial form not returned · Built 1981 · Haynes Donald E N7407QCessna 182P · S/N 18261047Cancelled Nov 29, 2011 · Exported to Canada · Built 1972 N72486Thomas Mark W GTX-2000 · S/N H2-94-5-119Cancelled Jul 6, 2011 · Registration pending, pending cancellation N9248EPiper PA-28-236 · S/N 2811048Cancelled Apr 11, 2011 · Exported to Australia · Built 1994 · Mccurdy Robert W N212RSSmith Ronald D VARIVIGGEN · S/N 222Cancelled Apr 5, 2010 · Triennial form not returned · Built 1989 · Smith Ronald D N32298Frazier William P FRAZIER PAR · S/N J229359J22Cancelled Mar 12, 2007 · Triennial form not returned · Built 1995 · Frazier William P N55448Beech A36 · S/N E-2548Cancelled Jul 19, 2005 · Built 1990 · Astro Enterprises Inc N5742FPiper PA-28-140 · S/N 28-25044Cancelled Apr 9, 2003 · Triennial form not returned · Built 1968 · Schlensker Gerald H

Back to Anderson, IN