Chicago, IL

Cancelled registrations · 1,693

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

N54322Cessna T-50 · S/N 2756Cancelled Feb 12, 1948 · Built 1943 · Glasser Ernest CN744KWallace B-330 · S/N 14Cancelled Feb 6, 1948 · Janes John MerrickN201HFairchild KR-31 · S/N 297Cancelled Dec 24, 1947 · James L AtwellN17841Piper J-2 · S/N 1276Cancelled Dec 4, 1947 · Stanley SikoraN39320Aeronca 65-CA · S/N CA18122Cancelled Dec 2, 1947 · Built 1943 · Smith DaleN630EAmerican Eagle 101 · S/N 367Cancelled Nov 25, 1947 · Built 1929 · Wojnick M/Rodrian G/Manning R/Bachi JN37090Luscombe 8A · S/N 1751Cancelled Oct 15, 1947 · Built 1941 · Winters OrinN87297Erco 415-C · S/N 470Cancelled Oct 7, 1947 · Stephen A FN10546Swanson W15 · S/N 1Cancelled Oct 3, 1947 · Built 1930 · Cleary Daniel F JrN47330Taylorcraft DCO-65 · S/N L-5174Cancelled Sep 30, 1947 · Gamache Louis JN19505Piper J-2 · S/N 1705Cancelled Sep 29, 1947 · Built 1937 · Lane Ray UN34224Mead GLIDER · S/N G-212Cancelled Sep 29, 1947 · John F PrinceN9633Buhl CA-6 · S/N 48Cancelled Sep 9, 1947 · Exported to Canada · Built 1929 · The 420 Buhl ClubN40005Stinson L-5 · S/N 76-628Cancelled Jun 19, 1947 · Exported to Mexico · Jack JonesN9533HFairchild M-62C(PT-23A) · S/N FE-53Cancelled May 9, 1947 · Eppler John WN1957PPeter W Kramer PA18 · S/N 18-4184Cancelled Apr 3, 1947 · Exported to Canada · Frank J KlancnikN93937Ercoupe 415-C · S/N 1260Cancelled Mar 17, 1947 · Built 1946 · Earl G. ThuressonN51398Fairchild M-62A · S/N T42-3868Cancelled Jan 27, 1947 · Chicago Air ClubN287Boeing 40B · S/N 898Cancelled Nov 6, 1946 · Exported to Honduras · United Air Lines Transport CorporationN22085Luscombe 8A · S/N 907Cancelled Jun 2, 1946 · Built 1939 · Winters OrinN16233Waco EQC-6 · S/N 4440Cancelled May 21, 1946 · Built 1936 · Hensinger Benjamin EN25611Douglas DC-3A-S1C3G · S/N 3255Cancelled Apr 10, 1946 · Exported to Mexico · United Air Lines IncN25618Douglas DC3A · S/N 3262Cancelled Apr 3, 1946 · United Air Lines IncN25615Douglas DC-3A-S1C3G · S/N 3259Cancelled Mar 21, 1946 · Exported to Mexico · United Air Lines IncN225Waco UPF-7 · S/N 5308Cancelled Dec 3, 1945 · Dept Of CommerceN16456Commonwealth REARWIN 7000 · S/N 481Cancelled Jul 14, 1945 · Built 1936 · Read Arlyn VN14065Waco YKC · S/N 3989Cancelled Oct 6, 1944 · Built 1934 · Kenniston John DN179NBellanca CH400 SKYROCKET · S/N 601Cancelled May 21, 1943 · John B HolmbergN907KCurtiss Wright ROBIN · S/N 505Cancelled Apr 29, 1943 · James McgawN16090Douglas DC3A-SC3G · S/N 1929Cancelled Aug 6, 1942 · United Air Lines Transport CorpN8704Travel Air A-6000-A · S/N 981Cancelled Feb 27, 1942 · Exported to Mexico · Walter G DaiberN8820Stearman C3-B · S/N 235Cancelled Jan 15, 1942 · Harbican Harold WN17311Lockheed 12A · S/N 1211Cancelled Sep 19, 1941 · Built 1937 · Walgreen CoN17743Waco YKS-7 · S/N 4669Cancelled Jul 29, 1941 · Built 1937 · Aircraft Sales CorpN721MRyan B-7 · S/N 253Cancelled Jun 1, 1941 · Hasco CorporationN9036Travel Air 4000 · S/N 837Cancelled May 15, 1941 · Williams WalterN23469Piper J3F-50 · S/N 3190Cancelled May 14, 1941 · Sikora StanleyN14502Buhl CA-6 · S/N S-420Cancelled May 6, 1941 · Exported to Mexico · Blue Bird Air Service IncN9419Laird LCR-300 · S/N 179Cancelled May 1, 1941 · Anderson Opal PearlN960KParks P-1 · S/N 198-12Cancelled Mar 1, 1941 · Hopp CharlesN31600Howard DGA-18 · S/N 600Cancelled Jan 28, 1941 · Howard Aircraft CorpN13339Boeing 247D · S/N 1721Cancelled Jan 12, 1941 · Built 1933 · United Air Lines TransportN16072Douglas DC3A · S/N 1912Cancelled Jan 12, 1941 · United Air Lines Transport CorpN25678Douglas DC-3A-S1C3G · S/N 2175Cancelled Dec 4, 1940 · Built 1940 · United Air Lines Transport CorpN203WStinson SM-8A · S/N 4018Cancelled Nov 15, 1940 · Built 1930 · Dowell MaynardN8153Travel Air 2000 · S/N 917Cancelled Nov 15, 1940 · Built 1929 · Crawford Lawrence FN16086Douglas DC3A · S/N 1925Cancelled Nov 4, 1940 · United Airlines Transport CorpN3962Waco GXE · S/N 1261Cancelled Nov 1, 1940 · Built 1928 · Durrer Burnie/ Barkly GeorgeN25421Porterfield CP-50 · S/N 595Cancelled Oct 6, 1940 · Walter Frank/Ramer Ralph WN378KRyan B-5 · S/N 215Cancelled Sep 10, 1940 · Allen James W
Back to Chicago, IL