Seguin, TX

Cancelled registrations · 67

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

N540HCStanton James R STAROS SA 260 · S/N 96-01Cancelled Nov 23, 2001 · Triennial form not returned · Hc & Nr IncN99VBeech V35 · S/N D-8097Cancelled Mar 15, 1999 · Triennial form not returned · Donegan BentonN1163VZlin Aero A S Z242L · S/N 0541Cancelled Oct 16, 1996 · Exported to Australia · Leach Phillip LN758SQCessna R172K · S/N R1723327Cancelled Jul 14, 1993 · Exported to Turkey · Petra Aviation IncN3096PPiper PA-23 · S/N 231015Cancelled May 14, 1992 · Triennial form not returned · Seguin Aviation IncN4253KNorth American NAVION · S/N NAV-4-1253Cancelled Jul 25, 1974 · Built 1948 · Milam William TN3015TCessna 320C · S/N 320C0015Cancelled Oct 9, 1973 · Selig MarvinN66AAinsworth 9 · S/N AD-312Cancelled Mar 15, 1972 · Exported to Mexico · Behrens Charles LN3941LCessna 172G · S/N 17254110Cancelled Feb 4, 1972 · Robert C MccartyN2475TNavion NAVION G · S/N NAV42475Cancelled Dec 29, 1970 · Navion Aircraft CorpN2535TNavion NAVION H · S/N NAV42535Cancelled Jun 29, 1970 · Exported to Mexico · Navion Aircraft CorpN2520TNavion NAVION H · S/N NAV-4-2522Cancelled Nov 14, 1969 · Exported to Germany · Navion Aircraft CorpN2511TNavion NAVION H · S/N NAV-4-2511Cancelled Oct 25, 1968 · Exported to Mexico · Navion Aircraft CorpN2508TNavion NAVION H · S/N NAV42508Cancelled Apr 15, 1968 · Exported to South Africa · Navion Aircraft CorpN2500TNavion NAVION G · S/N NAV42500Cancelled Feb 7, 1967 · Exported to Kenya · Navion Aircraft CoN2495TNavion NAVION G · S/N NAV42495Cancelled Apr 23, 1964 · Exported to Germany · Navion Aircraft CorpN984ND Simmons DSF · S/N 1Cancelled Mar 15, 1937 · Simmons Elsie
Back to Seguin, TX