Irving, TX

Cancelled registrations · 184

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

N4061WBell 430 · S/N 49098Cancelled Oct 14, 2003 · Exported to Japan · Mitsui Bussan Aerospace CorpN234DEGrammont Derel L STREAK SHADOW MG · S/N DEG-2Cancelled Jun 17, 2002 · Triennial form not returned · Grammont Derel LN1001XTexas Helicopter M79S · S/N 101-79Cancelled May 20, 2002 · Second triennial mailing, no response · Built 1981 · Texas Helicopter CorporationN3000BBell 427 · S/N 56031Cancelled May 17, 2002 · Exported to Japan · Mitsui Bussan Aerospace CorpN9183NBell 430 · S/N 49082Cancelled Feb 5, 2002 · Exported to Japan · Built 2001 · Mitsui Bussan Aerospace CorpN6147PBell 412EP · S/N 36277Cancelled Dec 4, 2001 · Exported to Japan · Built 2001 · Mitsui Bussan Aerospace CorpN63908Bell 412EP · S/N 36245Cancelled Dec 6, 2000 · Exported to Japan · Mitsui Bussan Aerospace CorpN63901Bell 412EP · S/N 36244Cancelled Nov 21, 2000 · Exported to Japan · Mitsui Bussan Aerospace CorpN6379EBell 412EP · S/N 36247Cancelled Nov 16, 2000 · Exported to Japan · Mitsui Bussan Aerospace CorpN6400JBell 412EP · S/N 36243Cancelled May 11, 2000 · Exported to Japan · Mitsui Bussan Aerospace CorpN6039UBell 412EP · S/N 36238Cancelled Nov 16, 1999 · Exported to Japan · Mitsui Bussan Aerospace CorpN60506Bell 412EP · S/N 36237Cancelled Nov 10, 1999 · Exported to Japan · Mitsui Bussan Aerospace CorpN234DEGrammont Derel L JUNGSTER I · S/N DEG-2Cancelled Apr 14, 1999 · Triennial form not returned · Grammont Derel LN44454Bell 412EP · S/N 36210Cancelled Jan 7, 1999 · Exported to Japan · Mitsui Bussan Aerospace CorporationN4445VBell 412EP · S/N 36211Cancelled Jan 7, 1999 · Exported to Japan · Mitsui Bussan Aerospace CorporationN4446MBell 412EP · S/N 36214Cancelled Jan 7, 1999 · Exported to Japan · Mitsui Bussan Aerospace CorporationN44319Bell 206-L4 · S/N 52209Cancelled Nov 3, 1998 · Exported to Japan · Mitsui Bussan Aerospace CorporationN6317XBell 412EP · S/N 36175Cancelled Dec 23, 1997 · Exported to Japan · Mitsui Bussan Aerospace CorporationN1208JBell 206B · S/N 4456Cancelled Dec 16, 1997 · Exported to Japan · Mitsui Bussan Aerospace CorporationN5609JBell 412EP · S/N 36174Cancelled Dec 2, 1997 · Exported to Japan · Mitsui Bussan Aerospace CorpN7224QBell 412EP · S/N 36167Cancelled Nov 6, 1997 · Exported to Japan · Mitsui Bussan Aerospace CorporationN7208HBell 430 · S/N 49031Cancelled Oct 28, 1997 · Exported to Japan · Mitsui Bussan Aerospace CorporationN7251KBell 206-L4 · S/N 52197Cancelled Oct 22, 1997 · Exported to Japan · Mitsui Bussan Aerospace CorporationN33238Cessna TU206F · S/N U20602686Cancelled Aug 19, 1997 · Exported to Mexico · Caves Aviation CoN62837Bell 430 · S/N 49009Cancelled May 7, 1997 · Exported to Japan · Mitsui Bussan Aerospace CorporationN1216HBell 407 · S/N 53064Cancelled Jan 29, 1997 · Exported to Japan · Mitsui Bussan Aerospace CorporationN1148QBell 206B · S/N 4437Cancelled Jan 14, 1997 · Exported to Japan · Mitsui Bussan Aerospace CorporationN86699Bell 206B · S/N 4438Cancelled Jan 14, 1997 · Exported to Japan · Mitsui Bussan Aerospace CorporationN34961Bell 412EP · S/N 36135Cancelled Dec 17, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorporationN34957Bell 412EP · S/N 36134Cancelled Dec 11, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorporationN1164RBell 412EP · S/N 36132Cancelled Nov 26, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorporationN2097QBell 412EP · S/N 36131Cancelled Nov 5, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorpN6267JBell 412EP · S/N 36130Cancelled Oct 25, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorpN2124NPiper PA-28RT-201T · S/N 28R7931134Cancelled Aug 19, 1996 · Exported to Germany · Belser Mark EN6266TBell 412EP · S/N 36124Cancelled Aug 13, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorpN92115Bell 412EP · S/N 36117Cancelled May 24, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorporationN9210TBell 206B · S/N 4387Cancelled Mar 21, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorpN92110Bell 206B · S/N 4388Cancelled Mar 21, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorpN92130Bell 412EP · S/N 36118Cancelled Mar 6, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorporationN3293GBell 412EP · S/N 36115Cancelled Feb 16, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorporationN91940Bell 206B · S/N 4380Cancelled Feb 12, 1996 · Exported to JapanN3293ABell 412EP · S/N 36114Cancelled Jan 23, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorporationN3292NBell 412EP · S/N 36109Cancelled Jan 19, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorporationN32929Bell 412EP · S/N 36113Cancelled Jan 18, 1996 · Exported to Japan · Mitsui Bussan Aerospace CorporationN3292XBell 412EP · S/N 36111Cancelled Dec 5, 1995 · Exported to Japan · Mitsui Bussan Aerospace CorpN3292RBell 412EP · S/N 36110Cancelled Nov 17, 1995 · Exported to Japan · Mitsui Bussan Aerospace CorporationN64050Bell 206-L4 · S/N 52145Cancelled Nov 9, 1995 · Exported to Japan · Mitsui Bussan Aerospace CorporationN64049Bell 206-L4 · S/N 52147Cancelled Nov 3, 1995 · Exported to Japan · Mitsui Bussan Aerospace CorporationN64070Bell 206-L4 · S/N 52144Cancelled Nov 1, 1995 · Exported to Japan · Mitsui Bussan Aerospace CorporationN82627Bell 412EP · S/N 36107Cancelled Oct 27, 1995 · Exported to Japan · Mitsui Bussan Aerospace Corporation
Back to Irving, TX