OpenAirDocs.org
Jackson, MS

Cancelled registrations · 160

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 = 'MS' AND d.registrant_city = 'JACKSON'
  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.

N38814Bell TH-13T · S/N 3614Cancelled Dec 3, 1975 · Sale reportedN38813Bell TH-13T · S/N 3616Cancelled Dec 2, 1975 · Dept Of Agriculture & CommerceN216ACBell TH-13T · S/N 67-17139Cancelled Oct 25, 1975 · Mississippi Dept Of Agric & CommerceN9165YPiper PA-31 · S/N 31-218Cancelled Mar 12, 1974 · Exported to South Africa · Jim Hankins Air Service IncN13978Piper PA-23-250 · S/N 27-4596Cancelled Jan 30, 1974 · Jim Hankins Air Service IncN3934RCessna 172H · S/N 17255434Cancelled Jun 22, 1973 · Built 1967 · Jim Ratliff Air Service IncN65738Hiller OH-23D · S/N 58-5408Cancelled Feb 13, 1973 · Mississippi Civil Defense CouncilN3217TCessna 177 · S/N 17700517Cancelled Sep 26, 1972 · Mississippi School Of Aviation IncN8428SCessna 182H · S/N 18256528Cancelled Apr 18, 1972 · Worrell Hall Et AlN80398Beech D18S · S/N A-369Cancelled Mar 21, 1972 · Hankins Airways IncN7251VIntermountain CALLAIR A-9 · S/N 1288Cancelled Sep 2, 1971 · Revoked, pending cancellation · Built 1966 · Gardner Thomas YN2310Spencer-Bensen B-8M · S/N 366-6274Cancelled Aug 27, 1971 · Built 1968 · Spencer Jr Ernest ON5388SCessna 337A · S/N 337-0488Cancelled Jul 9, 1971 · Jim Ratliff Air Service IncN35039Piper J5A-80 · S/N 5549Cancelled May 27, 1971 · Basil B McdonaldN96626Taylorcraft BC12-D · S/N 8926Cancelled Jan 4, 1971 · Yeager Dale DN75485Beech AT-11 · S/N 3291Cancelled Nov 17, 1970 · Built 1942 · Hankins Airways IncN7508ZPiper PA-25-235 · S/N 25-3542Cancelled Oct 21, 1970 · B & R Crop Air Service IncN25424Porterfield CP-50 · S/N 598Cancelled Sep 21, 1970 · Merold CothernN8184XCessna 172B · S/N 17248684Cancelled Aug 20, 1970 · Jones FrankN4723PPiper PA-23-250 · S/N 27-251Cancelled Aug 3, 1970 · Jim Hankins Air Service IncN7919LBeech A23-19 · S/N MB-138Cancelled Aug 3, 1970 · Jim Hankins Air Service IncN4366KNorth American NAVION · S/N NAV-1-1366Cancelled Jun 30, 1970 · Built 1948 · Lee Dan MN1854XCessna 182H · S/N 18255954Cancelled Aug 20, 1969 · Exported to Bolivia · Crosby Karen WendyN4021MPiper PA-12 · S/N 12-2904Cancelled Nov 25, 1966 · Huston LeachN1802HCessna 310C · S/N 35902Cancelled Jan 4, 1966 · Walkler Ben NN44622Beech D18S · S/N A-30Cancelled May 22, 1965 · National Investment Co IncN9200EAeronca 11AC · S/N 11AC834Cancelled May 21, 1965 · Built 1946 · Miller Scott FN5402CCessna 170A · S/N 19436Cancelled Dec 9, 1964 · Wallace Jimmy KN8516MBeech 95-A55 · S/N TC-454Cancelled Dec 12, 1963 · Mississippi Forestry CommissionN2140DBeech D35 · S/N D-3485Cancelled Dec 11, 1963 · Kelly I BN555DMLockheed PV-1 · S/N 5241Cancelled Dec 6, 1963 · Milner Enterprises IncN8149TCessna 175B · S/N 17556849Cancelled Nov 6, 1963 · Nygren Air ServiceN27231Rearwin 175 · S/N 1505Cancelled May 6, 1963 · Built 1940 · Snipes ThomasN7797DPiper PA-18A 150 · S/N 18-6001Cancelled Oct 21, 1958 · Sellers Motor CoN1760MAeronca 7CCM · S/N 7CCM-83Cancelled Jul 2, 1958 · Civil Air Patrol IncN9419EAeronca 11AC · S/N 11AC-1056Cancelled Mar 15, 1956 · Exported to Canada · Learned George TylerN65664Consolidated Vultee BT-13 · S/N 8183Cancelled Mar 14, 1956 · Built 1942 · Dixie Air Services IncN67161Douglas A-26B · S/N 28046Cancelled Oct 13, 1955 · Aponaug Manufacturing CoN76605Cessna 140 · S/N 11045Cancelled Oct 12, 1955 · Cleveland J E MrsN87246Ercoupe 415-C · S/N 419Cancelled Nov 5, 1952 · Campbell Bruce HN38976Boeing A75N1 · S/N 75-4389Cancelled Oct 23, 1952 · Mississippi Aircraft CoN38999Taylorcraft/Bacher Scott N DC0-65/L2M · S/N L-5646Cancelled May 3, 1951 · Dixie Air Services IncorporatedN1377EAeronca 7AC · S/N 7AC-4938Cancelled Apr 30, 1951 · Built 1946 · OwnerN96551Taylorcraft BC12-D · S/N 8851Cancelled Apr 27, 1951 · Curcio Carmen LN52536Consolidated Vultee BT-13A · S/N 8060Cancelled May 8, 1950 · Boothe Dexter O SrN38990Consolidated Vultee BT-13A · S/N 6517Cancelled Mar 14, 1950 · Delta Chenille CoN89649Cessna 140 · S/N 8696Cancelled Jul 5, 1949 · Mississippi Aircraft CoN73302Stinson AT-19 · S/N 77-344Cancelled Jun 9, 1949 · Griffin Distributing CoN1760VCessna 140 · S/N 13945Cancelled Jun 7, 1949 · Stokes Interiors IncN81147Funk B85C · S/N 277Cancelled Mar 8, 1949 · J W Sanders Cotton Mill Inc
Back to Jackson, MS