Skip to content

Summerville, SC

Cancelled registrations · 33

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 = 'SC' AND d.registrant_city = 'SUMMERVILLE' 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 = 'SC' AND d.registrant_city = 'SUMMERVILLE'
  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 = 'SC' AND d.registrant_city = 'SUMMERVILLE'
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.

N41441Reber 1932 SKY SCOUT · S/N R1-2Cancelled May 5, 2026 · Exported to Canada · Built 2004 · Wehman Ernest A Jr N90SWPiper AEROSTAR 601P · S/N 61P-0518-216Cancelled Jun 9, 2025 · Yarborough William N75472Smith Kimmey W KOLB MARK 3 CLASSIC · S/N 000200501Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 2005 · Smith Kimmey W N31CLLimehouse Cary J BD-5B · S/N 1280Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 2004 · Limehouse Cary J N139PBMcgarity Andrew B RV-8 · S/N 81802Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 2007 · Mcgarity Andrew B N770AHKolb TWINSTAR · S/N 777Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1988 · Henson Al N4220UCessna 150D · S/N 15060220Cancelled May 20, 2015 · Registration pending, canceled · Built 1963 N6532SCessna 150H · S/N 15067332Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1967 · Holmes Ruth N25809Piper J3C-65 · S/N 3761Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1939 · Mccown Charles A N100ECBeech E-90 · S/N LW-150Cancelled Feb 3, 2014 · Third renewal notice · Built 1975 · Sunburst Aviation LLC N924PDDimodica Philip J ROTORWAY EXEC · S/N 3124Cancelled Aug 21, 2013 · Sale reported, canceled N555GAAmos Gary L LONG-EZ · S/N 1510Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Hensel Edward N9419FHughes 269B · S/N 65-0206Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1965 · Shelton John N N5803DPiper PA-22-150 · S/N 22-4478Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1956 · Drenning Roger H N8101VSabine John B MAXAIR DRIFTER · S/N 001Cancelled Oct 15, 2012 · Registration expired, pending cancellation · Built 2005 · Sabine John B N533REOlson R S/Olson E B SONEX · S/N 533Cancelled Jul 19, 2012 · Sale reported, canceled N2367LBeech 23 · S/N M-203Cancelled May 18, 2011 · Exported to Russia · Built 1963 · Stovall Marlin T N9974Lithuanian Factory Of LAK-12 · S/N 6203Cancelled Sep 14, 2010 · Exported to Argentina · Stein Bruce A N1817HCessna 310C · S/N 35917Cancelled Dec 19, 2005 · Triennial form not returned · Built 1959 · Azalea Utilities Inc N6599BCessna 152 · S/N 15283958Cancelled Nov 21, 2005 · Triennial form not returned · Built 1979 · Pelican Aviation Inc N803BWWente Robert O KITFOX III · S/N 803Cancelled Nov 1, 2005 · Triennial form not returned · Built 1992 · Wente Robert O N3835PPiper PA-22-150 · S/N 22-3525Cancelled Nov 18, 2002 · Triennial form not returned · Built 1955 · Freitag Donald W N3620ZPiper PA-22-160 · S/N 227511Cancelled Mar 13, 1997 · Triennial form not returned · Fralick Bobby D N7009ACessna 172 · S/N 29109Cancelled May 31, 1995 · Triennial form not returned · Mccoy Brian E N4055GBell 47G-3B-2 · S/N 6682Cancelled Apr 24, 1995 · Triennial form not returned · Mccranie George Lee N9750DPiper PA-22S-150 · S/N 226663Cancelled Mar 22, 1995 · Triennial form not returned · Rogers George W N5234ZPiper PA-22-108 · S/N 228914Cancelled May 4, 1993 · Exported to United Kingdom · Freitag Donald W N757ACCessna 152 · S/N 15279577Cancelled Apr 26, 1993 · Brown Enterprises Of Summerville DBA N7339JPiper PA-28-140 · S/N 2824694Cancelled Nov 22, 1991 · Faw Michael DBA N30048Cessna 172M · S/N 17264121Cancelled Sep 9, 1977 · Exported to Canada · Built 1974 · Summerville Aviation Inc N3486Lockheed 12A · S/N 1245Cancelled Sep 8, 1976 · Built 1937 · Red Eye Express Inc N4031MPiper PA-12 · S/N 12-2916Cancelled Nov 22, 1974 · Shelton John N N47LMong Sport BROWN SPECIAL · S/N 1Cancelled Dec 6, 1965 · J E Locklair Jr

Back to Summerville, SC