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.

N3857Dehavilland 4B (MAIL) · S/N 348Cancelled Feb 19, 1929 · Gloppe ElmerN2797Standard STANDARD J-1 · S/N A-1118Cancelled Feb 9, 1929 · Peck Robert ZN27Curtiss Aeroplane & Motor CARRIER PIGEON · S/N 1Cancelled Feb 1, 1929 · National Air Transport IncN790Douglas M-4 · S/N 653Cancelled Jan 7, 1929 · National Air Transport IncN1829Dehavilland 4B (MAIL) · S/N 376Cancelled Dec 21, 1928 · Chicago Daily News IncN792Douglas M-3 · S/N 650Cancelled Dec 5, 1928 · National Air Transport IncN4623Pheasant H-10 · S/N 115Cancelled Oct 12, 1928 · American Institute Of AeronauticsN5008National Airways System AIR KING 28 · S/N 159Cancelled Oct 4, 1928 · Paul PetersN5595Curtiss Wright JN4C · S/N 125Cancelled Aug 24, 1928 · Keller Henry CN1360Swallow Airplane Mfg SWALLOW LAND PLANE · S/N A-1942Cancelled Aug 15, 1928 · Aviation Service And Transport IncN5331Curtiss JN4C · S/N C 1222Cancelled Aug 4, 1928 · Cyril BurtonN2187Curtiss JN4D · S/N 259Cancelled Jul 1, 1928 · Built 1925 · Cropp Warren WN3156Waco 10 · S/N 819Cancelled Feb 25, 1928 · Beardsley & Piper CoN2799Standard J-1 · S/N A-1120Cancelled Jan 21, 1928 · Built 1917 · W J SheltonN2622Waco 9 · S/N 376Cancelled Jan 19, 1928 · Chicago Aeronautical Service IncN1595Swallow Airplane Mfg K · S/N 223Cancelled Dec 15, 1927 · Built 1926 · Aviation Service & Transport IncN2098Butte Gorenflo & Brady BGB MIDWING · S/N 295Cancelled Aug 8, 1927 · Built 1927 · Keller H CN201Curtis Oriole Club C-6 ORIOLE · S/N C-6Cancelled Jul 20, 1927 · Newhall Wilson VN18633Curtiss Wrightaeroplane CARRIER PIGEON 2 · S/N K-5015-7Cancelled May 5, 1927 · Built 1926 · National Air Transport IncN2173Laird CABIN BIPLANE · S/N A-371Cancelled Apr 12, 1927 · Built 1925 · Etten Henry CN1032Curtiss Aeroplane & Motor LAND PLANE · S/N 8Cancelled Feb 23, 1927 · National Air Transport IncN1002Douglas M-3 · S/N 621Cancellation date not recorded · National Air Transport IncN10VSikorsky S-38-C · S/N 314-14Cancellation date not recorded · American Airways IncN1134Curtiss Wright JN4C · S/N A-132Cancellation date not recorded · Fuglstad E & W RiggN1160E M Laird LAIRD COMMERCIAL · S/N 148Cancellation date not recorded · Keller H CN1275Likosiak Kazimir LIKOSIAK BIPLANE · S/N A-1880Cancellation date not recorded · Kazimir LikosiakN1487HAeronca 15AC · S/N 15AC-557Cancellation date not recorded · Edgar Irving W And/Or Ruth A EdgarN17152Stinson SR-9B · S/N 5113Cancellation date not recorded · Built 1937 · Monarch Air ServiceN2295Standard J-1 · S/N 7078Cancellation date not recorded · Meyer W WN2303Allred Earl F THOMAS MORSE BIPLANE · S/N A-570Cancellation date not recorded · Allred Earl FN2354Curtiss JN4D · S/N A-621Cancellation date not recorded · Ullom Chas MN2583Canuck BIPLANE · S/N A-885Cancellation date not recorded · Priestman Stuart LawrenceN5863Pitcairn PA-5 · S/N 25Cancellation date not recorded · Built 1928 · National Air TransportN60166Cessna T-50 · S/N 5066Cancellation date not recorded · Eppler John WN61379Cessna T-50 · S/N 6433 (43-32495)Cancellation date not recorded · Built 1943 · Ouide A HelsingN61805Cessna T-50 · S/N 6048Cancellation date not recorded · The Hub Henry C Lytton And CoN64221Cessna T-50 · S/N 4642Cancellation date not recorded · Ralph RissmanN650Standard J-1 · S/N 120Cancellation date not recorded · Robert H PolkN6605U S U S BIPLANT NO 11 · S/N 11Cancellation date not recorded · U S Airplane CoN6797Lincoln LINCOLN PAGE 3 · S/N 234Cancellation date not recorded · Julian I FarwellN69404Cessna T-50 · S/N 5616Cancellation date not recorded · Eppler John WN69704Cessna T-50 · S/N 2687Cancellation date not recorded · Lober Donald W JrN730NConsolidated 17 FLEETSTER 2-H · S/N 7Cancellation date not recorded · Built 1931 · Mccormick Robert H
Back to Chicago, IL