OpenAirDocs.org
Wood River, IL

Cancelled registrations · 43

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 = 'IL' AND d.registrant_city = 'WOOD RIVER'
  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.

N442JHHall Jackie R DRAGONFLY · S/N 442Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Hall Jackie RN102GBeech CONRAD 10200 · S/N 44-47188Cancelled Jun 25, 2009 · Registration revoked · Built 1944 · Orbalkin Lorenzo RN761QBCessna 210M · S/N 21062424Cancelled May 13, 1982 · Walston Aviation Sales IncN2003SCessna R182 · S/N R18201280Cancelled Mar 24, 1981 · Exported to South Africa · Built 1979 · Walston Aviation Sales IncN5377CCessna 210N · S/N 21063735Cancelled Feb 27, 1981 · Exported to South Africa · Walston Airbusiness IncN704GZCessna 337H · S/N 33701946Cancelled Nov 6, 1980 · Exported to Canada · Walston Airbusiness IncN5152NCessna 182Q · S/N 18267547Cancelled Sep 26, 1980 · Exported to Canada · Built 1980 · Walston Air Business IncN1922ECessna 340A · S/N 340A0670Cancelled Apr 10, 1980 · Exported to Canada · Built 1979 · Walson Aviation Sales IncN2616BCessna 402C · S/N 402C0113Cancelled Dec 7, 1979 · Exported to Mexico · Built 1979 · Walston Aviation Sales IncN734SDCessna U206G · S/N U20604866Cancelled Jun 22, 1979 · Exported to Mexico · Walston Aviation Sales IncN733LVCessna U206G · S/N U20604777Cancelled Jun 14, 1979 · Exported to Mexico · Walston Aviation Sales IncN96707Cessna 182Q · S/N 18266817Cancelled Jun 14, 1979 · Exported to Mexico · Walston Aviation Sales IncN497GCessna 310L · S/N 310L-0004Cancelled Mar 21, 1979 · Exported to Canada · Walston Aviation Sales IncN756NXCessna U206G · S/N U20604234Cancelled Dec 8, 1978 · Exported to Democratic Republic of the Congo · Walston Aviation Sales IncN756SDCessna U206G · S/N U20604312Cancelled Dec 6, 1978 · Exported to Democratic Republic of the Congo · Walston Aviation Sales IncN738WTCessna 172N · S/N 17270300Cancelled Jun 8, 1978 · Exported to Australia · Walston Aviation Sales IncN738WACessna 172N · S/N 17270285Cancelled May 25, 1978 · Exported to Australia · Walston Aviation Sales IncN738UVCessna 172N · S/N 17270256Cancelled Apr 20, 1978 · Exported to Australia · Walston Aviation Sales IncN738VHCessna 172N · S/N 17270268Cancelled Apr 20, 1978 · Exported to Australia · Walston Aviation Sales IncN756SYCessna U206G · S/N U20604331Cancelled Apr 11, 1978 · Exported to Australia · Walston Aviation Sales IncN736NDCessna R172K · S/N R1722650Cancelled Mar 27, 1978 · Exported to Australia · Walston Aviation Sales IncN93198Cessna A185F · S/N 18503197Cancelled Mar 27, 1978 · Exported to Canada · Walston Aviation Sales IncN735GZCessna 182Q · S/N 182 65425Cancelled Jan 26, 1978 · Exported to Australia · Walston Aviation Sales IncN63104Cessna 180K · S/N 18052830Cancelled Nov 29, 1977 · Exported to Australia · Walston Aviation Sales IncN735XACessna 182Q · S/N 18265756Cancelled Nov 1, 1977 · Exported to Australia · Walston Aviation Sales IncN714RWCessna 150M · S/N 15079384Cancelled Oct 17, 1977 · Exported to Australia · Walston Aviation Sales IncN737KKCessna 172N · S/N 17269475Cancelled Oct 12, 1977 · Exported to Australia · Walston Aviation Sales IncN4850QCessna A188B · S/N 18802586TCancelled Oct 4, 1977 · Exported to Australia · Walston Aviation Sales IncN736FECessna R172K · S/N R1722486Cancelled Sep 28, 1977 · Exported to Australia · Walston Aviation Sales IncN737BVCessna 172N · S/N 17269299Cancelled Aug 26, 1977 · Exported to Australia · Walston Aviation Sales IncN9061MCessna 210M · S/N 21062056Cancelled Aug 26, 1977 · Exported to Australia · Walston Aviation Sales IncN714MHCessna 150M · S/N 15079278Cancelled Aug 24, 1977 · Exported to Australia · Walston Aviation Sales IncN714MVCessna 150M · S/N 15079289Cancelled Aug 24, 1977 · Exported to Australia · Walston Aviation Sales IncN735ZXCessna 182Q · S/N 18265825Cancelled Aug 12, 1977 · Exported to Australia · Walston Aviation Sales IncN734YKCessna 172N · S/N 17269219Cancelled Aug 9, 1977 · Exported to Australia · Walston Aviation Sales IncN734ZXCessna 172N · S/N 17269255Cancelled Aug 9, 1977 · Exported to Australia · Walston Aviation Sales IncN737AKCessna 172N · S/N 17269267Cancelled Aug 9, 1977 · Exported to Australia · Walston Aviation Sales IncN759AMCessna 182Q · S/N 18265839Cancelled Aug 9, 1977 · Exported to Australia · Walston Aviation Sales IncN732WJCessna 210M · S/N 21061830Cancelled Jul 18, 1977 · Exported to Australia · Walston Aviation Sales IncN6354Elliott TEENIE 2 · S/N 5940Cancelled Jul 14, 1977 · Elliott Donnie RayN733GGCessna 172N · S/N 17268280Cancelled Jun 9, 1977 · Exported to Australia · Walston Aviation Sales IncN8286GCessna U206 · S/N U206 03786Cancelled May 20, 1977 · Exported to Suriname · Walston Aviation Sales IncN48351Taylorcraft DCO-65 · S/N 0-4389Cancelled Jul 21, 1971 · Corbin Nelson K
Back to Wood River, IL