Skip to content

Cancelled registrations · 80

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

N1777SCompagnie Daher TBM 700 · S/N 1243Cancelled Nov 9, 2023 · Exported to Canada · Built 2018 · Muncie Aviation Co N710NBDJI PHANTOM 3 PROFESSION · S/N P76DCG1016032Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Ball State University N575MAPiper PA46-500TP · S/N 4697674Cancelled Jun 22, 2021 · Exported to Brazil · Muncie Aviation Co N22658Cessna 150H · S/N 15068432Cancelled Jun 5, 2021 · Sale reported, canceled · Built 1968 N600EUPiper PA-46-600TP · S/N 4698033Cancelled Jan 25, 2021 · Exported to San Marino · Built 2017 · Muncie Aviation Co N52355Aeronca 0-58B · S/N O58B6672Cancelled Jan 17, 2020 · Revoked, canceled · Built 1942 · Zeigler Robert K N477PAPipistrel Lsa S R L ALPHA TRAINER · S/N 453 AT 912 LSACancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 2012 · Wisdom Aviation LLC N624FMapes 624F · S/N HJM1Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 2007 · Mapes Harry J N4758XCessna 150G · S/N 15064808Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1966 · Carroll Calvin DBA N11VJCessna 337B · S/N 337-0532Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1966 · Mclaughlin Jeffrey T N56AVAvian Balloon FALCON II · S/N 56Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1980 · Keller Katrina A N599MAPiper PA 46-350P · S/N 4636634Cancelled Apr 8, 2015 · Exported to Russia · Built 2014 · Muncie Aviation Co N29701Expl Acft ASS Wlgtn Chpt 297 BREEZY · S/N EAA-297-1Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1974 · Bienkowski Joseph V N66CCPiper PA-44-180T · S/N 448107042Cancelled Nov 26, 2013 · Exported to Canada · Built 1981 · Muncie Aviation Co N6100SAir & Space America 18A · S/N 18-6Cancelled Jul 16, 2013 · Revoked, canceled · Built 1964 · Air & Space Mfg Inc N9183DPiper PA-22-160 · S/N 22-6231Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1958 N8355KUniversal Stinson 108-1 · S/N 108-1355Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1946 N104UUmbaugh 18 · S/N 3FCancelled Sep 18, 2012 · Revoked, canceled · Built 1960 · Air & Space Mfg Inc N19946Cessna 172M · S/N 17260876Cancelled Feb 22, 2011 · Exported to Argentina · Built 1972 · Burgewood Corp N226PBSocata TBM 700 · S/N 226Cancelled Jun 16, 2010 · Exported to Australia · Built 2002 · Muncie Aviation Co N3096Starduster Too SA-300 · S/N 1Cancelled Oct 19, 2009 · Registration revoked · Built 1971 · Paul Donald E N5622NWood Donovan Glen WOOD · S/N 3Cancelled Sep 15, 2009 · Registration revoked · Built 1949 · Wood Donovan Glen N6486HAerostar International RX-7 · S/N RX7-3102Cancelled Jul 8, 2008 · Triennial form not returned · Built 1987 · Hartig David A N809ERDiamond Aircraft Ind DA 40 · S/N 40.321Cancelled Jul 24, 2007 · Exported to Germany · Built 2003 · Burgewood Corp N721MASocata TB21 · S/N 2199Cancelled Dec 1, 2005 · Exported to Poland · Built 2003 N1918QSocata TB-20 TRINIDAD · S/N 1918Cancelled Mar 30, 2004 · Exported to Canada · Built 1999 · Muncie Aviation Co N2391JCessna 172S · S/N 172S8125Cancelled Oct 17, 2002 · Exported to United Kingdom · Built 1999 · Burgewood Corp N1542DBalloon Works FIREFLY 7 · S/N 10287Cancelled Nov 27, 2001 · Triennial form not returned · Built 1980 · Demaree Barbara K N77880Devsen Gail Van TITAN TWO · S/N D95618SOHK0150Cancelled Sep 11, 2000 · Van Deusen Gail R N9221GPiper PA-32R-301 · S/N 3213049Cancelled May 16, 1995 · Exported to France · Minnetrista Corp N7725DPiper PA-22-150 · S/N 225399Cancelled Apr 27, 1993 · Triennial form not returned · Jones Buddie L Sr N559PAPiper PA-28R-200 · S/N 28R-7235259Cancelled Dec 9, 1982 · Snoopy Flyers Inc N2085YPiper PA-28RT-201T · S/N 28R-7931144Cancelled Sep 28, 1979 · Exported to Canada · Aircraft Distributors Of Muncie Inc N8379CPiper PA-28-151 · S/N 28-7615098Cancelled Jul 18, 1979 · Exported to Australia · Built 1976 · Minnetrista Corp N57566Piper PA-31P · S/N 31P-7730007Cancelled Jun 29, 1979 · Exported to Honduras · Minnertrista Corp N27741Piper PA-31-350 · S/N 31-7852136Cancelled Sep 7, 1978 · Exported to United Kingdom · Aircraft Distributors Of Muncie Inc N56004Piper PA-28-180 · S/N 28-7305501Cancelled Feb 13, 1976 · Delaware Cherokees Inc N481PPiper PA-28-235 · S/N 28-10705Cancelled Oct 29, 1975 · Wanderlust Inc N6133SAir & Space America 18A · S/N 18-40Cancelled Jun 5, 1975 · Air & Space Manufacturing N9191YPiper PA-31-310 · S/N 31-256Cancelled Nov 14, 1974 · Exported to Canada · Muncie Aviation Co N5889UPiper PA-28-140 · S/N 28-26779Cancelled Oct 8, 1974 · Exported to Canada · Muncie Aviation Co N52MCPiper PA-31P · S/N 31P76Cancelled Jun 26, 1974 · Exported to Canada · Muncie Aviation Corp N40940Piper PA-28-140 · S/N 28-7425192Cancelled Apr 26, 1974 · Built 1973 · Muncie Aviation Corp N44RDPiper PA-23-250 · S/N 27-4669Cancelled Oct 25, 1973 · Exported to Canada · Built 1971 · Muncie Avn Corp N5122PPiper PA-24 · S/N 24-135Cancelled Apr 23, 1971 · Ryder John W N12060Bensen B-8MAJ · S/N 8835Cancelled Mar 10, 1971 · Jordan Bruce W N5021PPiper PA-24 · S/N 24-24Cancelled Jan 25, 1971 · Muncie Flying Club Inc N24088Taylorcraft BC-65 · S/N 1623Cancelled Dec 31, 1970 · John Westlake N44299Taylorcraft BC12-D · S/N 10099Cancelled Nov 24, 1970 · Rogers John W N28164Piper J3F-60 · S/N 4626Cancelled Sep 10, 1970 · Harold Clevenger

Back to Muncie, IN