Skip to content

Cancelled registrations · 136

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

N712LADiamond Aircraft Ind DA 40 NG · S/N 40.NC128Cancelled Aug 31, 2024 · Built 2021 · Bach Flight LLC N6362MCessna 152 · S/N 15284694Cancelled Aug 10, 2024 · Sale reported, canceled · Built 1980 N65615Cessna 172P · S/N 17275786Cancelled Sep 27, 2023 · Built 1982 · Zim Sim LLC N34144Cessna 177RG · S/N 177RG0973Cancelled May 27, 2023 · Revoked, canceled · Built 1976 · Demets Lee N2521ACessna 177B · S/N 17702634Cancelled Sep 9, 2022 · Sale reported, canceled · Built 1977 N9689VCessna 172M · S/N 17264468Cancelled Feb 1, 2021 · Exported to Ghana · Built 1974 · Hanger Aviation Inc N821TRRoebuck David L RANS S6ES COYOTE II · S/N 02031482 ESCancelled May 28, 2020 · Built 2008 · Yaitsky Alexander Nikolaevich N59PRRaytheon 58 · S/N TH-1940Cancelled Dec 20, 2019 · Registration pending, canceled · Built 2000 N656TPDJI PHANTOM 3 PROFESSION · S/N P76DCG16016346Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Stabilvista LLC N2186EAeronca 7AC · S/N 7AC5760Cancelled Oct 25, 2019 · Revoked, canceled · Built 1946 · Volunteer Rescue League N46856Fairchild M-62A · S/N T437065Cancelled Jan 29, 2019 · Revoked, canceled · Built 1943 · Anders O A N1799DCessna 170B · S/N 20241Cancelled Apr 2, 2018 · Revoked, canceled · Built 1951 · Brunk John R N9422DPiper PA-22-160 · S/N 22-6396Cancelled Mar 23, 2018 · Revoked, canceled · Built 1958 · Furr Ephriam A N23766Piper PA-38-112 · S/N 38-79A1050Cancelled Mar 22, 2018 · Registration expired, pending cancellation · Bulldog Airways Inc N9142DMooney M20J · S/N 24-3287Cancelled Mar 16, 2018 · Exported to Canada · Built 1993 · Hanger Aviation Inc N6941WPiper PA-28-140 · S/N 28-21167Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1965 · Pitner Russell B N4048PPiper PA-23-160 · S/N 23-1525Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1958 · Fuller Stephen N30DYStephens Mark C CRINGELY WONDER · S/N 001Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1997 · Stephens Mark C N29475Aeronca 60-TF · S/N L4480TCancelled Nov 22, 2017 · Revoked, canceled · Built 1940 · Pinckney Warren O N4669GCessna 172N · S/N 17273295Cancelled Aug 22, 2017 · Exported to Argentina · Hanger Aviation Inc N401HCessna 401B · S/N 401B-0027Cancelled Jul 5, 2017 · Exported to Morocco · Geocad LLC N582DAAusmus Donald L KITFOX II · S/N 497Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Mccoy Timothy D N7585YPiper PA-30 · S/N 30-652Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Thompson C O N268GSBeechcraft C90GTI · S/N LJ-2123Cancelled May 24, 2016 · Exported to Australia · Built 2015 · Srs Aviation LLC N734WVCessna 172N · S/N 17269181Cancelled Jan 7, 2016 · Exported to Paraguay · Built 1977 · Hanger Aviation Inc N66241Cessna 150M · S/N 15075945Cancelled Nov 3, 2014 · Built 1974 · Hanger Aviation Inc N1815KLuscombe 8E · S/N 4542Cancelled Sep 3, 2014 · Sale reported, canceled · Built 1946 N41581Piper PA-34-200 · S/N 34-7450137Cancelled Jul 23, 2014 · Exported to Brazil · Built 1974 · Hanger Aviation Inc N9444NPiper PA-28R-200 · S/N 28R-35158Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1969 · Hopkins Harold E Jr N9311BCessna 175 · S/N 55111Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1958 · Lucas Charles W N485TBeech D50C · S/N DH-300Cancelled Jun 13, 2013 · Sale reported, canceled · Built 1961 N3JRCessna 172N · S/N 17273584Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1979 · Schultz Martin L N7230RBeech 58 · S/N TH-555Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1974 · Cantrell Paul W Jr N37998Lockheed T-33A · S/N 58-0539Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Trident Technical College N4568Cessna 310A · S/N 38138Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Built 1958 · Trident Technical College N444MCCessna 421 · S/N 421-0083Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1968 N2540WBeech B24R · S/N MC-220Cancelled Sep 12, 2012 · Registration expired, pending cancellation · Built 1974 · Bradley Francis C N26146Hughes DAVIS DA-2C · S/N 255Cancelled Aug 30, 2012 · Registration pending, canceled · Built 1982 N4408PPiper PA-23-160 · S/N 23-1920Cancelled Jun 27, 2012 · Revoked, canceled · Built 1960 · Walker James R N43251Taylorcraft BC12-D · S/N 6910Cancelled Jun 21, 2012 · Revoked, canceled · Built 1946 · Haskell Karl L N7514JBell OH-58C · S/N 71-20762Cancelled Mar 15, 2012 · Registration pending, pending cancellation N183DCessna 182G · S/N 18255523Cancelled May 4, 2011 · Exported to Tanzania · Built 1964 · Hanger Aviation Inc N1340GCessna 340A · S/N 340A0665Cancelled Apr 20, 2010 · Exported to Mexico · Built 1979 · Rick Hegenberger And Associates N14295Piper PA-23-250 · S/N 27-4856Cancelled Nov 26, 2008 · Exported to Dominican Republic · Built 1972 · Hanger Aviation Inc N7654YPiper PA-30 · S/N 30-732Cancelled Nov 17, 2005 · Built 1965 · G J Air LLC N63909Beech 58 · S/N TH-1366Cancelled Mar 26, 2004 · Exported to South Africa · Built 1983 · Rhodes C Anthony N6093DCessna 172N · S/N 17272600Cancelled Jul 15, 2003 · Triennial form not returned · Built 1979 · Murphy Richard A N758CLCessna R172K · S/N R1722988Cancelled May 4, 2001 · Exported to Canada · Hanger Aviation Inc N1982QCessna 177RG · S/N 177RG0382Cancelled Feb 26, 2001 · Triennial form not returned · Brown Jacob Ralph N461FLPiper PA-28-140 · S/N 28-7125259Cancelled Jan 21, 2000 · Triennial form not returned · Brown Ralph

Back to Charleston, SC