OpenAirDocs.org
Corsicana, TX

Cancelled registrations · 46

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 = 'TX' AND d.registrant_city = 'CORSICANA'
  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.

N7770North American NAVION · S/N NAV-4-898Cancelled Nov 18, 2021 · Registration expired, pending cancellation · Thomas Charles WN52169Aeronca 0-58B · S/N 058B-1782Cancelled Aug 20, 2021 · Registration expired, pending cancellation · Built 1942 · Montgomery Lee HN71934Luscombe 8A · S/N 3400Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Thomas Charles WN520MPIsrael Aircraft Industries 1124 · S/N 421Cancelled Dec 27, 2018 · Registration expired, pending cancellation · Built 1985 · Texas Air Partners LLCN115YTaver Special PAC · S/N 100Cancelled Mar 23, 2018 · Revoked, canceled · Built 1959 · Laudan Fred MN85685Aeronca 7AC · S/N 7AC4431Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Mcgehee Bobby NealN7326TCessna 172A · S/N 46926Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1959 · Venable James DN971APiper PA-28-181 · S/N 28-7990351Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Graveldon IncN21210Cessna 172M · S/N 17263907Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1974 · Lous Aircraft IncN5331MCessna 152 · S/N 15284539Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1980 · Air O Navarro IncN1734EAeronca 7AC · S/N 7AC-5301Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1946 · Cumbie Glenn WN58202Fairchild M-62A-3 · S/N FV-639Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1945 · Montgomery DeanieN271JDBeech B50 · S/N CH-25Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1954 · Corsicana Air Transit IncN2398JBeech 23 · S/N M-366Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1963N4456NCessna T-50 · S/N 3016Cancelled Jul 9, 2012 · Revoked, canceled · Built 1943 · Richards Paul EN115HRyan Aeronautical ST3KR · S/N 2032Cancelled May 24, 2012 · Sale reported, canceled · Built 1942N4002JCessna 150G · S/N 15065302Cancelled Aug 5, 2010 · Built 1966 · Jones Mark DN880GHAerospatiale AS350D · S/N 1112Cancelled Jun 9, 2009 · Exported to Canada · Built 1979 · Guardian Industries CorpN8256FCessna 150F · S/N 15064356Cancelled Nov 5, 2004 · Triennial form not returned · Built 1966 · Navarro CollegeN228GBDouglas DC3C 1830-94 · S/N 26093Cancelled Mar 26, 1996 · Triennial form not returned · Texas State GuardN604TGDehavilland BEAVER U-6A · S/N 5116513Cancelled Mar 26, 1996 · Triennial form not returned · Texas State GuardN11436Waco QCF-2 · S/N 3492Cancelled Feb 27, 1996 · Montgomery Joseph RN714LUCessna 150M · S/N 15079265Cancelled Sep 22, 1980 · Air O Navarro IncN1098JAero Commander 112 · S/N 100Cancelled Aug 16, 1980 · Administratively canceled · Galaxie Compressor Service IncN3648SCessna 172E · S/N 17250848Cancelled Nov 1, 1974 · Exported to Canada · Gallup Allen IN75723Convair BT-15 · S/N 7669Cancelled Nov 30, 1971 · Curry J DN89321Cessna 140 · S/N 8349Cancelled Jul 15, 1971 · Hashop JoeN9901HConvair BT-13 · S/N 5889Cancelled Sep 9, 1970 · Norman E RN74296Bellanca 14-13-2 · S/N 1409Cancelled Jul 8, 1970 · Cumbie GlennN88108Piper J3C-65 · S/N 15285Cancelled Jul 8, 1970 · Glenn CumbieN88529Piper J3C-65 · S/N 16154Cancelled Jul 8, 1970 · Farm EnterprisesN25760Piper J-3C · S/N 3715Cancelled Jul 7, 1970 · Built 1939 · Farm EnterprisesN2671VCessna 170 · S/N 18181Cancelled Jul 7, 1970 · Cubie GlennN50718Piper J3C-65 · S/N 9944Cancelled Jul 7, 1970 · Built 1942 · Cumbie GlennN14DMBeech D-50 · S/N DH-56Cancelled Nov 3, 1969 · Weldon D MontgomeryN8774HNorth American NAVION · S/N NAV-4-774Cancelled May 22, 1965 · Nicholsondanny TN84881Aeronca 7AC · S/N 7AC-3600Cancelled Jul 12, 1951 · Corsicana School Of AeronauticsN88515Piper J3C-65 · S/N 16140Cancelled Feb 13, 1951 · Farm EnterprisesN829CStinson 108-3 · S/N 108-3829Cancelled Oct 31, 1950 · C L Brown Oil CoN26451Meyers OTW · S/N 4Cancelled Oct 27, 1949 · Built 1940 · Vinson W AN2448MPiper PA-12 · S/N 12-1683Cancelled Jun 14, 1949 · Corsicana School Of AeronauticsN54351Fairchild M-62A · S/N T41-1142Cancelled Jan 11, 1949 · Donnell B MN54345Fairchild PT-19A · S/N T41-773Cancelled Dec 2, 1948 · Donnell B MN41136Piper J5A · S/N 1249Cancelled Sep 10, 1948 · Donnell B MN8476Stinson SM-2AB · S/N 1080Cancelled Mar 31, 1948 · Caldwell W C DBA Corsicana Flying ServiceN10591Laird LC-RW300 · S/N 180Cancelled May 7, 1943 · Built 1930 · Stephenson D P
Back to Corsicana, TX