OpenAirDocs.org
Rio Hondo, TX

Cancelled registrations · 52

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 = 'TX' AND d.registrant_city = 'RIO HONDO'
  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.

N4128Mcgregor Donald E TANDEM ELITE · S/N 7-11-32Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 2005 · Garza Jose LN2548NCessna 120 · S/N 12804Cancelled Nov 15, 2019 · Revoked, canceled · Built 1947 · Waters WaylandN71209Cessna 182M · S/N 18259533Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1969 · Garcia Robert LN3500QCessna A188 · S/N 188-0450Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1968 · Alaniz Pedro DBAN280ZLuscombe 8A · S/N 3612Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1946 · Goode Flying Service IncN1628SSnow S2C · S/N 600-1176CCancelled Aug 9, 2012 · Registration expired, pending cancellation · Built 1963 · Goode Donald J DBAN40756Junge J A REPROROE MKIV TRIPLN · S/N 003Cancelled Jun 12, 2012 · Registration pending, canceled · Built 1994N42LBBull Leonard J SE5-A · S/N 080284Cancelled Jul 1, 2009 · Second triennial form not returned · Houston John WN3648TAir Tractor AT-301 · S/N 301-0233Cancelled Nov 21, 2006 · Exported to Mexico · Built 1979 · Texas Dusting Service IncN7616VAero Commander CALLAIR A-9B · S/N 1344Cancelled Oct 27, 1992 · Texas Dusting Ser IncN1728SSnow 600 S-2D · S/N 600-1328DCancelled Dec 31, 1979 · Exported to Mexico · Texas Dustiong Service IncN1649SSnow 600-S2C · S/N 6001205CCancelled Apr 14, 1975 · Exported to Mexico · Jones Martha AN69WBoeing A75N1 · S/N 75-4871Cancelled Feb 3, 1971 · Jones E JoeN63648Convair BT-13 · S/N 5710Cancelled Feb 2, 1971 · Jones Joe EN6035HPiper J3C-65 · S/N 19177Cancelled Jan 27, 1971 · Jones Joe EdmondN7013ZPiper PA-25-235 · S/N 25-2767Cancelled Dec 24, 1970 · Alaniz PedroN3675FNorth American SNJ-5 · S/N 43747Cancelled Jul 13, 1970 · Burke JeffN1752SAero Commander S2R · S/N 1452RCancelled Sep 10, 1969 · Exported to Mexico · Jones Joe EN4423YPiper PA-25-235 · S/N 25-4044Cancelled Jul 12, 1967 · Exported to Mexico · Texas Dusting Service IncN6582ZPiper PA-25-235 · S/N 25-2136Cancelled Jul 12, 1967 · Exported to Mexico · Built 1962 · Texas Dusting Service IncN3432LCessna TU206B · S/N U206-0732Cancelled May 8, 1967 · Exported to Mexico · Texas Dusting ServiceN3412LCessna TU206B · S/N U206-0712Cancelled Apr 11, 1967 · Exported to Mexico · Texas Dusting ServiceN4669FCessna P206A · S/N P206-0269Cancelled Aug 20, 1966 · Exported to Mexico · Built 1966 · Texas Dusting Service IncN4448YPiper PA-25-235 · S/N 25-4090Cancelled Aug 8, 1966 · Exported to Mexico · Texas Dusting Service IncN4401YPiper PA-25-235 · S/N 25-4007Cancelled Aug 5, 1966 · Exported to Mexico · Texas Dusting Service IncN70117Piper J-3 · S/N 17091Cancelled Mar 22, 1966 · Jones Joe EN7566ZPiper PA-25-235 · S/N 25-3625Cancelled Dec 16, 1965 · Exported to Mexico · Texas Dusting Service IncN7474ZPiper PA-25-235 · S/N 25-3479Cancelled Oct 25, 1965 · Exported to Mexico · Texas Dusting Service IncN6169ZPiper PA-25 · S/N 25-202Cancelled Oct 22, 1965 · Exported to Mexico · Jones Joe EN7557ZPiper PA-25-235 · S/N 25-3610Cancelled Oct 7, 1965 · Exported to Mexico · Texas Dusting Service IncN7562ZPiper PA-25-235 · S/N 25-3618Cancelled Oct 7, 1965 · Exported to Mexico · Texas Dusting Service IncN7541ZPiper PA-25-235 · S/N 25-3587Cancelled Oct 6, 1965 · Exported to Mexico · Texas Dusting Service IncN7567ZPiper PA-25-235 · S/N 25-3627Cancelled Oct 6, 1965 · Exported to Mexico · Texas Dusting Service IncN2419XCessna 182H · S/N 18256319Cancelled Sep 14, 1965 · Exported to Mexico · Built 1965 · Texas Dustin Service InN7495ZPiper PA-25-235 · S/N 25-3519Cancelled Sep 13, 1965 · Exported to Mexico · Texas Dusting Service IncN6193ZPiper PA-25 · S/N 25-227Cancelled Sep 7, 1965 · Exported to Mexico · Jones Joe EN7448ZPiper PA-25-235 · S/N 25-3438Cancelled Aug 31, 1965 · Exported to Mexico · Texas Dusting Service IncN7480ZPiper PA-25-235 · S/N 25-3488Cancelled Aug 31, 1965 · Exported to Mexico · Texas Dusting Service IncN7499ZPiper PA-25-235 · S/N 25-3461Cancelled Aug 31, 1965 · Exported to Mexico · Texas Dusting Service IncN4920UCessna 210E · S/N 21058620Cancelled Aug 23, 1965 · Exported to Mexico · Texas Dusting Service IncN7397ZPiper PA-25-235 · S/N 25-3360Cancelled Jul 15, 1965 · Exported to Mexico · Texas Dusting Service IncN4980CSnow S2A · S/N 1023Cancelled May 20, 1965 · Burke Peggy AN1612SSnow 600-S2C · S/N 600-1153CCancelled Sep 10, 1964 · Exported to Mexico · Jones Joe EN4974CSnow S2A · S/N 1017Cancelled Aug 26, 1964 · Exported to Mexico · Jones Joe EN1603SSnow 600-S2C · S/N 600-1140CCancelled Mar 5, 1964 · Exported to Mexico · Jones Joe EN3691FSnow S2A · S/N 1006Cancelled Sep 28, 1962 · Exported to Guatemala · Jones Joe EN1384CPiper PA-18A · S/N 18-2674Cancelled Apr 5, 1961 · Exported to Mexico · Jones Joe EN98154Piper J3C-65 · S/N 18316Cancelled Sep 11, 1958 · Merrell A WN47899Boeing D75N1 · S/N 75-4019Cancelled Feb 19, 1958 · Exported to Ecuador · Dyer Malcolm GN88306Piper J-3 · S/N 15924Cancelled Mar 1, 1955 · Exported to Mexico · Jones Joe E
Back to Rio Hondo, TX