OpenAirDocs.org
Northbrook, IL

Cancelled registrations · 53

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

N3556FPiper PA-31-350 · S/N 31-8052066Cancelled Nov 13, 2023 · Exported to Panama · Cohen GadiN2030ZCessna 150C · S/N 15059830Cancelled Nov 4, 2023 · Revoked, canceled · Built 1963 · Mid States Aviation CorpN147DFKrueger Stephen G VKNG DRGNFLY MK II · S/N 423Cancelled May 7, 2022 · Registration expired, pending cancellation · Krueger Stephen GN84503Aeronca 7AC · S/N 7AC3205Cancelled Jul 19, 2018 · Revoked, canceled · Built 1946 · Mid States Aviation CorpN9240VMooney M20C · S/N 690060Cancelled Nov 21, 2017 · Revoked, canceled · Built 1969 · Fidelity Properties IncN7138MCessna 175 · S/N 55438Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1958 · Mid States Aviation CorpN45CPGates Lear Jet 25C · S/N 25C-073Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Henry Air LtdN58155Mooney M20J · S/N 24-1581Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Lowrie Harman SN1144UMooney M20J · S/N 24-1188Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1981 · Lowrie Harman SN18SMCessna 414 · S/N 414-0548Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1974 · Seren Company IncN4764JCessna 172N · S/N 17273674Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1979 · American Aviation IncN34CCColmar HP-18 · S/N 65Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Colmar Charles FN222THGoldman A Richard DDS DRAGONFLY · S/N 491Cancelled Aug 1, 2012 · Registration expired, pending cancellation · Built 1991 · Goldman A Richard DdsN41906Piper PA-28-151 · S/N 28-7415355Cancelled Jun 12, 2012 · Revoked, canceled · Built 1974 · Turnbull James TN1219SSchweizer SGS 2-33A · S/N 209Cancelled Oct 26, 2009 · Triennial form not returned · Built 1971 · Sky Soaring IncN9370UCessna 150M · S/N 15078319Cancelled May 2, 2007 · Triennial form not returned · Built 1976 · Makotyn AndrzejN8261JBeech A36 · S/N E-2807Cancelled Dec 5, 2005 · Second triennial form not returned · Built 1993 · Howard GeorgeN902GTGrumman G-1159 · S/N 2Cancelled Jul 31, 2003 · Built 1977 · Guild Investments LLCN9251NRemos EOL 2R2 · S/N E1920Cancelled Oct 24, 1998 · Triennial form not returned · Akro-Viper IncN69LFPiper PA-32-300 · S/N 327840003Cancelled Jun 6, 1991 · Triennial form not returned · Lee Phillip Forman LtdN9988DPiper PA-22-150 · S/N 226780Cancelled Mar 20, 1991 · Exported to United Kingdom · Brown Jack SN4889MCessna 152 · S/N 15284488Cancelled Jul 30, 1982 · Exported to Austria · Built 1980 · American Aviation IncN5305MCessna 152 · S/N 15284522Cancelled Jul 2, 1982 · Exported to Switzerland · American Aviation Inc Aircraft Rental DivisionN511JLBeech 95-A55 · S/N TC453Cancelled Nov 3, 1978 · Potter MartinN6338VHelio H-295 · S/N 1230Cancelled Feb 2, 1978 · Exported to Canada · Baenziger RobertN5263ECessna 180 · S/N 50563Cancelled Aug 8, 1974 · Mid States Aviation CorporationN91516Cessna 182M · S/N 18259803Cancelled May 6, 1974 · Mid States Aviation CorporationN9458VMooney M20E · S/N 700035Cancelled Aug 14, 1972 · Lease A Plane International CorpN7090LCessna 310K · S/N 310K0190Cancelled May 10, 1972 · Air Exchange IncN8738YPiper PA-30 · S/N 30-1892Cancelled Jan 14, 1971 · Exported to Australia · Lease-A-Plane Internatinal IncN2205YCessna 177 · S/N 17700005Cancelled Jun 29, 1970 · Built 1967 · Mid-States Aviation CorporationN5842SBeech S35 · S/N D-7751Cancelled Jun 23, 1970 · David B PivanN5506FPiper PA-28-140 · S/N 28-24846Cancelled Apr 13, 1970 · Exported to Canada · Mid-States Aviation CorpN7352JPiper PA-28-140 · S/N 28-24703Cancelled Apr 13, 1970 · Exported to Canada · Midstates Aviation CorporationN7368JPiper PA-28-140 · S/N 28-24723Cancelled Apr 13, 1970 · Exported to Canada · Mid-States Aviation CorporationN890EWPiper PA-30 · S/N 30-1695Cancelled Jan 9, 1969 · Exported to Denmark · Built 1968 · Mid States Aviation CorpN811RCessna 310B · S/N 35692Cancelled Jul 30, 1968 · Exported to Canada · Mid-States Aviation CorpN5628YPiper PA-23-250 · S/N 27-2740Cancelled Jul 8, 1966 · W Lee Pryor And Elmer F Layden JrN6630TCessna 150A · S/N 15059030Cancelled May 22, 1965 · Mid States Aviation CorpN2753UCessna 172D · S/N 17250353Cancelled May 21, 1965 · Mid States Aviation CorporationN3401KBell 47G · S/N 1401Cancelled Jul 11, 1962 · Exported to Canada · Mid-States Aviation CorpN6473XCessna 180 · S/N 18050973Cancelled Oct 5, 1961 · Exported to Canada · Mid States Aviation CorpN9978HCessna T-50 · S/N 4520Cancelled Oct 24, 1956 · Eggan Edwin BN91763North American NAVION · S/N NAV-4-481Cancelled Feb 24, 1956 · Helsing Ovide A & Mattes Harold CN53665Cessna T-50 · S/N 5869Cancelled Nov 29, 1955 · Mid States Aviation CorpN8080ACessna 170B · S/N 20932Cancelled Sep 24, 1954 · Mid States Aviation CorpN3366APiper PA-22-135 · S/N 22-1666Cancelled Mar 25, 1954 · Stoll John O JrN77128Cessna 120 · S/N 11586Cancelled Jun 7, 1951 · Built 1946 · Mid State Aviation CorpN4892MPiper PA-11 · S/N 11-413Cancelled Oct 8, 1948 · Built 1947 · Turgeon Flying Service IncN6338KRepublic RC-3 · S/N 562Cancelled Oct 8, 1948 · Turgeon Flying Service Inc
Back to Northbrook, IL