OpenAirDocs.org
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.

N49616Bell 205A-1 · S/N 30212Cancelled Dec 12, 1975 · Exported to Brazil · Air Associates IncN6921HCessna 172M · S/N 17265645Cancelled Dec 3, 1975 · Exported to Canada · T K Aviation IncN7353LAmerican AA-5 · S/N AA5-0253Cancelled Nov 6, 1975 · Exported to Canada · T K Aviation IncN7208QCessna 172L · S/N 17260508Cancelled Nov 3, 1975 · Exported to Canada · T K Aviation IncN5324HCessna 172M · S/N 17265404Cancelled Oct 7, 1975 · Exported to Canada · T K Aviation IncN8243NPiper PA-28-140 · S/N 28-25451Cancelled Oct 6, 1975 · Northcott Norval JN30836Cessna 177B · S/N 17701496Cancelled Sep 2, 1975 · Built 1970 · 35145 Associates IncN3413ZPiper PA-22-150 · S/N 22-7326Cancelled Aug 28, 1975 · Built 1960 · Sojka TheodoreN19035Cessna 150L · S/N 15074112Cancelled Aug 11, 1975 · Exported to Canada · T K Aviation IncN19112Cessna 150L · S/N 15074177Cancelled Aug 11, 1975 · Exported to Canada · T K Aviation IncN33MCBell 206A · S/N 320Cancelled Jul 30, 1975 · Exported to Canada · Air Associates IncN9060FHughes 369HS · S/N 700244SCancelled Jul 17, 1975 · Exported to Canada · Air Associates IncN66CHSikorsky S-58DT · S/N 58-1438Cancelled Jul 14, 1975 · Exported to South Africa · Chicago Helicopter Industries IncN7841LBeech A65 · S/N LC271Cancelled Jul 3, 1975 · Exported to Canada · Imperial Eastman CorpN3985KPiper PA-28-140 · S/N 28-23874Cancelled Jun 30, 1975 · Built 1967 · Apke Edward AN95371Piper PA-28-140 · S/N PA2825903Cancelled Jun 28, 1975 · Built 1969 · Jersey Lilly Club LtdN2477XCessna 182H · S/N 18256377Cancelled Jun 11, 1975 · Sirk Arnold DN20598Cessna 172M · S/N 17261430Cancelled Jun 6, 1975 · Exported to Canada · T K Aviation IncN1429WBell 206B · S/N 354Cancelled Jun 4, 1975 · Exported to Canada · Built 1968 · Air Associates IncN6274NBell 206A · S/N 142Cancelled May 15, 1975 · Exported to Canada · Chicago Helicopter Industries IncN72809Cessna 140 · S/N 9995Cancelled May 9, 1975 · Accardo Joseph LN6791HPiper J3C-65 · S/N 20005Cancelled May 7, 1975 · Mortimer J StirlingN8062NPiper PA-28-140 · S/N 28-25311Cancelled May 6, 1975 · Krohn Edward JN102AKLockheed 382B · S/N 4234Cancelled May 5, 1975 · Built 1967 · National Aircraft Leasing LtdN9BCDouglas DC3C · S/N 9510Cancelled May 5, 1975 · Air O Hare LtdN7981WPiper PA-28-180 · S/N 28-2035Cancelled Apr 28, 1975 · Hi Six IncN20LCessna 337 · S/N 337-0076Cancelled Mar 25, 1975 · Lebolt & CoN19048Cessna 150 · S/N 150-74125Cancelled Mar 13, 1975 · Aviation Training Enterprises IncN9477NPiper PA-28R-200 · S/N 28R-35195Cancelled Mar 13, 1975 · Sullivan William JN5453SCessna 337 · S/N 3370553Cancelled Feb 27, 1975 · Built 1967 · Hebert MauriceN366AAGates Lear Jet 25B · S/N 151Cancelled Feb 7, 1975 · Trans Union Aircraft Leasing CorpN876Sikorsky S-58C · S/N 58310Cancelled Dec 20, 1974 · Exported to Australia · Chicago Helicopter Airways IncN2968TAero Commander 200D · S/N 341Cancelled Nov 22, 1974 · Edgcomb David AN4723RBell 206A · S/N 248Cancelled Nov 19, 1974 · Exported to Canada · Air Associates IncN9643XCessna 210B · S/N 21057943Cancelled Oct 23, 1974 · Franciscan Missionary UnionN9413YBeech 95-55 · S/N TC-27Cancelled Sep 25, 1974 · Heller Walter E & CompanyN37593Douglas DC-6A · S/N 44908Cancelled Sep 17, 1974 · Exported to Mexico · United Air Lines IncN6339CDouglas DC-7 · S/N 45153Cancelled Sep 5, 1974 · United Air Lines IncN7180WPiper PA-28-180 · S/N 28-988Cancelled Sep 3, 1974 · Fidelity Properties IncN8282NPiper PA-28-140 · S/N 28-25498Cancelled Aug 19, 1974 · Henson Richard LN5965RCessna 172G · S/N 17253634Cancelled Aug 8, 1974 · Moody Bible Institute Of ChicagoN4294NCessna 140 · S/N 13765Cancelled Jul 30, 1974 · Built 1947 · Blomster Charles RN242ERCessna 210G · S/N 21058914Cancelled May 31, 1974 · Richards EarlN7222UBoeing 720-022 · S/N 18075Cancelled May 30, 1974 · Exported to Iceland · United Airlines Inc / Executive OfficesN9031UBoeing 737-222 · S/N 19069Cancelled May 28, 1974 · United Air Lines IncN35384Cessna 172I · S/N 172-56744Cancelled May 23, 1974 · Maier ThomasN9500HVultee BT-13 · S/N 2327Cancelled May 20, 1974 · Sullivan Donald J Et AlN3998WPiper PA-32-260 · S/N 32966Cancelled May 10, 1974 · Built 1967 · Graham PerryN3196BCessna 170B · S/N 25439Cancelled Apr 19, 1974 · Exported to Canada · Robert A YorkN770GGBell 206A · S/N 410Cancelled Apr 18, 1974 · Exported to Canada · Air Associates Inc
Back to Chicago, IL