Skip to content

Winston Salem, NC

Cancelled registrations · 135

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 = 'NC' AND d.registrant_city = 'WINSTON SALEM' 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 = 'NC' AND d.registrant_city = 'WINSTON SALEM'
  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 = 'NC' AND d.registrant_city = 'WINSTON SALEM'
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.

N9313SBeech C23 · S/N M-1648Cancelled Nov 9, 2024 · Sale reported, canceled · Built 1975 N989BKCharles Heatherly BUCKEYE DREAM MACHIN · S/N 5102Cancelled Jul 20, 2024 · Sale reported, canceled N1451UCessna 172M · S/N 17267118Cancelled Oct 28, 2023 · Built 1976 · Piedmont Flight Inc N194MAmerican Aeronautical MARCHETTI S-56-B · S/N 7Cancelled Apr 18, 2023 · Sale reported, canceled · Built 1930 N50JHGolden Circle Air T-BIRD TANDEM TBT-06 · S/N 03Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Gammons Chris D N13177Piper E-2 · S/N 58Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1933 · Pierce Nicholas N4490KRyan NAVION · S/N NAV-4-1490Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Tatum William P N8144FCirrus Design SR22 · S/N 0682Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Wiltz Sales LLC N697EHDJI PHANTOM 3 ADVANCED · S/N P79DCH12021035Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Truelook Inc N2034TFirefly Balloons FIREFLY 8B-15 · S/N F8B-2097Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 2006 · Adventures Aloft Of Nc N739NVDJI INSPIRE 1 · S/N W13OCF19040488Cancelled Jan 17, 2020 · Sale reported, canceled N7766SDJI PHANTOM 3 PROFESSION · S/N P76DCK03A26011Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Charlotte Aerial Solutions LLC N78206Globe GC-1B · S/N 2206Cancelled Oct 1, 2018 · Revoked, canceled · Built 1946 · Cheshire M H Md N4446HPiper PA-15 · S/N 15-235Cancelled Jul 19, 2018 · Revoked, canceled · Built 1948 · Stoner Robert C N1460Whitteds Whirlybird 2 · S/N HEW-2Cancelled Mar 23, 2018 · Revoked, canceled · Whitted Hugh Edwin III N419ECKoriakin Arnold S JUST ACFT HIGHLANDER · S/N JA183-01-09Cancelled Jan 12, 2018 · Exported to New Zealand · Built 2010 · Koriakin Arnold S N1058ARodriguez Ismael SCORPION · S/N 13379Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1979 · Cromer Ernest L N9899JCessna 172N · S/N 17273954Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1980 · Piedmont Baptist College N535BBeech A35 · S/N D-1551Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1948 · Print Purchasing Consultants Inc N9082WPiper PA-28-235 · S/N 28-10684Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Built 1965 · Gordon David A N428GGAdams Grady W ZENAIR CH701 · S/N 5651Cancelled May 14, 2015 · Registration expired, pending cancellation · Adams Grady W N1906Short Bros. & Harland SC7 SERIES 3 · S/N SH1906Cancelled Jan 2, 2015 · Exported to Poland · Built 1972 · Larsen Caesar S N912CKRobinson Helicopter R44 II · S/N 11458Cancelled Dec 4, 2014 · Exported to China · Built 2006 · Dan-Dan Bee LLC N8774NPiper PA-28-140 · S/N 28-25598Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1969 · Joyce William David N360THBolinger Tony L LANCAIR 320 · S/N 469-236FBCancelled Jan 27, 2014 · Built 1991 · Blackwell Curtis H N7985ZCessna 150C · S/N 15060085Cancelled Oct 30, 2013 · Registration pending, pending cancellation · Built 1963 N2641JCessna 150G · S/N 15065641Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1966 · C 150 Group Inc N193HBeech S35 · S/N D-7444Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1964 · Salem Flyers Inc N2371FStinson HW75 · S/N 7196Cancelled Aug 7, 2013 · Sale reported, canceled N2743WMooney M20C · S/N 3345Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1966 · Aerodream Inc N2108XCessna 337 · S/N 337-0008Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1965 · Dixon W B III N9749WPiper PA-28-140 · S/N 28-23232Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1967 · Stanley Leroy III N219PABoeing 737-222 · S/N 19956Cancelled May 16, 2013 · Registration expired, pending cancellation · Built 1969 · Pace Airlines Inc N7942NPiper PA-28-180 · S/N 28-5357Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1969 · Nance Roger F N31953Piper PA-32-260 · S/N 32-7800008Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1978 · Tarheel Railroad Construction Co Inc N7050BPiper PA-22-150 · S/N 22-4304Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1956 N66205Cessna 150M · S/N 15075918Cancelled Feb 12, 2013 · Third renewal notice · Built 1974 · Symmes F Houston Jr N49037Cessna 152 · S/N 15281113Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1977 · Lend-A-Wing Inc N4678GCessna 172N · S/N 17273304Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Piedmont Bible College N4438PPiper PA-23-160 · S/N 23-1955Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1960 · Vineyard Lowell P N5925ZPiper PA-22-108 · S/N 22-9794Cancelled Aug 30, 2012 · Revoked, canceled · Built 1964 · Whitted Hugh Edwin III N266CAEmbraer EMB-120RT · S/N 120.258Cancelled Aug 21, 2012 · Registration pending, canceled · Built 1991 N1255FBalloon Works FIREFLY 7 · S/N 156Cancelled Jul 30, 2012 · Registration expired, pending cancellation · Built 1974 · Davis Marion J Jr N758GHawker Beechcraft G58 · S/N TH-2198Cancelled Jun 19, 2012 · Exported to Brazil · Built 2007 · Piedmont Aircraft Co LLC N456GSCessna 182S · S/N 18280048Cancelled Mar 14, 2011 · Exported to Panama · Liberty Flyers Inc N272PRaytheon A36 · S/N E-3626Cancelled May 22, 2008 · Exported to Brazil · Corporate Jets Inc DBA N282JDRaytheon B200 · S/N BB-1779Cancelled Apr 8, 2008 · Exported to Brazil · Built 2001 · Corporate Jets Inc DBA N66CLRaytheon 58 · S/N TH-1893Cancelled Feb 1, 2008 · Exported to Brazil · Built 1999 · Corporate Jets Inc DBA N588JPDiamond Aircraft Ind DA 40 · S/N 40.288Cancelled Jan 15, 2008 · Exported to Canada · Built 2003 · Barons Capital LLC N94CKLearjet 45 · S/N 066Cancelled Jan 8, 2008 · Exported to Angola · Built 2000 · Corporate Jets Inc DBA

Back to Winston Salem, NC