OpenAirDocs.org
Lombard, IL

Cancelled registrations · 45

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

N727XADJI PHANTOM 4 · S/N 07DDD2POA10965Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Gordon ToddN1110YCessna 150B · S/N 15059510Cancelled Oct 18, 2019 · Revoked, canceled · Built 1962 · Mitchell Flg Svc IncN8742SCessna 150F · S/N 15062042Cancelled Aug 5, 2019 · Revoked, canceled · Built 1965 · Home Airmotive IncN9506HFairchild M-62A · S/N FV358Cancelled Apr 6, 2018 · Revoked, canceled · Built 1943 · Mitchell K TN8075ZPiper PA-28-161 · S/N 28-8016046Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Built 1979 · Frerichs ArthurN88546Piper J3C-65 · S/N 16171Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Chicago Seaplane Base IncN61459Consolidated Vultee BT-13A · S/N 791650Cancelled Feb 4, 2017 · Revoked, canceled · Built 1944 · Chicago Seaplane Base IncN288SSSmith Shewan Stewart AVID FLYER · S/N 288Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1993 · Smith Shewen SN7023SCessna 150H · S/N 15067723Cancelled Dec 2, 2014 · Revoked, canceled · Built 1967 · Home AirN75687Boeing E75N1 · S/N 75-5215Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Manning William FN65403Boeing E75N1 · S/N 75-7517Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1943 · Manning William FN3854HEngineering & Research 415-D · S/N 4555Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1947 · Koplin Herman JN17BMBoeing A75N1(PT17) · S/N 75-4718Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Manning William F JrN18517State Securities ARROW F · S/N 60Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1937 · Koplin Herman JN5093GHempel Gary S MXII SPRINT · S/N 001Cancelled Aug 27, 2013 · Sale reported, canceled · Built 2006N3473Friling VOLKSPLANE · S/N CB-1Cancelled Jun 12, 2013 · Sale reported, canceledN75BMBoeing A75 · S/N 75-006Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1945 · Manning William F JrN68464Boeing A75N1(PT17) · S/N 75-5815Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1942 · Manning William F JrN4801VBoeing E75 · S/N 75-5427Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Manning William F JrN28077Bellanca 17-31ATC · S/N 78-31147Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1978 · J & S Kleen Car Sales IncN103THHoughton Thomas L FIREFLY · S/N 051Cancelled Dec 4, 2009 · Triennial form not returned · Houghton Thomas LN7274ACessna 182S · S/N 18280531Cancelled Aug 13, 2009 · Exported to Poland · Built 1999 · Sd Exports IncN8906WPiper PA-28-235 · S/N 28-10473Cancelled Jan 23, 2002 · Exported to Latvia · Built 1964 · Gunars LicitisN54RPiper PA-28-140 · S/N 28-7725135Cancelled Nov 5, 1999 · Triennial form not returned · Shamrock Aviation LtdN701RCCothern Ronald D QUICKIE · S/N RC1Cancelled Feb 4, 1993 · Triennial form not returned · Cothern Ronald DN983BWPitts SPECIAL S1-S · S/N XCancelled Jun 21, 1991 · Morgan Mark WN24077Dick-Co. MIGHTY MUSTANG · S/N 1Cancelled Jul 12, 1976 · Fergus Richard WN4805FCessna U206A · S/N U2060505Cancelled Jan 14, 1975 · Exported to Ethiopia · Pancotto Angelo SamuelN3877EAeronca 7AC · S/N 7AC-7104Cancelled Jan 4, 1971 · Travel-Aire-Aviation CoN6898WPiper PA-28-140 · S/N 28-21060Cancelled Jan 4, 1971 · Travel Aire Aviation CoN1336CPiper PA-22-135 · S/N 22-1129Cancelled Jun 30, 1970 · Built 1953 · Lloyd R EN3381APiper PA-22-135 · S/N 22-1638Cancelled Jun 30, 1970 · Built 1953 · Lloyd R EN5491WPiper PA-28-160 · S/N 28-576Cancelled Jun 30, 1970 · Lloyd Richard EN6984ACessna 172 · S/N 29084Cancelled Jun 30, 1970 · Alfred J Reiman / Richard W BernhardtN182DPitts Special S-1C · S/N 14DCancelled Jun 4, 1968 · Carroll F DietzN27795Stinson 10 · S/N 7736Cancelled May 21, 1965 · Heller Donald CN85158Aeronca 7AC · S/N 7AC-3890Cancelled Feb 20, 1956 · Sky Line IncN60510Fairchild PT-26A · S/N FV-648Cancelled Feb 15, 1956 · Sky-Line IncN73548Cessna T-50 · S/N 4423Cancelled Oct 12, 1955 · Lombard Arpt Co IncN55701Cessna T-50 · S/N 2758Cancelled Aug 9, 1951 · Built 1943 · Sky-Line IncN21518Piper J3C-50 · S/N 2347Cancelled Oct 27, 1949 · Built 1948 · Sell Gilbert AN84350Aeronca 7AC · S/N 7AC-3038Cancelled Jun 14, 1949 · Sky-Line IncN99859Ercoupe 415-C · S/N 2482Cancelled Nov 16, 1948 · Lombard Airport Co IncN4659Ryan B1 · S/N 84Cancelled Oct 19, 1940 · Lombard Airport Company IncN2707Stinson SB-1 · S/N 90Cancelled Feb 19, 1932 · Gabriel George
Back to Lombard, IL