OpenAirDocs.org
Columbia, SC

Cancelled registrations · 148

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

N7031Mann B-8M · S/N 01Cancelled May 4, 1973 · Meetze Gerald AN2915WBell 206B · S/N 734Cancelled Jan 3, 1973 · Exported to Sweden · Jeff Hunt Machinery CoN4755GNoyes-Chandler BENSEN B-8M · S/N HL-1Cancelled Apr 4, 1972 · Simmons David DN9734YBeech P35 · S/N D-7130Cancelled Sep 28, 1971 · Built 1963 · Capital Aerial Club CorpN8458CAero Commander 680-E · S/N 680E-796-54Cancelled Sep 24, 1971 · Boineau Realty CoN46954Aeronca 0-58B · S/N 058B-2912Cancelled Jan 4, 1971 · Sand Hills Aero Club IncN880HBeech 65-88 · S/N LP-3Cancelled Sep 8, 1970 · Exported to Mexico · Midlands Aviation CorpN3045CBeech 95-C55 · S/N TE-451Cancelled Aug 19, 1970 · Aroneck Sanford NN4869HPiper PA-17 · S/N 17-169Cancelled Jul 28, 1970 · Glenn SeibertN9630DPiper PA-22-160 · S/N 22-6543Cancelled Feb 11, 1969 · Built 1959 · Midlands Aviation CorpN80559Globe GC-1A · S/N 62Cancelled Jul 12, 1965 · Wilson Thomas H &/Or George B JohnsonN2149DBeech D35 · S/N D-3497Cancelled Aug 23, 1960 · Investments Unlimited IncN84882Aeronca 7AC · S/N 7AC-3601Cancelled Jan 6, 1960 · Aircraft Sales & ServiceN8934DPiper PA-22-160 · S/N 22-6092Cancelled Nov 12, 1959 · Southeastern Fund IncorporatedN3979PPiper PA-18 · S/N 18-4771Cancelled Jul 15, 1958 · Built 1956 · Aircraft Sales And ServiceN41606Culver LFA · S/N 358Cancelled Jun 23, 1958 · Built 1941 · Aircraft Sales & ServiceN42296Piper J3C-65 · S/N 14545Cancelled Feb 28, 1956 · Hawthome Flying Service IncN52604Cessna T-50 · S/N 4455Cancelled Nov 29, 1955 · Hawthorne Flying Service IncN48919Interstate S-1B1 · S/N 215Cancelled Oct 21, 1955 · Colin Luther BrittN66229Stinson VULTEE V-77 · S/N 77-472Cancelled Oct 13, 1955 · Dixie Aviation CoN85744Aeronca 7AC · S/N 7AC-4493Cancelled Oct 13, 1955 · Dixie Aviation CoN46549Fairchild M-62A · S/N T43-7345Cancelled Oct 12, 1955 · Built 1949 · Hawthorne Flying Service IncN8142KStinson 108-1 · S/N 108-1-1142Cancelled Oct 4, 1955 · Built 1943 · South Carolina Aeronautics CommissionN34778Culver LCA · S/N 233Cancelled May 5, 1954 · Wilkins W ON36728Stinson 10A · S/N 8128Cancelled Sep 30, 1952 · Built 1941 · Ross John RN52612Cessna T-50 · S/N 4443Cancelled Jan 25, 1952 · Hawthorne Flying ServiceN96825Taylorcraft BC12-D · S/N 9125Cancelled Jan 16, 1952 · C H ManningN8856KStinson 108-1 · S/N 108-1856Cancelled Dec 4, 1951 · Brown C O JrN88HStinson SR-9E · S/N 5453Cancelled Nov 19, 1951 · Blackwell Burney LN3421HErcoupe 415-C · S/N 4046Cancelled Jul 7, 1950 · Built 1946 · Doughty A RN748CStinson 108-3 · S/N 108-3748Cancelled Jul 21, 1949 · John T CampbellN91476North American NAVION · S/N NAV4112Cancelled May 25, 1949 · Fulmer L DN55098Cessna T-50 · S/N 5704Cancelled Mar 3, 1949 · Hawthorne Flying Service IncN46830Piper TG-8 · S/N G-147Cancelled Jan 12, 1949 · Hawthorne Flying Service IncN66217Cessna T-50 · S/N 3899Cancelled Jan 1, 1949 · Seastrunk F JN52606Cessna T-50 · S/N 5018Cancelled Nov 30, 1948 · Hawthorne Flying Service IncN52601Boeing A75 · S/N 75-917Cancelled Nov 29, 1948 · Shorter Wendell SN39387Aeronca 65-TAL · S/N 4732Cancelled Sep 16, 1948 · Dixie Aviation CoN39451Stinson 10A · S/N 8251Cancelled Sep 3, 1948 · Built 1942 · Du Bose T JN46831Piper J3C-65 · S/N 202Cancelled Mar 30, 1948 · Haawthorne Flying Service IncN66244Cessna T-50 · S/N 3796Cancelled Oct 1, 1947 · Built 1943 · Hawthorne Flying Service IncN34628Stinson 10A · S/N 8028Cancelled Nov 19, 1945 · Harold DaltonN57MMoth 60-GM · S/N 73Cancelled Mar 17, 1943 · Hawthorne Flying Service IncN15074Piper E-2 · S/N 214Cancelled Jul 3, 1941 · Pace Charlie Floyd Bedwell Donald Fort E McclendonN5216Ryan B1 · S/N 104Cancelled Jan 1, 1939 · Cary James HaroldN10858Stinson SM-6000-B · S/N 5047Cancelled Oct 25, 1938 · Built 1931 · Parrish Bishop Pershaw JrN5065Pheasant H-10 · S/N 116Cancelled May 22, 1933 · Gary Harold JN332VQuinn Ervin SPORT · S/N 1Cancelled Jan 6, 1932 · Lee Albert
Back to Columbia, SC