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.

N7VSikorsky S-38-C · S/N 314-11Cancelled Jul 18, 1934 · American Airways IncN192HAeromarine Klemm L 25 A · S/N 2-25Cancelled Jul 15, 1934 · Schnabel FrankN706MParks P-1 · S/N 1991Cancelled Jun 15, 1934 · Patin PeterN12354Curtiss-Wright T-32-C CONDOR II · S/N 22Cancelled Jun 9, 1934 · Built 1933 · American Airways IncN13302Boeing 247-A SPECIAL · S/N 1683Cancelled Jun 7, 1934 · United Air Lines IncN18HRyan B-5 · S/N 203Cancelled Jun 1, 1934 · N O Shively & CoN957KParks P-1 · S/N 1989Cancelled Apr 15, 1934 · Widzes KlemN12050Church Airplane & Mfg MIDWING · S/N R-3-31Cancelled Mar 15, 1934 · Larson CarlN710YPilgrim PITTS SPECIAL S-1 · S/N 6606Cancelled Mar 6, 1934 · American Airways IncN982MAmerican Airplane & Engine PILGRIM 100A · S/N 6611Cancelled Feb 12, 1934 · American Airways IncN12057South Park Glider Club SOUTH PARK GLIDER · S/N SPC-2Cancelled Feb 1, 1934 · South Park Glider ClubN4329American Eagle 101 · S/N 101Cancelled Dec 24, 1933 · Fryer Harold E & Herman A SchbertN13322Boeing 247D · S/N 1703Cancelled Dec 17, 1933 · Built 1933 · National Air Transport IncN672Yackey SPORT · S/N 1Cancelled Nov 26, 1933 · Built 1927 · Hoffman Robert MN13304Boeing 247-A SPECIAL · S/N 1685Cancelled Nov 22, 1933 · National Air Transport IncN378VPitcairn PA-6 · S/N 142Cancelled Oct 17, 1933 · American Airways IncN9790Fokker F-10-A(FXA) · S/N 1036Cancelled Oct 17, 1933 · American Airways IncN12194Stinson U · S/N 9020Cancelled Oct 3, 1933 · American Airways IncN914KParks P-1 · S/N 1982Cancelled Aug 21, 1933 · Stancik Edward JohnN12994Byrd-Wendt BYRD-WENDT · S/N BW-7-1Cancelled Aug 16, 1933 · Built 1933 · Byrd-Wendt Aircraft CorpN10351Boeing 40-B-4 · S/N 1432Cancelled Aug 1, 1933 · Built 1930 · National Air Transport IncN688EBellanca CH300 PACEMAKER · S/N 137Cancelled Jul 25, 1933 · Stanley T GirchN31WAdam Biolowski BIOLOWSKI · S/N 100-ACancelled Jul 11, 1933 · Exported to Mexico · Herrera Luis GN805EFokker F-10-A(FXA) · S/N 1034Cancelled Jul 1, 1933 · American Airways IncN451Star CAVALIER · S/N 104Cancelled Jun 29, 1933 · Built 1929 · Aero Agents Co IncN10517Ketchum J/Youngquist A HIGH WING MONOPLANE · S/N A-10Cancelled Jun 17, 1933 · Built 1930 · Oriole Glider ClubN10541North Side Glider Club NORTH GLIDER · S/N 1Cancelled Jun 17, 1933 · Built 1930 · North Side Glider ClubN12054Howard Butters/Hoy Cranston GLIDER · S/N 011Cancelled Jun 17, 1933 · Butters Howard Erb & Hoy Adrian CranstonN8799Cessna AW · S/N 184Cancelled May 1, 1933 · Hamilton DwightN10470Mead Gliders MEAD L-4 GLIDER · S/N G-5Cancelled Apr 28, 1933 · Built 1930 · Mead GlidersN732NAmerican Airplane & Engine PILGRIM 100A · S/N 6612Cancelled Apr 7, 1933 · American Airways IncN10469Mead Gliders MEAD L-3 GLIDER · S/N G-4Cancelled Apr 5, 1933 · Built 1930 · Mead GlidersN12075Loren D Mitchell MITCHELL BUZZARD · S/N A-106Cancelled Feb 16, 1933 · Loren D MitchellN2525Standard J-1 · S/N 10-SCancelled Feb 13, 1933 · Built 1918 · Schoensiegel Lothar WolfgangN401Standard J-1 · S/N 122SUBCancelled Feb 10, 1933 · Love Paul SN3355Waco 9 · S/N J595Cancelled Feb 9, 1933 · Built 1926 · Due Wong WingN355MCurtiss Wright TRAVEL AIR 2000 · S/N 1289Cancelled Feb 7, 1933 · Excell E O JrN2368Waco 9 · S/N 292Cancelled Feb 3, 1933 · Built 1927 · Cipriani Ralph M EtalN281MChurch James JC-2 · S/N LR-1Cancelled Feb 3, 1933 · Built 1929 · Church JamesN81NAlliance ARGO · S/N 118Cancelled Jan 28, 1933 · Walker Sydney JrN738NAmerican Airplane & Engine PILGRIM 100B · S/N 6702Cancelled Jan 24, 1933 · Built 1932 · American Airways IncN1872Curtiss Aeroplane & Motor CURTISS JN-4D · S/N 505Cancelled Jan 14, 1933 · Built 1927 · Seignious Charles WN10542Trower Stallard PARASOL · S/N 1Cancelled Jan 6, 1933 · Built 1930 · Trower StallardN3588Stinson SB-1 · S/N 102Cancelled Jan 6, 1933 · Prieb Frank C EtalN39Swallow Airplane Mfg SWALLOW LAND PLANE · S/N 845Cancelled Jan 4, 1933 · Frampton A RN110NM W Z W LB 5D · S/N MWZ-1Cancelled Dec 28, 1932 · Mwz AircraftN66Curtiss Wright JN4D · S/N 6000Cancelled Dec 19, 1932 · Keila TonyN10481De Maeyer Florent PARASOL · S/N 1Cancelled Dec 13, 1932 · Built 1930 · De Maeyer FlorentN3007Ryan B1 · S/N 31Cancelled Dec 12, 1932 · Aviation Service & Transport IncN801KGreat Lakes 2T-1 · S/N 62Cancelled Dec 5, 1932 · Built 1929 · Arrow Flying Associates
Back to Chicago, IL