OpenAirDocs.org
Mobile, AL

Cancelled registrations · 206

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 = 'AL' AND d.registrant_city = 'MOBILE'
  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.

N4602YRobinson Helicopter R44 II · S/N 13110Cancelled Apr 22, 2011 · Exported to Russia · Tradewinds Helicopters IncN4470DRobinson Helicopter R44 II · S/N 13068Cancelled Mar 18, 2011 · Exported to Brazil · Built 2010 · Tradewinds Helicopters IncN244THRobinson Helicopter R44 II · S/N 13052Cancelled Jan 12, 2011 · Exported to Brazil · Built 2010 · Tradewinds Helicopters IncN244TWRobinson Helicopter R44 II · S/N 12990Cancelled Aug 31, 2010 · Exported to Brazil · Tradewinds Helicopters IncN70ZZSchempp-Hirth VENTUS 2CM · S/N 100Cancelled Nov 9, 2009 · Built 2001 · Rettig Fred AN122RRoberts CHASE YC-122C · S/N 49-2882Cancelled Sep 18, 2009 · Registration revoked · Built 1953 · Mobile Aircraft IncN5525ACessna 210N · S/N 21063480Cancelled Nov 20, 2008 · Exported to Brazil · Built 1979 · Teledyne Continental Motors IncN256DCDiamond Aircraft Ind DA20-C1 · S/N C0253Cancelled Aug 11, 2008 · Exported to Sweden · Built 2004 · Douglas Kelley PN7190VMooney M20F · S/N 22-1188Cancelled May 12, 2008 · Exported to Canada · Built 1975 · Robinson Willis EN38510Piper PA-32R-300 · S/N 32R-7780436Cancelled Jan 25, 2008 · Triennial form not returned · Built 1977 · Burton Brothers Management Co IncN68501Bellanca 8KCAB · S/N 40-72Cancelled Dec 14, 2007 · Triennial form not returned · Built 1972 · Reynolds Markward NN2282LSieck Robert H GENESIS · S/N 25Cancelled Nov 19, 2007 · Triennial form not returned · Sieck Robert HN804MCCessna 152 · S/N 15285525Cancelled Jul 31, 2007 · Exported to India · Built 1982 · M C Airlease IncN1729SAero Commander 600 S-2D · S/N 600-1329DCancelled Apr 6, 2007 · Built 1966 · Barber Robert RN6388MStinson 108-3 · S/N 108-4388Cancelled Mar 12, 2007 · Triennial form not returned · Built 1948 · Wendell Terry DN440CMMaxted Charles RV6 · S/N 20539Cancelled Jan 23, 2007 · Triennial form not returned · Built 1996 · Bryars Glenn FN650TTCessna 650 · S/N 650-0046Cancelled Dec 14, 2006 · Exported to Canada · Charter Services IncN105ELCessna 150J · S/N 15071050Cancelled Sep 19, 2005 · Built 1969 · Hickman Robert DN1399Conner Arthur R RAF 2000 · S/N H-2-04-15-617Cancelled Jul 28, 2005 · Built 2004 · Conner Arthur RN5157TCessna R182 · S/N R18201826Cancelled Jan 11, 2005 · Triennial form not returned · Built 1981 · Propco IncN2963RPiper PA-28R-200 · S/N 28R-35346Cancelled Nov 10, 2004 · Triennial form not returned · Built 1969 · Gwin John TN24543Cessna 152 · S/N 15280322Cancelled Nov 8, 2003 · Triennial form not returned · Built 1977 · M C Airlease IncN2308ZBeech 23 · S/N M-22Cancelled Oct 9, 2003 · Second triennial mailing, no response · Built 1962 · Loreman ReidN95745Cessna 182Q · S/N 18266616Cancelled Jun 11, 2003 · Triennial form not returned · Built 1978 · Mills William WN2234WRolladen-Schneider OHG LS1-F · S/N 343Cancelled Dec 31, 2001 · Exported to Germany · Built 1974 · Wielschair IncN1946BWiggins William S JR R A F 2000 GTX · S/N H2-94-5-117Cancelled Jul 14, 2000 · Triennial form not returned · Wiggins William S JrN4BHNord STAMPE SV4C · S/N 279/453Cancelled Jun 22, 2000 · Exported to Belgium · Hallett Lawrence J JrN455SLCessna 411 · S/N 4110028Cancelled Feb 4, 2000 · Triennial form not returned · Fowler Lynn EN5350UVanden Bosch Thann E EIPPER MXL II · S/N A/F-1348Cancelled Apr 27, 1999 · Triennial form not returned · Dees Andrew CN757XXCessna 152 · S/N 15280096Cancelled Mar 20, 1997 · Mc Aviation IncN5144XJohnstone Douglas I RANS S-6ES COYOTE II · S/N 1092365Cancelled Aug 20, 1996 · Triennial form not returned · Johnstone Douglas IN700YACessna 310C · S/N 35868Cancelled Mar 28, 1996 · Van Antwerp Daniel JN3016ZMcdonnell-Douglas DC-10-30 · S/N 48266Cancelled Mar 11, 1996 · Exported to United Kingdom · Sky Leasing IncN2282LSieck Robert H SR MXL II SPORT · S/N 519Cancelled Sep 26, 1995 · Sieck Robert H SrN100ASSmoak Robert Alan RANS S-12 · S/N 049011Cancelled Mar 1, 1995 · Triennial form not returned · Smith Donald H JrN6284QCessna 401A · S/N 401A0084Cancelled Jun 16, 1993 · Triennial form not returned · Maceluch R W TrusteeN9578HCessna 172M · S/N 17266241Cancelled Oct 26, 1992 · Triennial form not returned · Freiberg Alan EN72CPCessna 210N · S/N 21062970Cancelled Sep 3, 1992 · Exported to South Africa · Colonial Printing Co IncN757GACessna 152 · S/N 15279718Cancelled May 29, 1991 · Exported to Spain · Mobile Aero LeasingN414BTCessna 414 · S/N 4140040Cancelled Mar 14, 1991 · Exported to Germany · Gold Coast Acft Sls & Brokerage IncN7030YPiper PA-30 · S/N 3031Cancelled Dec 17, 1990 · Calley Nicholas ON4632KCessna 182P · S/N 18263634Cancelled Nov 6, 1990 · Triennial form not returned · T C M Flying Club IncN6673TCessna 150A · S/N 15059073Cancelled Apr 3, 1984 · Sale reported · Built 1960N2056GCessna 182A · S/N 51356Cancelled Oct 12, 1982 · Sabine John BN2HSSchleicher ASW-15B · S/N 15225Cancelled Jul 24, 1982 · Built 1972 · Smith Henry RN7345TCessna 182RG · S/N R18200030Cancelled Apr 12, 1982 · Exported to Canada · Nelson BurlN75409Jernigan BENSEN B-8M · S/N 1Cancelled Oct 14, 1981 · Jernigan Van LN2659BAero Commander 560 · S/N 159Cancelled May 13, 1981 · Built 1954 · Lapeyrouse Grain CorpN2611VCessna 170 · S/N 18243Cancelled Nov 18, 1980 · Built 1948 · Huie Geo DN8529YPiper PA-30 · S/N 30-1690Cancelled Oct 10, 1980 · Aircraft Corp
Back to Mobile, AL