OpenAirDocs.org
Charleston, SC

Cancelled registrations · 136

Query with SQL
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.

N6454DBeech T-34A · S/N 52-8277Cancelled Aug 16, 1962 · United States Air ForceN5293NRepublic F-47 · S/N 39955640Cancelled Nov 10, 1959 · Hawthorne Flying ServiceN73024Cessna 140 · S/N 10229Cancelled Mar 16, 1956 · Hawthorne Flying ServiceN14135Waco YKC-S · S/N 4502Cancelled Oct 19, 1955 · Kenai Airways IncN36908Aeronca 65-CA · S/N CA18041Cancelled Oct 10, 1955 · Built 1941 · Lemacks Thomas H JrN60793North American SNJ-2 · S/N 2033Cancelled Sep 20, 1954 · Exported to Peru · Hawthorne Flying ServiceN99DNorth American SNJ-2 · S/N 2012Cancelled Sep 17, 1954 · Hawthorne Flying ServiceN55272North American BC1A · S/N 55-1604Cancelled Jul 19, 1954 · Exported to Peru · Hawthorne Flying ServiceN75140North American BC1A · S/N 79-3998Cancelled Jul 19, 1954 · Exported to Peru · Hawthorne Flying ServiceN5210NNorth American P-51D · S/N 12231558Cancelled May 13, 1954 · Hawthorne Flying Service Usaf Of The Ntl DefN5289NRepublic F-47 · S/N 37955166Cancelled May 7, 1953 · Usaf Of The National DefenseN5290NRepublic F-47 · S/N 31953829Cancelled May 7, 1953 · Hawthorne Flying ServiceN5291NRepublic F-47 · S/N 23965819Cancelled May 7, 1953 · Hawthorne Flying ServiceN6169HPiper J3C-65 · S/N 19337Cancelled May 20, 1952 · Lawerence C TN52031North American SNJ-4 · S/N 88-12036Cancelled Apr 25, 1952 · Hawthorne Flying ServiceN78254Globe GC-1B · S/N 2254Cancelled Jan 2, 1952 · T E CoppedgeN21870Piper J4A · S/N 4-411Cancelled Nov 5, 1951 · Built 1938 · Farrow Thomas FN4ENorth American P-51D-20-NA · S/N 12238872Cancelled Aug 9, 1951 · Built 1933 · Hawthorne Flying ServiceN46683Aeronca 0-58B · S/N 3822Cancelled Aug 16, 1950 · Williams Richard GN3919BNorth American F-51D · S/N 122-31570Cancelled Jan 4, 1950 · Hawthorne Flying ServiceN3915BNorth American F-51D · S/N 12231548Cancelled Dec 22, 1949 · Hawthorne Flying ServiceN3916BNorth American F-51D · S/N 122-31550Cancelled Dec 22, 1949 · Hawthorne Flying ServiceN3917BNorth American F-51D · S/N 122-31555Cancelled Dec 22, 1949 · Hawthorne Flying ServiceN3918BNorth American F-51D · S/N 12231579Cancelled Dec 22, 1949 · Hawthorne Flying ServiceN52641Fairchild M-62A · S/N T42-1771Cancelled Dec 2, 1948 · M F Truluck DBA Trulucks Flying ServiceN182KMonocoupe 90 · S/N 516Cancelled Feb 2, 1948 · Bell J PN11428Waco QDC · S/N 3498Cancelled Apr 6, 1943 · Built 1931 · Hawthorne Flying ServiceN968HMoth 60-GM · S/N 68Cancelled Jun 15, 1941 · Built 1928 · Mood Lawrence AgustusN483Doyle 0-2 · S/N A-2Cancelled Nov 1, 1940 · Louis Harrelson WindsteadN5570American Eagle A-1 · S/N 193Cancelled Dec 9, 1939 · Built 1928 · Hawthorne Flying ServiceN978Pitcairn PA-3 OROWING · S/N 30Cancelled Sep 3, 1939 · W W NorthN5044Waco GXE · S/N 1342Cancelled Aug 1, 1939 · Built 1918 · Hawthorne Flying Service IncN1699Swallow SWALLOW · S/N 865Cancelled Jan 28, 1933 · Built 1927 · Wehman Ernest AN162WPiper PA-25 · S/N 25-423Cancellation date not recorded · Thomas L ReevesN55740Cessna T-50 · S/N 3861Cancellation date not recorded · Built 1943 · J P BellN66235Cessna T-50 · S/N 4438Cancellation date not recorded · Bell J P
Back to Charleston, SC