OpenAirDocs.org
Oak Park, IL

Cancelled registrations · 36

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 = 'OAK PARK'
  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.

N54CVOlmsted Charles A RV-4 · S/N CV-001Cancelled Nov 21, 2019 · Registration expired, pending cancellation · Built 1997 · Stanard LeeN21805Piper J3F-50 · S/N 2647Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1938 · Evans Donald RN7103TCessna 172 · S/N 46703Cancelled Nov 21, 2017 · Revoked, canceled · Built 1959 · Firegan Sales CoN75979Howard DGA-15P · S/N 714Cancelled Feb 4, 2017 · Revoked, canceled · Built 1943 · Sorensen La Mar WN4645PPiper PA-23-250 · S/N 27-166Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1960 · Hanley John FN2452BBriegleb BG-12B · S/N 124Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1967 · Kronberger WarrenN1561ZBeech P35 · S/N D6862Cancelled Aug 27, 1992 · Triennial form not returned · Macgregor R SN99RNBeech K35 · S/N D6065Cancelled Apr 15, 1991 · Triennial form not returned · Laurel Leasing IncN4173QCessna 310Q · S/N 310Q0482Cancelled Sep 21, 1976 · Built 1972 · Grigg E R NN2300PPiper PA-22 · S/N 22-2712Cancelled Jul 18, 1974 · Westside Businessmen'S Flying ClubincN5736LAmerican AA-1 · S/N AA1-0136Cancelled Apr 23, 1974 · Rooker Marvin RN801RBeech K35 · S/N D-5974Cancelled Nov 15, 1972 · Le Baron TedN61536Boeing N2S-2 · S/N 75-1334Cancelled Dec 15, 1971 · Priester George JN2364BGlobe GC-1B · S/N 3664Cancelled Dec 31, 1970 · Boerste F J & J L WeissN60593Fairchild M-62C · S/N 396HOCancelled Oct 7, 1970 · Russell Donald EN8004CPiper PA-22-135 · S/N 22-2193Cancelled Jun 30, 1970 · Sievert William RN9928ZBeech TC-45H · S/N 5111584Cancelled Dec 1, 1967 · Exported to Brazil · Smith John JN5152YPiper PA-23-250 · S/N 27-2188Cancelled Sep 7, 1966 · Exported to Australia · Suburban Trust & Savings BankN3899EAeronca S11AC · S/N 11AC-S-88Cancelled Oct 7, 1965 · Nick J TerketN39489Stinson 10A · S/N 8189Cancelled May 20, 1965 · Built 1941 · Posselt RoyN6215UMooney M20C · S/N 2054Cancelled Dec 12, 1964 · Rasmussen MelN3706APiper PA-22-135 · S/N 22-1946Cancelled Nov 26, 1958 · Harris William RN69460Cessna T-50 · S/N 1188Cancelled Feb 20, 1958 · Built 1941 · Air Transport Associates IncN1205CPiper PA-22-135 · S/N 22-1013Cancelled Dec 19, 1956 · Price James EN79233Cessna T-50 · S/N 1556Cancelled Mar 19, 1956 · Air Transport Associates IncN65175Consolidated Vultee BT-13 · S/N 7382Cancelled Feb 17, 1956 · Parisi Edward JN66091Cessna T-50 · S/N 1409Cancelled Feb 17, 1956 · Air Transport Associates IncN5544NConsolidated Vultee BT-13A · S/N 11794Cancelled Sep 7, 1951 · Taylor Carl CN9888HNorth American SNJ-4 · S/N 88-12643Cancelled Jul 24, 1951 · Priester George JN9889HNorth American SNJ-4 · S/N 88-10919Cancelled Jul 24, 1951 · Priester George JN12888Stinson JR. R · S/N 8530Cancelled Oct 14, 1948 · Priester George JN11112Driggs SKYLARK 3 · S/N 3011Cancelled Aug 15, 1940 · Built 1931 · Rapley Herbert JN6484Stearman C3-B · S/N 184Cancelled Aug 26, 1934 · Fay H FreadhoffN9729Fokker SUPER UNIVERSAL · S/N 829Cancelled Dec 12, 1933 · Little A MN5414Curtiss JN4D · S/N 16Cancelled Mar 14, 1930 · Cary Walter MN7927Phantom PHANTOM · S/N 1Cancelled Jan 16, 1930 · Built 1928 · Phantom Knight Aircraft Company
Back to Oak Park, IL