Santa Teresa, NM

Cancelled registrations · 19

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 = 'NM' AND d.registrant_city = 'SANTA TERESA'
  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.

N737GXCessna 172N · S/N 17269417Cancelled Mar 12, 2019 · Exported to Mexico · Built 1977 · Pinos Altos Import & Export IncN5315CCessna T210N · S/N 21063730Cancelled Feb 6, 2019 · Exported to Mexico · Built 1979 · Pinos Altos Import & Export IncN6974LCessna 310K · S/N 310K0074Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1966 · Cp Aviation Services CoN210MKCessna T210N · S/N 21064833Cancelled Jul 12, 2017 · Exported to Mexico · Built 1984 · Pinos Altos Import & Export IncN190WCessna 190 · S/N 7537Cancelled Oct 2, 2015 · Third renewal notice · Perlan Aviation LLCN621BMMikoyan Gurevich MIG 15 · S/N 1B01621Cancelled Mar 24, 2014 · Macguire JohnN303ATCessna 172S · S/N 172S9319Cancelled Feb 7, 2014 · Exported to Mexico · Built 2003 · Francis Capital Leasing LLCN145SPBoeing 707-323B · S/N 20174Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1969 · Tokoph DavidN5530BCessna 182 · S/N 33530Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1956 · Beuden MarcelN614BMMikoyan Gurevich MIG 15 · S/N 1B01614Cancelled Mar 25, 2013 · Registration expired, pending cancellation · Macguire JohnN138UPilatus P-2/06 · S/N 58Cancelled Jul 27, 2012 · Exported to Germany · Built 1950 · Babel Francois PN4054MPilatus P3-05 · S/N 47322Cancelled Nov 24, 2010 · Exported to Switzerland · Built 1958 · Haberling Hermann HpN5299ACessna T210N · S/N 21063355Cancelled Aug 5, 2009 · Exported to Mexico · Built 1979 · Alarcon ArmandoN756HBCessna TU206G · S/N U20604094Cancelled Nov 10, 2008 · Exported to Mexico · Built 1977 · Alarcon ArmandoN5290BCessna 152 · S/N 15283828Cancelled Sep 5, 2008 · Triennial form not returned · Built 1979 · Ttea IncN58171Cameron Balloons O-77 · S/N 5017Cancelled Sep 25, 2003 · Second triennial mailing, no response · Built 1983 · Stanton Ronald LN319CHLearjet 31A · S/N 041Cancelled Jun 5, 2001 · Exported to Philippines · Hurd C W JrN8104NBoeing 727-25 · S/N 18255Cancelled Dec 2, 1997 · Exported to Kenya · Tokoph DavidN96GSLockheed 1329 · S/N 5068Cancelled Jan 17, 1991 · Tokoph David
Back to Santa Teresa, NM