Olney, TX

Cancelled registrations · 285

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

N8507TAir Tractor AT-802 · S/N 802-0141Cancelled Mar 4, 2003 · Exported to Canada · Air Tractor IncN8507QAir Tractor AT-502B · S/N 502B-0654Cancelled Oct 29, 2002 · Exported to Brazil · Air Tractor IncN9148NAir Tractor AT-802 · S/N 8020119Cancelled Aug 6, 2002 · Exported to Spain · Built 2001 · Air Tractor IncN8505ZAir Tractor AT-802 · S/N 802-0138Cancelled Jun 12, 2002 · Exported to Spain · Air Tractor IncN8508QAir Tractor AT-802 · S/N 802-0137Cancelled Jun 7, 2002 · Exported to Spain · Air Tractor IncN91465Air Tractor AT-802 · S/N 802-0115Cancelled May 31, 2002 · Exported to Spain · Air Tractor IncN91373Air Tractor AT-802 · S/N 8020105Cancelled May 29, 2002 · Exported to Australia · Built 2001 · Air Tractor IncN85071Air Tractor AT-802 · S/N 802-0120Cancelled Feb 8, 2002 · Exported to Canada · Built 2001 · Air Tractor IncN8503QAir Tractor AT-502B · S/N 502B-0644Cancelled Jan 29, 2002 · Exported to Argentina · Air Tractor IncN91442Air Tractor AT-802 · S/N 802-0113Cancelled May 23, 2001 · Exported to Spain · Air Tractor IncN3159HAir Tractor AT-400 · S/N 400-0458Cancelled May 18, 2001 · Exported to Austria · Air Tractor IncN9143YAir Tractor AT-802 · S/N 802-0114Cancelled May 7, 2001 · Exported to Spain · Air Tractor IncN619LAAir Tractor AT-502B · S/N 502B-0619Cancelled Dec 8, 2000 · Exported to Costa Rica · Air Tractor IncN97ZLAir Tractor AT-802 · S/N 802-0049Cancelled Sep 14, 2000 · Exported to Croatia · Air Tractor IncN9107XAir Tractor AT-802 · S/N 802-0098Cancelled Jul 11, 2000 · Exported to Spain · Air Tractor IncN9094LAir Tractor AT-802 · S/N 802-0091Cancelled Jul 5, 2000 · Exported to Croatia · Air Tractor IncN9101NAir Tractor AT-802 · S/N 802-0090Cancelled Jul 5, 2000 · Exported to Croatia · Air Tractor IncN899LAAir Tractor AT-802 · S/N 802-0086Cancelled Jun 6, 2000 · Exported to South Africa · Air Tractor IncN91011Air Tractor AT-502B · S/N 502B-0615Cancelled May 19, 2000 · Exported to South Africa · Air Tractor IncN9087YAir Tractor AT-802 · S/N 802-0095Cancelled May 15, 2000 · Exported to Spain · Air Tractor IncN9049KAir Tractor AT-802 · S/N 802-0088Cancelled Apr 20, 2000 · Exported to Spain · Air Tractor IncN90115Air Tractor AT-802 · S/N 802-0080Cancelled Mar 10, 2000 · Exported to Spain · Air Tractor IncN90778Air Tractor AT-402A · S/N 402A-1113Cancelled Mar 8, 2000 · Exported to Brazil · Air Tractor IncN9042EAir Tractor AT-401B · S/N 401B-1111Cancelled Nov 24, 1999 · Exported to Argentina · Air Tractor IncN90718Air Tractor AT-402A · S/N 402A-1109Cancelled Nov 10, 1999 · Exported to Uruguay · Air Tractor IncN5055FAir Tractor AT-602 · S/N 602-0449Cancelled Nov 2, 1999 · Exported to Costa Rica · Air Tractor IncN90616Air Tractor AT-802 · S/N 802-0081Cancelled Oct 26, 1999 · Exported to Chile · Air Tractor IncN90432Air Tractor AT-401B · S/N 401B-1102Cancelled Oct 12, 1999 · Exported to Brazil · Air Tractor IncN9046ZAir Tractor AT-802A · S/N 802A-0084Cancelled Oct 12, 1999 · Exported to Australia · Air Tractor IncN9051VAir Tractor AT-802A · S/N 802A-0085Cancelled Oct 12, 1999 · Exported to Australia · Air Tractor IncN90667Air Tractor AT-502B · S/N 502B-0595Cancelled Oct 5, 1999 · Exported to Costa Rica · Air Tractor IncN90638Air Tractor AT-502B · S/N 502B-0593Cancelled Sep 28, 1999 · Exported to Costa Rica · Air Tractor IncN9031XAir Tractor AT-802 · S/N 802-0082Cancelled Sep 2, 1999 · Exported to Australia · Air Tractor IncN5066SAir Tractor AT-802 · S/N 802-0068Cancelled Jun 2, 1999 · Exported to Spain · Air Tractor IncN5020AAir Tractor AT-402A · S/N 402A-1056Cancelled May 27, 1999 · Exported to Spain · Air Tractor IncN9002XAir Tractor AT-401B · S/N 401B-1100Cancelled May 7, 1999 · Exported to Venezuela · Air Tractor IncN51668Air Tractor AT-502B · S/N 502B-0518Cancelled Feb 5, 1999 · Exported to Argentina · Air Tractor IncN5146EAir Tractor AT-402A · S/N 402A1089Cancelled Dec 28, 1998 · Exported to Argentina · Air Tractor IncN5117VAir Tractor AT-602 · S/N 6020507Cancelled Dec 22, 1998 · Exported to Argentina · Air Tractor IncN5176BAir Tractor AT-402A · S/N 402A1085Cancelled Dec 17, 1998 · Exported to Argentina · Air Tractor IncN5116BAir Tractor AT-802 · S/N 8020071Cancelled Dec 16, 1998 · Exported to Spain · Air Tractor IncN5035FAir Tractor AT-602 · S/N 6020502Cancelled Nov 24, 1998 · Exported to Chile · Air Tractor IncN5138UAir Tractor AT-402A · S/N 402A1088Cancelled Nov 13, 1998 · Exported to Argentina · Air Tractor IncN5170LAir Tractor AT-402A · S/N 402A1083Cancelled Nov 13, 1998 · Exported to Argentina · Air Tractor IncN51800Air Tractor AT-402A · S/N 402A1080Cancelled Nov 13, 1998 · Exported to Argentina · Air Tractor IncN5013NAir Tractor AT-402A · S/N 402A1070Cancelled Nov 12, 1998 · Exported to Brazil · Air Tractor IncN5181VAir Tractor AT-402A · S/N 402A1081Cancelled Nov 12, 1998 · Exported to Argentina · Air Tractor IncN5104YAir Tractor AT-402A · S/N 402A1077Cancelled Nov 10, 1998 · Exported to Argentina · Air Tractor IncN51782Air Tractor AT-401B · S/N 401B1078Cancelled Nov 10, 1998 · Exported to Brazil · Air Tractor IncN5157ZAir Tractor AT-402A · S/N 402A1079Cancelled Oct 30, 1998 · Exported to Argentina · Air Tractor Inc
Back to Olney, TX