OpenAirDocs.org
Birmingham, MI

Cancelled registrations · 56

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 = 'MI' AND d.registrant_city = 'BIRMINGHAM'
  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.

N549VXR4 Robotics R4 ROLLER · S/N R4RO 2015.101Cancelled Sep 3, 2019 · R4 Robotics IncN790LRR4 Robotics R4 ROLLER · S/N R4RO2016.108Cancelled Aug 14, 2019 · First renewal notice · R4 Robotics Inc A Division Of Robot & Vision IncN791PRR4 Robotics R4 ROLLER · S/N R4RO2016.107Cancelled Aug 14, 2019 · First renewal notice · R4 Robotics IncN5225HPiper PA-16 · S/N 16-27Cancelled Sep 7, 2018 · Revoked, canceled · Built 1949 · Boynton Fred W JrN6957HR4 Robotics R4 ROLLER · S/N R4R02016.102Cancelled May 29, 2018 · R4 Robotics IncN790KRR4 Robotics R4 ROLLER · S/N R4RO2016.103Cancelled May 29, 2018 · R4 Robotics IncN797URR4 Robotics R4 ROLLER · S/N R4RO2016.104Cancelled May 29, 2018 · R4 Robotics IncN797QRR4 Robotics R4S ROLLER · S/N R4S RO 2016.106Cancelled May 25, 2018 · R4 Robotics IncN798ARR4 Robotics R4S ROLLER · S/N R4SRO2016.105Cancelled May 25, 2018 · R4 Robotics IncN696CLRobot & Vision R4 QUAD · S/N R4Q2016-101Cancelled Apr 13, 2018 · R4 Robotics IncN83GCCrandall Gary E LONG-EZE · S/N 1507Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1990 · Crandell Gregory KN8053Dehavilland DH-89A · S/N 6907Cancelled Feb 4, 2017 · Revoked, canceled · Built 1941 · Foley Daniel SN8851CPiper PA-18A-135 · S/N 18-3258Cancelled May 11, 2015 · Sale reported, canceled · Built 1953N7917LBeech A23-24 · S/N MA-100Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1966 · Optimist Flyers IncN73JPMentag John C MINI 500 · S/N 78Cancelled Nov 14, 2013 · Registration expired, pending cancellation · Built 1996 · Premium Air IncN6852Rasor BENSEN B-8ME · S/N 1Cancelled Nov 12, 2013 · Revoked, canceled · Built 1975 · Rasor WmN7250ACessna 172 · S/N 29350Cancelled Nov 4, 2013 · Revoked, pending cancellation · Built 1956 · Bell Doyle EN67359Cessna 152 · S/N 15281777Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1978 · C Kunjappan John Md PcN24RTBeech B-60 · S/N P-329Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1975 · Commander Charter IncN1527FBalloon Works FIREFLY 7 · S/N 11029Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1981 · Aerial PromotionsN927WStinson SM-8A · S/N 4106Cancelled Sep 12, 2012 · Revoked, canceled · Built 1930 · Likich MichaelN1071RRaven S55A · S/N S55A-258Cancelled Dec 16, 2010 · Sale reported, pending cancellationN2729Transcreative COMMODORE I · S/N 002Cancelled Jul 20, 2009 · Registration revoked · Built 1969 · Balloon Club LtdN7886FCessna 150F · S/N 15063986Cancelled Sep 3, 2008 · Triennial form not returned · Built 1966 · Holcomb Ronald ON41423Piper J5A · S/N 51379Cancelled Nov 20, 2006 · Registration revoked · Built 1941 · Butler Roy IN24BPCessna P210N · S/N P21000499Cancelled Feb 17, 1999 · Triennial form not returned · Gramer Air IncN1976WBeech B19 · S/N MB-649Cancelled May 11, 1998 · Triennial form not returned · Goodwin Mack CN737UTCessna 172N · S/N 17269691Cancelled May 23, 1983 · C Kunjappan John M D P CN148JMBeech E18S · S/N BA-226Cancelled Mar 12, 1981 · Built 1957 · Emmett Robert AN333JBCessna 182J · S/N 18257338Cancelled Oct 11, 1979 · Built 1966 · Fitzgerald Lawrence JN8779KStinson 108-1 · S/N 108-1779Cancelled Jun 25, 1979 · Heyl Russell G JrN4310JPiper PA-28-140 · S/N 28-22683Cancelled Nov 14, 1972 · Exported to Canada · Phaneuf Charles HN4955JPiper PA-28R-180 · S/N 28R-30702Cancelled Jul 7, 1972 · Exported to Canada · Burton Mahler & Atlee S HartN8443XCessna 172C · S/N 17248943Cancelled Feb 7, 1972 · Built 1962 · Charter Investment IncN36179Taylorcraft DC-65 · S/N 4115Cancelled Jan 15, 1971 · David E SmithN2283APiper PA-22-135 · S/N 22-672Cancelled Dec 4, 1970 · Lakeland Flying Club IncN3436QCessna 320E · S/N 320E0036Cancelled Jan 28, 1969 · Beatty Hudson UN7006PPiper PA-24-250 · S/N 24-2150Cancelled Jan 14, 1969 · Exported to Canada · Marshall William R E Vulcan Laboratories IncN5647QMooney M20C · S/N 3022Cancelled May 12, 1968 · Built 1965 · Casady Frank A/Casady Aileen MN2779WMooney M20F · S/N 670027Cancelled Feb 6, 1968 · Macgregor NormanN83722Aeronca 7BCM/CONV · S/N 7AC-2400Cancelled Mar 1, 1963 · Exported to Canada · Berz Mary & Milton Berz Jr DBA Berz Flying ServiceN99974Forney 415-C · S/N 2597Cancelled Oct 13, 1961 · Kaan Stephen EN2495NCessna 140 · S/N 12748Cancelled Mar 19, 1959 · Exported to Canada · Nolan Richard DN8713CPiper PA-22-135 · S/N 22-1370Cancelled Jun 17, 1957 · Exported to Canada · Product Distributing CoN52167Fairchild M-62A · S/N T40-305Cancelled Mar 5, 1956 · Park Arnold LN64348Cessna T-50 · S/N 5653Cancelled Feb 17, 1956 · Main JohnN63861Interstate S-1B1 · S/N 198Cancelled Oct 24, 1955 · John F GregoryN51342Cessna T-50 · S/N 3811Cancelled May 22, 1952 · Acitelli Peter HN51412Aeronca 0-58B · S/N 058B-11813Cancelled Aug 2, 1951 · Bers Milton HN51411Aeronca 0-58B · S/N 1682Cancelled Jul 13, 1951 · Berz Airport
Back to Birmingham, MI