OpenAirDocs.org
Laredo, TX

Cancelled registrations · 238

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

N399GRCessna T206H · S/N T2068029Cancelled Jul 17, 2008 · Exported to Uruguay · Built 1999 · Sayre David HN265MKNorth American NA-265-60 · S/N 306-90Cancelled Jun 5, 2008 · Exported to Mexico · Built 1974 · Perez Jose JN6612WCessna P210N · S/N P21000805Cancelled Feb 11, 2008 · Built 1982 · Vmh Developers IncN131BHNorth American NA-265-40 · S/N 282-18Cancelled May 2, 2007 · Triennial form not returned · Built 1964 · Jett Racing & Sales IncN350ACPiper PA-23-250 · S/N 27-7954094Cancelled Jun 29, 2006 · Exported to Mexico · Built 1979N8502LPiper PA-25-260 · S/N 25-4916Cancelled Mar 2, 2006 · Exported to Mexico · Built 1969N8267DRockwell International NA-265-80 · S/N 38058Cancelled Aug 5, 2005 · Exported to Mexico · Integrity Aircraft IncN7960UCessna 172F · S/N 17251960Cancelled Mar 18, 2005 · Triennial form not returned · Built 1964 · Diez De Pinos Carlos HN14TNRockwell International NA-265-80 · S/N 380-40Cancelled Sep 20, 2004 · Exported to Mexico · Built 1975 · Z-Air IncN40ZANorth American NA-265-40 · S/N 282-112Cancelled Aug 27, 2004 · Exported to Mexico · Built 1973 · Z-Air IncN510TBNorth American T-39A · S/N 61-0683Cancelled Aug 3, 2004 · Exported to Mexico · Jett Racing And Sales IncN2071SCessna 414A · S/N 414A0673Cancelled Jun 10, 2004 · Exported to Mexico · Integrity Aircraft IncN7270ZCessna T206H · S/N T20608083Cancelled Jul 10, 2003 · Exported to Mexico · Built 1999 · Integrity Aircraft IncN952LCRobinson Helicopter R44 · S/N 0719Cancelled Apr 24, 2003 · Built 2000 · Rio Grande Helicopters IncN402ATCessna 402B · S/N 402B0612Cancelled May 31, 2002 · Exported to Mexico · Built 1974 · Integrity Aircraft IncN971SLRobinson Helicopter R22 · S/N 2750Cancelled Apr 22, 2002 · Triennial form not returned · Built 1997 · Smith Helicopters IncN1ZNAgusta A109E · S/N 11108Cancelled Oct 10, 2001 · Exported to Mexico · Built 2001 · Integrity Aircraft IncN45VLLearjet 45 · S/N 139Cancelled Jul 26, 2001 · Exported to Mexico · Integrity Aircraft IncN982SHRobinson Helicopter R22 BETA · S/N 2786Cancelled Jul 11, 2001 · Triennial form not returned · Smith Helicopters IncN198GBRockwell International NA-265-80 · S/N 380-32Cancelled Mar 20, 2001 · Exported to Mexico · Aero Del IncN357CYBeech C90A · S/N LJ-1178Cancelled Mar 6, 2001 · Exported to Canada · Rancho Viejo Cattle Co LtdN73227Bell 47G-2A · S/N 2708Cancelled Dec 8, 2000 · Exported to Mexico · Aero Carga International IncN188RGates Learjet 25D · S/N 305Cancelled Nov 14, 2000 · Exported to Mexico · Integrity Aircraft IncN958MNorth American T39E · S/N 157354Cancelled May 26, 2000 · Exported to Mexico · Jett SalesN956MNorth American T-39D · S/N 150548Cancelled Apr 27, 2000 · Exported to Mexico · Jett SalesN957MNorth American T-39D · S/N 150969Cancelled Apr 27, 2000 · Exported to Mexico · Jett SalesN959MNorth American T-39D · S/N 150547Cancelled Apr 27, 2000 · Exported to Mexico · Jett SalesN960MNorth American T-39D · S/N 150543Cancelled Apr 27, 2000 · Exported to Mexico · Jett SalesN961MNorth American T-39D · S/N 151336Cancelled Apr 27, 2000 · Exported to Mexico · Jett SalesN9VLLearjet 31A · S/N 174Cancelled Oct 26, 1999 · Exported to Mexico · Laredo National BankN774AFDouglas C54B-DC · S/N 10460Cancelled Oct 17, 1998 · Triennial form not returned · American Air Freight CoN510TANorth American T-39A · S/N 603482Cancelled Sep 14, 1998 · Exported to Mexico · Jett Racing And Sales IncN510TCNorth American T-39A · S/N 624474Cancelled Sep 14, 1998 · Exported to Mexico · Jett Racing And Sales IncN510TDNorth American T-39A · S/N 603487Cancelled Sep 14, 1998 · Exported to Mexico · Jett Racing And Sales IncN556BWAero Commander 500-B · S/N 1625215Cancelled Sep 1, 1998 · Mgs CorpN502RRNorth American NA-265-40 · S/N 282013Cancelled Jun 18, 1998 · Exported to Mexico · Jett Racing & Sales IncN8FKPiper PA-31P · S/N 31P7300111Cancelled Jan 27, 1998 · Exported to Mexico · Jett SalesN54644Piper PA-23-250 · S/N 274063Cancelled Aug 28, 1997 · Exported to Mexico · Integrity Aircraft IncN4357YPiper PA-25-235 · S/N 254856Cancelled Feb 10, 1997 · Exported to Mexico · Rivera Pablo AntonioN4323WBeech A36 · S/N E526Cancelled Nov 25, 1996 · Triennial form not returned · Dunivant TonyN1597FDouglas R6D-1 · S/N 43700Cancelled May 29, 1996 · Triennial form not returned · Allcair Air TransportN8398YPiper PA-30 · S/N 301142Cancelled Apr 2, 1996 · Triennial form not returned · Neitzke Norvell VN64AMNorth American NA-265-60 · S/N 3067Cancelled Jan 31, 1994 · Exported to Mexico · Aero Center IncN754UABoeing 737-244 · S/N 19707Cancelled Nov 2, 1992 · Exported to Mexico · Integrity Aircraft IncN5000RBeech C-50 · S/N CH321Cancelled Nov 13, 1991 · Exported to Mexico · Hofman WolfN91337Piper PA-38-112 · S/N 3881A0170Cancelled Apr 16, 1991 · Triennial form not returned · Intrepid Air CorpN8681LPiper PA-25-235 · S/N 25-5136Cancelled Feb 2, 1987 · Exported to Mexico · Rivera Sergio AN9046ZAircraft Parts & Dev. A-9B · S/N 5004Cancelled Jul 2, 1986 · Exported to Mexico · Aircraft Parts & Development CorpN8590JCessna 150G · S/N 15066490Cancelled Mar 27, 1984 · Administratively canceled · Hamilton G B IIIN824SCessna 310D · S/N 39107Cancelled Jan 10, 1984 · Administratively canceled · Humphries Bill
Back to Laredo, TX