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.

N1558PAir Tractor AT-502B · S/N 502B0187Cancelled Jan 15, 1993 · Exported to Brazil · Air Tractor IncN15575Air Tractor AT-401 · S/N 4010885Cancelled Sep 8, 1992 · Exported to Mexico · Air Tractor IncN1557RAir Tractor AT-401 · S/N 4010883Cancelled Sep 8, 1992 · Exported to Mexico · Air Tractor IncN15468Air Tractor AT-401 · S/N 4010879Cancelled Jul 24, 1992 · Exported to Mexico · Air Tractor IncN15163Air Tractor AT-401 · S/N 4010833Cancelled May 15, 1992 · Exported to Brazil · Air Tractor IncN15384Air Tractor AT-401 · S/N 4010859Cancelled Apr 22, 1992 · Exported to Mexico · Air Tractor IncN1529NAir Tractor AT-502 · S/N 5020162Cancelled Feb 18, 1992 · Exported to Spain · Air Tractor IncN1503GAir Tractor AT-502 · S/N 5020140Cancelled Jul 8, 1991 · Exported to Portugal · Air Tractor IncN1507UAir Tractor AT-502 · S/N 5020143Cancelled Jul 3, 1991 · Exported to Portugal · Air Tractor IncN73173Air Tractor AT-401 · S/N 401-0679Cancelled Jun 10, 1988 · Exported to Spain · Air Tractor IncN7304XAir Tractor AT-500 · S/N 500-0001Cancelled Jun 16, 1987 · Air Tractor IncN7304QAir Tractor AT-301 · S/N 301-0600Cancelled Aug 12, 1986 · Exported to Colombia · Air Tractor IncN8885SAir Tractor AT-301 · S/N 301-0224Cancelled Nov 27, 1979 · Exported to Australia · Air Tractor IncN8830SAir Tractor AT-301 · S/N 301-0209Cancelled Jul 30, 1979 · Exported to Australia · Air Tractor IncN8776SAir Tractor AT-301 · S/N 301-0191Cancelled Jun 22, 1979 · Exported to Mexico · Built 1979 · Air Tractor IncN8803SAir Tractor AT-302 · S/N 302-0196Cancelled May 22, 1979 · Exported to Guatemala · Built 1979 · Air Tractor IncN8821SAir Tractor AT-301 · S/N 0197Cancelled Jul 10, 1976 · Exported to Australia · Air Tractor IncN82697Champion 7AC · S/N 7AC-1344Cancelled Jun 8, 1971 · Thomas Allan HN9493RSnow S2C · S/N 1131CCancelled Feb 3, 1971 · Snow Aeronautical CorpN8884QAero Commander S2R · S/N 1484RCancelled Nov 4, 1970 · Exported to Portugal · Aero Commander IncN4880NPiper J3C-65 · S/N 10004Cancelled Sep 23, 1970 · Civil Air Patrol Texas WingN8808QAero Commander S2R · S/N 1508RCancelled Jun 8, 1970 · Exported to Venezuela · Aero Commander IncN24278Aeronca 65-CA · S/N L-7470Cancelled Jan 16, 1969 · Poor Boy Flying ClubN1743SAero Commander S2R · S/N 1453RCancelled Dec 12, 1968 · Exported to El Salvador · Built 1968 · American Rockwell CorpN1723SAero Commander S2R · S/N 1430RCancelled Jun 20, 1968 · Exported to Martinique · Aero Commander IncN1701SSnow 600-S2C · S/N 600-1296CCancelled Oct 25, 1965 · Exported to Nicaragua · Snow Aeronautical CorpN1632SSnow 600-S2C · S/N 600-1190CCancelled Feb 13, 1964 · Snow Aeronautical CorpN9482RSnow S2C · S/N 1121CCancelled Jun 8, 1962 · Exported to Jamaica · Snow Aero CorpN9489RSnow S2C · S/N 1128CCancelled Jun 8, 1962 · Exported to Jamaica · Snow Aeronautical CoN9475RSnow S2A · S/N 1114ACancelled May 21, 1962 · Exported to Mexico · Snow Aeronautical CorpN9442RSnow S2B · S/N 1074BCancelled Jun 13, 1961 · Exported to Colombia · Snow Aeronautical CoN9410RSnow S2B · S/N 1040Cancelled May 2, 1961 · Exported to Panama · Snow Aeronautical CoN9420RSnow S2A · S/N 1050ACancelled Aug 22, 1960 · Exported to Panama · Snow Aeronautical CoN9422RSnow S2A · S/N 1052ACancelled Aug 15, 1960 · Snow Aeronautical CoN35964Piper J3L-65 · S/N 6678Cancelled Oct 24, 1951 · Built 1941 · Mayhew William L
Back to Olney, TX