Skip to content

Cancelled registrations · 29

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

N42957Awad Ronald Edward AWARD DOMINATOR · S/N 001Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 2004 · Bendel James H N51LMMansuetti PITTS SPECIAL S-1 · S/N 149-HCancelled Jun 5, 2021 · Registration expired, pending cancellation · Mansuetti Leo Jr N22781Piper J4B · S/N 4468Cancelled Sep 18, 2020 · Revoked, canceled · Built 1939 · Fosdick James C Jr N103JBBendel James H B8M · S/N 002Cancelled Feb 7, 2019 · Registration expired, pending cancellation · Built 2008 · Bendel James H N1544PPiper PA-22-135 · S/N 22-2407Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Smith Charles R Jr N1400WBell 47G-4A · S/N 7657Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1969 · Morris Marshall Jr N7926QCessna 401B · S/N 401B0026Cancelled Feb 4, 2017 · Revoked, canceled · Built 1970 · Lee Robert E N6569DBeech C18S · S/N 66440Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1945 · Peeples John R Jr N3752PPeer Michael J BENSEN B-8M · S/N 340461724Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1980 · Peer Michael J N7934TCessna 175A · S/N 56634Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1960 · Evans Murray L N7131DBeech 60 · S/N P-55Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1969 N51819Lynch Arthur A AVID FLYER C SPEEDWG · S/N 767Cancelled Aug 22, 2012 · Registration pending, canceled N1907XCessna 182H · S/N 18256007Cancelled Aug 20, 2012 · Registration expired, pending cancellation · Built 1965 · Fred Cole Air Service Inc N3FBRaytheon 58 · S/N TH-1868Cancelled Feb 2, 2007 · Exported to Australia · Built 1998 · Richardson Street Partners LLC N2269EBrown Tim CHALLENGER II · S/N CH2-0793-0997Cancelled Aug 21, 2000 · Gochnauer James N5638GCessna A188B · S/N 18801127TCancelled Jun 9, 1997 · Exported to Argentina · Sumter Aero Applicators Inc N130CTPiper PA-28-161 · S/N 288016211Cancelled Apr 9, 1992 · Exported to United Kingdom · Rogers Howard W N51076Richardson Roland L MUSTANG P51A · S/N 745Cancelled Jan 9, 1992 · Triennial form not returned · Richardson Roland L N129FCCrump STOLP STARLET SA-500 · S/N 129Cancelled Feb 7, 1991 · Triennial form not returned · Ream Clyde W N15197Piper PA-28R-200 · S/N 28R-7335035Cancelled Nov 11, 1982 · Administratively canceled · Sumter Airways Inc N7008GCessna 150L · S/N 150-74602Cancelled Feb 26, 1981 · Sumter Airways Inc N1336MBoeing N2S-5 · S/N 75-8114Cancelled Aug 5, 1970 · Sumter Airways Inc N7197WPiper PA-28-180 · S/N 28-1008Cancelled Feb 6, 1968 · Weinberg Perry M N1275HAeronca 15AC · S/N 15AC-291Cancelled Apr 21, 1967 · Exported to Canada · James Cuttino Jr & Ralph W Strong N94120Ercoupe 415-C · S/N 1443Cancelled Jan 7, 1957 · Built 1946 · Amato Michael A N989APiper PA-22 · S/N 22-307Cancelled Nov 30, 1954 · Nettles O B N37840Culver LCA · S/N 344Cancelled Jul 22, 1953 · Parmelee James W N3265NPiper J3C-65 · S/N 22456Cancelled Aug 6, 1952 · Built 1946 · Sumter Aero Dusters Inc N80651Globe GC-1B · S/N 1056Cancelled Nov 26, 1951 · Built 1946 · Monaghan J D

Back to Sumter, SC