OpenAirDocs.org
Glenview, IL

Cancelled registrations · 30

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

N32TMGulfstream Aerospace GULFSTREAM 200 · S/N 023Cancelled Apr 30, 2024 · Exported to Canada · Built 2000 · Jmt LLCN51JHAeriane SWIFT LIGHT E · S/N 154Cancelled Jun 8, 2023 · Pik Ac LLCN9007KCessna 210D · S/N 210-58234Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Crumudgens IncN5686CCessna 140A · S/N 15642Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1950 · Sullivan William LeeN128TBNorth American/Morgan AT28D-10 · S/N 54-137773MCancelled May 22, 2017 · Registration expired, pending cancellation · Morgan John P JrN126CCCentrair 101B · S/N 101B0254Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1987 · Shatzel Albert VN7184KRobinson Helicopter R44 II · S/N 10078Cancelled Feb 18, 2010 · Exported to Greece · Built 2003 · Poulikakos Michael GN1048KMaule MXT-7-180A · S/N 21033CCancelled Jan 22, 2010 · Exported to Greece · Built 1998 · Poulikakos Michael GN9055JCessna 177RG · S/N 177RG1148Cancelled Apr 9, 1997 · Triennial form not returned · Ginger Louis JN86PSHoffman-Flugzeugbau H 36 DIMONA · S/N 360153Cancelled Mar 24, 1997 · Triennial form not returned · Telephone Communications IncN6097GCessna 150K · S/N 15071597Cancelled Apr 17, 1996 · Triennial form not returned · Schacht Wilbur GN1874QCessna 177RG · S/N 177RG0274Cancelled Aug 4, 1992 · Triennial form not returned · Ginger Louis J.N3416UCessna 182F · S/N 18254816Cancelled Mar 13, 1981 · Glenview Naval Flying ClubN64168Cessna 172M · S/N 17265062Cancelled Sep 15, 1980 · Glenview Flying ClubN50127Cessna 150H · S/N 15069078Cancelled May 24, 1976 · Built 1968 · Glenview Naval Flying ClubN5358SCessna 337A · S/N 3370458Cancelled May 24, 1976 · Whitted John B JrN2384LBeech 23 · S/N M-225Cancelled Jun 25, 1973 · Freeland Stanley RN3333CBeech E18S · S/N BA-36Cancelled Aug 12, 1971 · Edward J BrownN85146Aeronca 7AC · S/N 7AC-3877Cancelled Feb 17, 1971 · James Richard GillespieN4538DBeech G35 · S/N D-4720Cancelled Feb 13, 1963 · 738 Woodmere Lane CorpN8886ABeech B35 · S/N D-2541Cancelled May 20, 1960 · Nawodylo William HN64382Consolidated Vultee BT-13 · S/N 10755Cancelled Oct 25, 1955 · Sky Ads IncN34254Hannaford A4 · S/N A4-02Cancelled Oct 19, 1955 · Built 1949 · Hannaford Aircraft Co IncN22273Taylorcraft BL · S/N 1223Cancelled Jun 8, 1948 · Barnes Donald B & Lester BannickN594KAlliance ARGO · S/N 102Cancelled May 11, 1948 · Fleet Air CragoN29329Waco UPF-7 · S/N 5356Cancelled May 28, 1943 · Chicago Aviation CorpN761YFokker STANDARD UNIVERSAL · S/N 439Cancelled May 18, 1942 · Exported to Mexico · Chicago Aviation CorpN713VFleet 2 · S/N 279Cancelled Aug 1, 1940 · Palma Albert V & Psalidas JamesN589VBowlus Sailplane BOWLUS A SAILPLANE · S/N 22Cancelled Sep 1, 1931 · Skeels Paul CN268HCurtiss Wright FLEDGLING · S/N B45Cancelled Sep 5, 1930 · Built 1929 · Curtiss-Wright Flying Service Inc/A Maine Corp
Back to Glenview, IL