OpenAirDocs.org
Hurst, TX

Cancelled registrations · 91

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

N25020Bell 407 · S/N 53540Cancelled Jan 14, 2003 · Exported to India · Built 2002 · Bell Helicopter Textron IncN1082PBell 412EP · S/N 36305Cancelled Oct 25, 2002 · Exported to Mexico · Bell Helicopter Textron IncN10797Bell 407 · S/N 53523Cancelled Oct 24, 2002 · Exported to Chile · Bell Helicopter Textron IncN1082SBell 427 · S/N 56034Cancelled Oct 9, 2002 · Exported to Indonesia · Built 2002 · Bell Helicopter Textron IncN4341YBell Helicopter Textron 206B/NTH · S/N 5259Cancelled Feb 1, 2002 · Exported to Taiwan · Built 1998 · Bell Helicopter Textron IncN1211NBell 206B · S/N 4453Cancelled Dec 4, 2000 · Exported to Croatia · Bell Helicopter Textron IncN1214ZBell 206B · S/N 4445Cancelled Dec 4, 2000 · Exported to Croatia · Bell Helicopter Textron IncN9026SBell 412EP · S/N 36260Cancelled Nov 30, 2000 · Exported to Macedonia · Bell Helicopter Textron IncN52184Bell 412EP · S/N 36187Cancelled Nov 7, 2000 · Exported to Venezuela · Bell Helicopter Textron IncN52194Bell 412EP · S/N 36186Cancelled Nov 7, 2000 · Exported to Venezuela · Bell Helicopter Textron IncN2101GBell 412EP · S/N 36169Cancelled Aug 16, 2000 · Exported to Venezuela · Bell Helicopter Textron IncN68036Bell 206B · S/N 5246Cancelled Jul 10, 2000 · Exported to Taiwan · Bell Helicopter Textron IncN8981JPiper PA-28-180 · S/N 28-3004Cancelled Mar 13, 2000 · Triennial form not returned · Harville Lawrence RN82744Bell 206B-III · S/N 4510Cancelled Jan 24, 2000 · Exported to Bulgaria · Bell Helicopter Textron IncN61198Bell 407 · S/N 53376Cancelled Aug 19, 1999 · Exported to Canada · Bell Helicopter Textron IncN42845Bell 412EP · S/N 36197Cancelled Mar 25, 1999 · Exported to Colombia · Bell Helicopter Textron IncN4445PBell 206-L4 · S/N 52211Cancelled Mar 4, 1999 · Exported to Brazil · Bell Helicopter Textron IncN70774Bell 412EP · S/N 36194Cancelled Jun 19, 1998 · Exported to Thailand · Bell Helicopter Textron IncN9130JBell 206B · S/N 4469Cancelled Jun 4, 1998 · Exported to Brazil · Bell Helicopter Textron IncN4219YBell 412EP · S/N 36171Cancelled Dec 18, 1997 · Exported to Thailand · Bell Helicopter Textron IncN6934Hestla JUNSTER · S/N LC101Cancelled Nov 7, 1997 · Triennial form not returned · Hestla Lewis BN206BWBell 206B · S/N 4202Cancelled May 2, 1995 · Exported to Philippines · Bell Helicopter Textron IncN2130FCessna U206 · S/N U206-0330Cancelled Aug 30, 1982 · Built 1964 · Primate Construction IncN4889HCessna 152 · S/N 15284000Cancelled Aug 27, 1982 · Built 1979 · Rucker T EN6754KRepublic RC-3 · S/N 1042Cancelled Mar 2, 1982 · Yarbrough T. E.N46887North American F-86L · S/N 533693Cancelled May 2, 1977 · Vicars J DN4885VBellanca 17-30 · S/N 30127Cancelled Mar 4, 1977 · Woodard Associates And CompanyN1223YCessna 150B · S/N 15059623Cancelled Dec 28, 1976 · Montgomery Charles K & Harry G RoseN3804GCessna U206B · S/N U206-0804Cancelled May 26, 1976 · Built 1967 · Hodges Jeanette SN8462UCessna 172F · S/N 17252362Cancelled Oct 17, 1974 · Clark Thurman DN8978JPiper PA-28-180 · S/N 28-3001Cancelled Oct 9, 1974 · Green C LN60037Cessna 150J · S/N 15070024Cancelled Sep 10, 1974 · Osborn Bobby DBA Bobbys Planes N PartsN5673ZPiper PA-22-108 · S/N 22-9499Cancelled Aug 9, 1974 · Baker Glenn EN5496EBell H13G · S/N 1214Cancelled Feb 4, 1972 · Taylor E MilamN49486Cessna T-50 · S/N 2315Cancelled Jan 24, 1972 · Bishop Thomas WN3643DCessna 310 · S/N 35343Cancelled Feb 25, 1971 · Arnold J MN4296JPiper PA-28-140 · S/N 28-22665Cancelled Oct 21, 1970 · Hodges Billy MN6365ECessna 172 · S/N 46465Cancelled Sep 10, 1970 · Graves Mary IN4083GBell 47G-3B-2 · S/N 6713Cancelled Jun 19, 1969 · Exported to Canada · Bell Helicopter CoN8912HRyan NAVION · S/N NAV-4-912Cancelled Oct 29, 1963 · Overton Robert JN65KCessna 172 · S/N 28663Cancelled Jul 11, 1957 · B & B Truckers Inc
Back to Hurst, TX