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.

N503KNQuicksilver/Niswonger K MXL II · S/N 000482Cancelled Mar 21, 2017 · First renewal notice · Built 1994 · Martin Thomas FN81TXDassault-Breguet FALCON 10 · S/N 81Cancelled Dec 7, 2016 · Third renewal notice · Built 1976 · Diez De Pinos Carlos HN1020BCessna 208B · S/N KW1Cancelled Oct 11, 2016 · Revoked, canceled · Built 1961 · Bundrant William DN303SPRobinson Helicopter R44 · S/N 1436Cancelled Sep 15, 2016 · Exported to Mexico · Built 2004 · Spur Helicopters LLCN223AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49173Cancelled Nov 19, 2015 · Built 1983 · Frontera Flight Holdings IncN233AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49180Cancelled Nov 19, 2015 · Built 1983 · Frontera Flight Holdings IncN2571FBalloon Works FIREFLY 7-15 · S/N F7-824Cancelled May 6, 2015 · Registration expired, pending cancellation · Degast RobertN446TRHunter T E/Stiger R D J-6 KARATOO · S/N 3625Cancelled Dec 22, 2014 · Registration pending, canceledN1000BLockheed 18 · S/N 2622Cancelled Dec 11, 2014 · Registration expired, pending cancellation · Built 1943 · Humphries BillN2646YHughes Helicopters HUGHES 369D · S/N 410920DCancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1981 · Air Parts & Development CorpN5290XCessna 414 · S/N 414-0274Cancelled Nov 25, 2014 · Exported to Mexico · Built 1972 · Diez De Pinos Carlos HN773AFDouglas DC3C · S/N 19239Cancelled Nov 21, 2014 · Registration expired, pending cancellation · Built 1943 · American Air Freight Inc.N6435YPiper PA-23-250 · S/N 27-3736Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1967 · Delinda CameraN5546YPiper PA-23-250 · S/N 27-2646Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1964 · Schoelman A WN10FGCessna 500 · S/N 500-0295Cancelled Jul 7, 2014 · Exported to Mexico · Built 1976 · Frontera Flight Holdings IncN861BCFairchild SA227-AC · S/N AC487BCancelled Jun 25, 2014 · Exported to Mexico · Built 1981 · Frontera Flight Holdings IncN871BCFairchild SA227-AC · S/N AC-659BCancelled Jun 25, 2014 · Exported to Mexico · Built 1986 · Frontera Flight Holdings IncN555SDGates Learjet 25D · S/N 333Cancelled Jun 10, 2014 · Built 1981 · Joe Brand IncN3420Convair 640-340D · S/N 64Cancelled Apr 24, 2014 · Exported to Mexico · Built 1953 · Swain JeffN6662ZPiper PA-25-235 · S/N 25-2262Cancelled Sep 26, 2013 · Revoked, canceled · Built 1963 · Bourne Maurice W JrN8156GNorth American T-28A · S/N 513707Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Leuendecker Gary AN9249TPiper PA-38-112 · S/N 38-78A0296Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1978 · Enriquez DouglesN932GMBeech G18S · S/N BA-547Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1960 · Wood Flying Service IncN4834GCessna 172N · S/N 17273382Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1979N6518DCessna 172N · S/N 17272840Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1979N66240Cessna 150M · S/N 15075944Cancelled May 28, 2013 · Exported to Mexico · Built 1974 · Ballesteros Pedro MN88EZWeitzel Charles H VARIEZE · S/N 1124Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1979 · Neill Ralph WN7275VIntermountain CALLAIR A-9 · S/N 1291Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1966 · Wood Flying Service IncN30JDCessna 550 · S/N 550-0205Cancelled Apr 15, 2013 · Exported to Mexico · Built 1980 · Frontera Flight Holding IncN601GNCessna 500 · S/N 500-0214Cancelled Apr 3, 2013 · Exported to Mexico · Built 1974N825YCBeech E18S · S/N BA-273Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1957N617BTFairchild SA227-AC · S/N AC617Cancelled Feb 14, 2013 · Exported to Mexico · Swain Jeff JN548MCLockheed 18-56 · S/N 2244Cancelled Jan 30, 2013 · Sale reported, canceled · Built 1942N61NEFairchild SA227-AC · S/N AC-761BCancelled Dec 19, 2012 · Exported to Mexico · Frontera Flight Holdings IncN446GLFairchild SA227-AC · S/N AC-595Cancelled Nov 30, 2012 · Exported to Mexico · Swain Jeff JN640CMConvair 640-340D · S/N 104Cancelled Oct 17, 2012 · Exported to Mexico · Built 1966N3357YCessna 182E · S/N 18254357Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1962 · Nanez Rolando AN2204SDouglas DC3C · S/N 12798Cancelled Aug 14, 2012 · Registration pending, canceled · Built 1944N21GCCessna T337G · S/N P3370130Cancelled Aug 9, 2012 · Sale reported, canceled · Built 1973N1824FBeech 58TC · S/N TK-143Cancelled Aug 1, 2012 · Exported to Mexico · Lacy H DouglasN40662Piper J3L-65 · S/N 7423Cancelled Jun 4, 2012 · Revoked, canceled · Built 1941 · Morgan Donald BN696USRockwell International NA-265-65 · S/N 465-18Cancelled Dec 20, 2011 · Exported to Mexico · Built 1980 · Laredo Aviation Sales LLCN65KABeech C90 · S/N LJ-611Cancelled Dec 14, 2011 · Exported to Mexico · Built 1973 · Laredo Aviation Sales LLCN5121CBeech B35 · S/N D-2406Cancelled Nov 21, 2011 · Third renewal notice · Built 1950 · Spurrier BillN379ESCessna 182S · S/N 18280017Cancelled Sep 15, 2011 · Exported to Mexico · Built 1997 · Stw Technologies LLCN6203TCessna T206H · S/N T20608874Cancelled Jun 24, 2011 · Exported to Mexico · Built 2008N5072LCessna T182T · S/N T18208167Cancelled Nov 12, 2010 · Exported to Mexico · Built 2002 · Yellow Diamond IncN551SCBell Helicopter Textron Canada 407 · S/N 53844Cancelled Aug 19, 2009 · Exported to Russia · Built 2008 · Sanchez Bell LLCN1278YCessna 150B · S/N 15059678Cancelled Jun 30, 2009 · Registration revoked · Built 1962 · Smith Raymond LN773DMRobinson Helicopter R44 II · S/N 11345Cancelled Dec 17, 2008 · Exported to Poland · Built 2006 · Santa Maria Ranch Company Inc
Back to Laredo, TX